protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
        {
            Supervision sp = new Supervision();

            sp.UserName = username;
            sp.DurationId = dr.getDurationId();

            sp.StudentCount = Convert.ToInt32(((ASPxSpinEdit)ASPxGridView2.FindEditRowCellTemplateControl((GridViewDataColumn)ASPxGridView2.Columns["StudentCount"], "txtEditStudentCount")).Text);
            sp.SupervisionTypeId = 1;

            dll_DirectTeach_Supervision dt = new dll_DirectTeach_Supervision(username, dr.getDurationId());
            dt.insertData(sp);
            e.Cancel = true;
            ASPxGridView2.CancelEdit();
            FillGridView2();
        }
        //************************************************************************************************************************
        protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
        {
            Supervision sp = new Supervision();

            sp.SupervisionId = Convert.ToInt32(((HiddenField)ASPxGridView2.FindEditRowCellTemplateControl((GridViewDataColumn)ASPxGridView2.Columns["StudentCount"], "hidEditId")).Value);
            sp.StudentCount = Convert.ToInt32(((ASPxSpinEdit)ASPxGridView2.FindEditRowCellTemplateControl((GridViewDataColumn)ASPxGridView2.Columns["StudentCount"], "txtEditStudentCount")).Text);

            dll_DirectTeach_Supervision dt = new dll_DirectTeach_Supervision(username, dr.getDurationId());
            dt.updateData(sp);
            this.ASPxGridView2.CancelEdit();
            e.Cancel = true;
            FillGridView2();
        }
 protected void ASPxGridView2_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
 {
     DeleteFiles df = new DeleteFiles();
     df.DeleteAllFiles(Convert.ToInt32(e.Keys[0]), supervisionId);
     dll_DirectTeach_Supervision dt = new dll_DirectTeach_Supervision(username, dr.getDurationId());
     dt.deleteData(Convert.ToInt32(((HiddenField)ASPxGridView2.FindRowCellTemplateControl(ASPxGridView2.FindVisibleIndexByKeyValue(e.Keys[ASPxGridView2.KeyFieldName]), (GridViewDataColumn)ASPxGridView2.Columns["StudentCount"], "hidDeleteId")).Value));
     e.Cancel = true;
     FillGridView2();
 }