public JsonResult AddHoliday(string date, string narration) { HolidaySP spHoliday = new HolidaySP(); try { HolidayInfo infoHoliday = new HolidayInfo(); { DateTime curdate = Convert.ToDateTime(date); infoHoliday.Date = curdate; if (narration != null) { infoHoliday.Narration = narration.Trim(); } else { infoHoliday.Narration = string.Empty; } infoHoliday.HolidayName = string.Empty; infoHoliday.Extra1 = string.Empty; infoHoliday.Extra2 = string.Empty; spHoliday.HolidayAddWithIdentity(infoHoliday); } HolidaySettingsDate(date); } catch (Exception ex) { return(Json(new { error = "failed" })); } return(Json(new { error = "success" })); }
private decimal HolidaySettings(string date) { HolidaySP spHoliday = new HolidaySP(); DateTime cur_date = Convert.ToDateTime(date); decimal decResult = spHoliday.HolliDayChecking(cur_date); return(decResult); }
/// <summary> /// Function to check the selected date is holiday or not /// </summary> /// <returns></returns> public decimal HolidaySettings() { HolidaySP spHoliday = new HolidaySP(); DateTime date = this.dtpCompanyCurrentDate.Value; this.txtCompanyCurrentdate.Text = date.ToString("dd MMM yyyy"); decimal decResult = spHoliday.HolliDayChecking(date); return(decResult); }
public DataTable GetHolidays(string date) { DateTime cur_date = Convert.ToDateTime(date); string strMonth = cur_date.ToString("MMMMyyyy"); string dtpMonth = strMonth.Substring(0, 3); string dtpYear = cur_date.Year.ToString(); HolidaySP spHoliday = new HolidaySP(); DataTable dtblHolidaySettings = new DataTable(); dtblHolidaySettings = spHoliday.HoildaySettingsViewAllLimited(dtpMonth.ToString(), dtpYear.ToString()); return(dtblHolidaySettings); }
public JsonResult SaveAllHoliday(string cur_month, string tableData) { HolidaySP spHoliday = new HolidaySP(); try { List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData); if (cur_month == null) { cur_month = Convert.ToString(DateTime.Now); } DateTime curdate = Convert.ToDateTime(cur_month); string strMonth = curdate.ToString("MMMMyyyy"); string dtpMonth = strMonth.Substring(0, 3); string dtpYear = curdate.Year.ToString(); spHoliday.HolidaySettingsDeleteByMonth(dtpMonth.ToString(), dtpYear.ToString()); HolidayInfo infoHoliday = new HolidayInfo(); int inrowcount = items.Count; for (int i = 0; i < inrowcount; i++) { DateTime date = Convert.ToDateTime(items[i]["date"]); infoHoliday.Date = date; if (items[i]["narration"] != null) { string strNarration = Convert.ToString(items[i]["narration"]); infoHoliday.Narration = strNarration.Trim(); } else { infoHoliday.Narration = string.Empty; } infoHoliday.HolidayName = string.Empty; infoHoliday.Extra1 = string.Empty; infoHoliday.Extra2 = string.Empty; spHoliday.HolidayAddWithIdentity(infoHoliday); } HolidaySettingsDate(cur_month); } catch (Exception ex) { return(Json(new { error = "failed" })); } return(Json(new { error = "success" })); }
public JsonResult EditHoliday(string date, string narration) { HolidaySP spHoliday = new HolidaySP(); try { HolidayInfo infoHoliday = new HolidayInfo(); { DateTime curdate = Convert.ToDateTime(date); string strMonth = curdate.ToString("MMMMyyyydd"); string dtpMonth = strMonth.Substring(0, 3); string dtpYear = curdate.Year.ToString(); string dtpDay = strMonth.Substring(strMonth.Length - 2, 2); decimal id = spHoliday.HolidaySettingsSearchByDate(dtpMonth, dtpYear, dtpDay).HolidayId; infoHoliday.HolidayId = id; infoHoliday.Date = curdate; if (narration != null) { infoHoliday.Narration = narration.Trim(); } else { infoHoliday.Narration = string.Empty; } infoHoliday.HolidayName = string.Empty; infoHoliday.ExtraDate = DateTime.Now; infoHoliday.Extra1 = string.Empty; infoHoliday.Extra2 = string.Empty; spHoliday.HolidayEdit(infoHoliday); } HolidaySettingsDate(date); } catch (Exception ex) { return(Json(new { error = "failed" })); } return(Json(new { error = "success" })); }
public JsonResult DeleteHoliday(string date) { HolidaySP spHoliday = new HolidaySP(); try { DateTime curdate = Convert.ToDateTime(date); string strMonth = curdate.ToString("MMMMyyyydd"); string dtpMonth = strMonth.Substring(0, 3); string dtpYear = curdate.Year.ToString(); string dtpDay = strMonth.Substring(strMonth.Length - 2, 2); decimal id = spHoliday.HolidaySettingsSearchByDate(dtpMonth, dtpYear, dtpDay).HolidayId; spHoliday.HolidayDelete(Convert.ToDecimal(id)); } catch (Exception ex) { return(Json(new { error = "failed" })); } return(Json(new { error = "success" })); }
public JsonResult ClearHoliday(string cur_month) { HolidaySP spHoliday = new HolidaySP(); try { if (cur_month == null) { cur_month = Convert.ToString(DateTime.Now); } DateTime curdate = Convert.ToDateTime(cur_month); string strMonth = curdate.ToString("MMMMyyyy"); string dtpMonth = strMonth.Substring(0, 3); string dtpYear = curdate.Year.ToString(); spHoliday.HolidaySettingsDeleteByMonth(dtpMonth.ToString(), dtpYear.ToString()); } catch (Exception ex) { return(Json(new { error = "failed" })); } return(Json(new { error = "success" })); }