Please Help in this interresting question

Question

there r two fields in my database"LowSeason"&"HighSeason"

 according to bellow code  if we pick dates within  month 11 we pick rent from "LowSeason"

and if we pick dates within   month 12 we pick rent from "HighSeason"

but i want that  when i pick startdate from month 11 end end date from month 12 rent should be pick acording to the seasons

i.e startdate=31/11/2008  & enddate =3/12/2008 

for month 11  that is  "LowSeason"  rent is 20$  per day

and for month 12  that is  "HighSeason" rent is 35$ per day

toal rent should be 55.

 

if ((totdays >= 2) && (totdays <= 6) && (start.Month == 11) || (end.Month == 11) )

{

rent = Convert.ToInt32(rd["LowSeason"].ToString());

}

 

else if (totdays >= 2 && totdays <= 6 && (start.Month == 12) || (end.Month == 12) )

{

rent = Convert.ToInt32(rd["HighSeason"].ToString());

}

total rent=totdays*rent;