I have the following code:

```
int value = 0;
int day = 0;           
int record = db.Orders.Where(x => x.Order_Date.Value.Year == DateTime.Now.Year
    && x.Order_Date.Value.Month == DateTime.Now.Month
    && x.Order_Date.Value.Day == DateTime.Now.Day).Count();
if (record > 0)
{
    value = int.Parse(db.Orders.OrderByDescending(x => x.Order_Id).Select(y => y.Order_Id).First().ToString());
    value += 1;
}
else
{
    day = Convert.ToInt32(DateTime.Now.ToString("dd") + DateTime.Now.ToString("MM") + DateTime.Now.ToString("yy"));
    value = day + 0001;
}

```

I want to save the order id in `ddmmyysomevalue` like `0501150001` if it is first order.

I do have above code but how to split `0501150001` like `050115` and `0001` and then increment `0002` for the next order and make it `0501150000` thereby `0501150009` to `0501150010` and make the above code meaningful.