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" })); }
/// <summary> /// Function for save /// </summary> public void SaveFunction() { try { spHoliday.HolidaySettingsDeleteByMonth(dtpMonth.Text.ToString(), dtpYear.Text.ToString()); if (dgvHolidayRegister.Rows.Count > 0) { foreach (DataGridViewRow dgvRow in dgvHolidayRegister.Rows) { infoHoliday.Date = DateTime.Parse(dgvRow.Cells[0].Value.ToString()); if (dgvRow.Cells["dgvtxtNarration"].Value != null) { string strNarration = dgvRow.Cells["dgvtxtNarration"].Value.ToString(); infoHoliday.Narration = strNarration.Trim(); } else { infoHoliday.Narration = string.Empty; } infoHoliday.HolidayName = string.Empty; infoHoliday.Extra1 = string.Empty; infoHoliday.Extra2 = string.Empty; spHoliday.HolidayAddWithIdentity(infoHoliday); } } Messages.SavedMessage(); Clear(); CalenderFill(); } catch (Exception ex) { MessageBox.Show("HO4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to Holiday table and return Id /// </summary> /// <param name="holidayinfo"></param> /// <returns></returns> public bool HolidayAddWithIdentity(HolidayInfo holidayinfo) { bool isSave = true; try { isSave = SPHoliday.HolidayAddWithIdentity(holidayinfo); } catch (Exception ex) { MessageBox.Show("HSBll8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isSave); }
public bool HolidayAddWithIdentity(HolidayInfo holidayinfo) { bool isStatus = false; try { isStatus = spHoliday.HolidayAddWithIdentity(holidayinfo); } catch (Exception ex) { MessageBox.Show("SB3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isStatus); }
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" })); }