//To Bind HolidayGrid #region [Bind Holiday Grid] public DataSet HolidayGridBind_DL(EWA_Holiday objEWA) { DataSet ds = new DataSet(); try { prmList = new string[4]; prmList[0] = "@Action"; prmList[1] = objEWA.Action; prmList[2] = "@OrgID"; prmList[3] = objEWA.OrgId; ds = ObjHelper.FillControl(prmList, "SP_Holiday"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } else { return(null); } } catch (Exception) { // GeneralErr(exp.Message.ToString()); throw; } }
//To Perform Insert,Update,Delete and Search Actions On tblHoliday Table #region [Perform Actions On Holiday] public int HolidayAction_DL(EWA_Holiday objEWA) { try { cmd = new SqlCommand("SP_Holiday", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", objEWA.Action); cmd.Parameters.AddWithValue("@HolidayId", objEWA.HolidayId); cmd.Parameters.AddWithValue("@HolidayName", objEWA.HolidayName); cmd.Parameters.AddWithValue("@HolidayDate", objEWA.HolidayDate); cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId); con.Open(); int flag = cmd.ExecuteNonQuery(); con.Close(); return(flag); } catch (Exception ex) { int err = ((System.Data.SqlClient.SqlException)(ex)).Number; if (err == 547 && objEWA.Action == "Delete") { throw new SystemException("Record is in use !!!"); } else { throw ex; } } finally { con.Close(); cmd.Dispose(); } }
//To Call HolidayGridBind #region [Holiday Grid Bind] public DataSet HolidayGridBind_BL(EWA_Holiday objEWA) { try { DataSet ds = objDL.HolidayGridBind_DL(objEWA); return(ds); } catch (Exception) { throw; } }
public int HolidayAction_BL(EWA_Holiday objEWA) { try { int flag = objDL.HolidayAction_DL(objEWA); return(flag); } catch (Exception) { throw; } }
//Holiday Grid Bind #region [Holiday Grid Bind] private void GrdHolidayBind() { try { EWA_Holiday objEWA = new EWA_Holiday(); objEWA.Action = "GetHoliday"; objEWA.OrgId = orgId.ToString(); ds = objBL.HolidayGridBind_BL(objEWA); GrdHoliday.DataSource = ds; GrdHoliday.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Perform Action for Holiday #region [Perform Action] private void Action(string strAction) { try { EWA_Holiday objEWA = new EWA_Holiday(); objEWA.Action = strAction; if (strAction == "Update" || strAction == "Delete") { objEWA.HolidayId = ViewState["HolidayId"].ToString(); } objEWA.HolidayName = txtHolidayName.Text.Trim(); objEWA.HolidayDate = txtHolidayDate.Text.Trim(); objEWA.OrgId = orgId.ToString(); int flag = objBL.HolidayAction_BL(objEWA); if (flag > 0) { if (strAction == "Save") { msgBox.ShowMessage("Record Saved Successfully !!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull); } else if (strAction == "Update") { msgBox.ShowMessage("Record Updated Successfully !!!", "Updated", UserControls.MessageBox.MessageStyle.Successfull); } else if (strAction == "Delete") { msgBox.ShowMessage("Record Deleted Successfully !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull); } GrdHolidayBind(); LoadForm(); } else if (flag == -1) { string msg = "Data is Already exist!!!"; msgBox.ShowMessage(msg, "Information", UserControls.MessageBox.MessageStyle.Information); } else { if (strAction == "Save") { msgBox.ShowMessage("Unable to Save !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } else if (strAction == "Update") { msgBox.ShowMessage("Unable to Update !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } else if (strAction == "Delete") { msgBox.ShowMessage("Unable to Delete !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }