protected void grdvwEdit_RowUpdating(object sender, GridViewUpdateEventArgs e) { Holiday_mst obj = new Holiday_mst(); Holiday_mst obj1 = new Holiday_mst(); string hdate, vardate; string hdesc1, id; int hid, sid, varholidaydate; hdate = ((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[1].Controls[1]).Text; hdesc1 = ((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[2].Controls[1]).Text; id = Convert.ToString(grdvwEdit.Rows[e.RowIndex].Cells[0].Text); hid = Convert.ToInt32(id); sid = Convert.ToInt32(drpsite.SelectedValue); string[] tempdate = ((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[1].Controls[1]).Text.ToString().Split(("/").ToCharArray()); vardate = tempdate[0] + "/" + tempdate[1] + "/" + tempdate[2]; varholidaydate = obj.Get_By_HolidayDate_Siteid(sid, vardate); objholiday = objholiday.Get_Description_By_Holidayid(hid); if ((objholiday.Holidaydate == vardate) && (objholiday.Description != "")) { objholiday.Holidayid = hid; objholiday.Holidaydate = hdate; objholiday.Description = hdesc1; objholiday.Siteid = sid; objholiday.Update(); grdvwEdit.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else if ((varholidaydate == 0) && (hdate != "") && (hdesc1 != "")) { objholiday.Holidayid = hid; objholiday.Holidaydate = hdate; objholiday.Description = hdesc1; objholiday.Siteid = sid; objholiday.Update(); grdvwEdit.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else if ((hdate == "") || (hdesc1 == "")) { lblerrmsg.Text = "Holiday Date or Description should not be empty"; } else { lblerrmsg.Text = Resources.MessageResource.erralready.ToString(); } }
protected void grdvwEdit_RowUpdating(object sender, GridViewUpdateEventArgs e) { Holiday_mst obj = new Holiday_mst(); Holiday_mst obj1 = new Holiday_mst(); string hdate, vardate; string hdesc1,id; int hid, sid, varholidaydate; hdate = ((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[1].Controls[1]).Text; hdesc1 = ((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[2].Controls[1]).Text; id = Convert.ToString(grdvwEdit.Rows[e.RowIndex].Cells[0].Text); hid = Convert.ToInt16(id); sid = Convert.ToInt16(drpsite.SelectedValue); string[] tempdate =((TextBox)grdvwEdit.Rows[e.RowIndex].Cells[1].Controls[1]).Text.ToString().Split(("/").ToCharArray()); vardate = tempdate[0] + "/" + tempdate[1] + "/" + tempdate[2]; varholidaydate = obj.Get_By_HolidayDate_Siteid(sid, vardate); objholiday = objholiday.Get_Description_By_Holidayid(hid); if ((objholiday.Holidaydate == vardate)&&(objholiday.Description!="")) { objholiday.Holidayid = hid; objholiday.Holidaydate = hdate; objholiday.Description = hdesc1; objholiday.Siteid = sid; objholiday.Update(); grdvwEdit.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else if ((varholidaydate == 0) &&( hdate!="") && (hdesc1 != "")) { objholiday.Holidayid = hid; objholiday.Holidaydate = hdate; objholiday.Description = hdesc1; objholiday.Siteid = sid; objholiday.Update(); grdvwEdit.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else if ((hdate == "") ||(hdesc1 == "" )) { lblerrmsg.Text = "Holiday Date or Description should not be empty"; } else { lblerrmsg.Text = Resources.MessageResource.erralready.ToString(); } }
public int Update_Holiday_mst_By_id(Holiday_mst objHoliday) { return (int)ExecuteNonQuery(Sp_Holiday_Update, new object[] { objHoliday.Siteid, objHoliday.Holidayid, objHoliday.Holidaydate, objHoliday.Description }); }
public int Insert_Holiday_mst(Holiday_mst objHoliday) { return (int)ExecuteNonQuery(Sp_Holiday_Insert, new object[] { objHoliday.Siteid, objHoliday.Holidayid, objHoliday.Holidaydate, objHoliday.Description }); }
public CollectionBase GenerateHoliday_mstCollection(ref IDataReader returndata) { BLLCollection<Holiday_mst> col = new BLLCollection<Holiday_mst>(); while (returndata.Read()) { Holiday_mst obj = new Holiday_mst(); DateTime holidaydatetime = new DateTime(); holidaydatetime = (DateTime)returndata["holidaydate"]; obj.Holidaydate = holidaydatetime.ToString(); obj.Description = (string)returndata["Description"]; obj.Siteid = (int)returndata["Siteid"]; col.Add(obj); } returndata.Close(); returndata.Dispose(); return col; }
public object GenerateHolidaydesciption_mstObject(ref IDataReader returndata) { Holiday_mst obj = new Holiday_mst(); while (returndata.Read()) { DateTime Mydatetime = new DateTime(); Mydatetime = (DateTime)returndata["Holidaydate"]; obj.Holidaydate = Mydatetime.ToString(); obj.Description = (string)returndata["Description"]; obj.Holidayid = (int)returndata["Holidayid"]; obj.Siteid = (int)returndata["Siteid"]; } returndata.Close(); returndata.Dispose(); return obj; }