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;
    }