public ActionResult SundayHoliday(int year)
{
List <DateTime> Dates;
int userid = Convert.ToInt32(Session["UserId"]);
Dates = GetAllSatAndSuns(year);
foreach (var date in Dates)
{
var item = Serverdb.tblHolidayManagments.Where(m => m.FromDate == date && m.ToDate == date && m.HolidayManagmentName == "Sunday").ToList();
if (item.Count == 0)
{
tblHolidayManagment obj = new tblHolidayManagment();
obj.HolidayManagmentName = "Sunday";
obj.HolidayManagmentDesc = "Sunday";
obj.HolidayType = 3;
obj.FromDate = date;
obj.ToDate = date;
obj.isActive = true;
obj.isDelete = false;
obj.CreatedBy = userid;
obj.CreatedOn = DateTime.Now;
obj.daysDuration = 1;
Serverdb.tblHolidayManagments.Add(obj);
Serverdb.SaveChanges();
}
}
return(Redirect("Calendar"));
}
public string saveCalendarItem(CalendarItem dbItem)
{
string response = "";
try
{
int userid = Convert.ToInt32(Session["UserId"]);
string fDat = dbItem.startDate;
string[] frDate = fDat.Split(' ');
fDat = frDate[2] + '-' + frDate[1] + '-' + frDate[3];
string tDat = dbItem.endDate;
string[] toDate = tDat.Split(' ');
tDat = toDate[2] + '-' + toDate[1] + '-' + toDate[3];
DateTime fromdate = Convert.ToDateTime(fDat);
DateTime todate = Convert.ToDateTime(tDat);
int daydiffrnc = Convert.ToInt32((todate - fromdate).TotalDays) + 1;
if (daydiffrnc == 0)
{
daydiffrnc = 1;
}
if (dbItem.id != 0)
{
//updated
var obj = Serverdb.tblHolidayManagments.Where(m => m.HolidayManagmentId == dbItem.id).FirstOrDefault();
obj.HolidayManagmentName = dbItem.name;
obj.HolidayManagmentDesc = dbItem.name;
obj.HolidayType = dbItem.location;
obj.FromDate = fromdate;
obj.ToDate = todate;
obj.daysDuration = daydiffrnc;
obj.ModifiedBy = userid;
obj.ModifiedOn = DateTime.Now;
Serverdb.SaveChanges();
response = "Added";//this is same because in jquery using this string for success message displaying purpose
}
else
{
// add new
var item = Serverdb.tblHolidayManagments.Where(m => m.FromDate == fromdate && m.ToDate == todate && m.HolidayManagmentName == dbItem.name).ToList();
if (item.Count == 0)
{
if (dbItem.name != null)
{
tblHolidayManagment obj = new tblHolidayManagment();
obj.HolidayManagmentName = dbItem.name;
obj.HolidayManagmentDesc = dbItem.name;
obj.HolidayType = dbItem.location;
obj.FromDate = fromdate;
obj.ToDate = todate;
obj.daysDuration = daydiffrnc;
obj.isActive = true;
obj.isDelete = false;
obj.CreatedBy = userid;
obj.CreatedOn = DateTime.Now;
Serverdb.tblHolidayManagments.Add(obj);
Serverdb.SaveChanges();
response = "Added";
}
else
{
response = "NotAdded";
}
}
else
{
response = "NotAdded";
}
}
}
catch
{
response = "NotAdded";
}
return(response);
}