protected void btnSaveNewMainCourse_Click(object sender, EventArgs e) { try { int resultNo = 0; string resultDesc = string.Empty; obj_MC = new clsManageMasterTables(); obj = new TBL_MAIN_COURSE(); obj.MAIN_COURSE_ID = 0; obj.COURSE_NAME = txtMainCourseName.Text; obj.COURSE_DESC = txtMainCourseDesc.Text; obj.CREATED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.CREATED_BY = 1000000001; obj.MODIFIED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.MODIFIED_BY = 1000000001; obj.PURGEFLAG = "A"; obj_MC.MainCourseInsertUpdate(obj, out resultNo, out resultDesc); Response.Write(resultDesc); Bind_grdMainCourse(); txtMainCourseDesc.Text = txtMainCourseName.Text = string.Empty; } catch (Exception ex) { Response.Write(ex.Message); } }
protected void grdMainCourse_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = grdMainCourse.Rows[e.RowIndex]; TextBox txtMainCourseNameGRD = (TextBox)row.FindControl("txtMainCourseNameGRD"); TextBox txtMainCourseDescGRD = (TextBox)row.FindControl("txtMainCourseDescGRD"); int resultNo = 0; string resultDesc = string.Empty; obj_MC = new clsManageMasterTables(); obj = new TBL_MAIN_COURSE(); obj.MAIN_COURSE_ID = Convert.ToInt32(grdMainCourse.DataKeys[e.RowIndex].Value.ToString()); obj.COURSE_NAME = txtMainCourseNameGRD.Text; obj.COURSE_DESC = txtMainCourseDescGRD.Text; obj.CREATED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.CREATED_BY = 1000000001; obj.MODIFIED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.MODIFIED_BY = 1000000001; obj.PURGEFLAG = "A"; obj_MC.MainCourseInsertUpdate(obj, out resultNo, out resultDesc); Response.Write(resultDesc); Bind_grdMainCourse(); txtMainCourseDesc.Text = txtMainCourseName.Text = string.Empty; grdMainCourse.EditIndex = -1; Bind_grdMainCourse(); }
protected void chkPURGEFLAG_OnCheckedChanged(object sender, EventArgs e) { CheckBox chkPURGEFLAG = (CheckBox)sender; GridViewRow row = (GridViewRow)chkPURGEFLAG.NamingContainer; HiddenField hdnfPurgeFlag = (HiddenField)row.FindControl("hdnfPurgeFlag"); int rowindex = row.RowIndex; int resultNo = 0; string resultDesc = string.Empty; obj_MC = new clsManageMasterTables(); obj = new TBL_MAIN_COURSE(); obj.MAIN_COURSE_ID = Convert.ToInt32(grdMainCourse.DataKeys[rowindex].Value.ToString()); obj.CREATED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.MODIFIED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.MODIFIED_BY = 1000000001; if (chkPURGEFLAG.Checked) { obj.PURGEFLAG = "A"; } else { obj.PURGEFLAG = "I"; } obj_MC.MainCourseInsertUpdate(obj, out resultNo, out resultDesc); Response.Write(resultDesc); Bind_grdMainCourse(); txtMainCourseDesc.Text = txtMainCourseName.Text = string.Empty; grdMainCourse.EditIndex = -1; Bind_grdMainCourse(); }
public void MainCourseInsertUpdate(TBL_MAIN_COURSE obj) { DB.ExecScalerSP_Object(CommandType.StoredProcedure, "USP_TBL_MAIN_COURSE_InsertUpdate", new SqlParameter("@MAIN_COURSE_ID", obj.MAIN_COURSE_ID), new SqlParameter("@COURSE_NAME", obj.COURSE_NAME), new SqlParameter("@COURSE_DESC", obj.COURSE_DESC), new SqlParameter("@CREATED_ON", obj.CREATED_ON), new SqlParameter("@CREATED_BY", obj.CREATED_BY), new SqlParameter("@MODIFIED_ON", obj.MODIFIED_ON), new SqlParameter("@MODIFIED_BY", obj.MODIFIED_BY), new SqlParameter("@PURGEFLAG", obj.PURGEFLAG)); CloseAll(); }
public void MainCourseInsertUpdate(TBL_MAIN_COURSE obj, out int resultNo, out string resultDesc) { SqlParameter resultNoSQL = new SqlParameter("@RESULT_NO", SqlDbType.Int, 100); resultNoSQL.Direction = ParameterDirection.Output; SqlParameter resultDescSQL = new SqlParameter("@RESULT_DESC", SqlDbType.NVarChar, 2000); resultDescSQL.Direction = ParameterDirection.Output; DB.ExecScalerSP_Object(CommandType.StoredProcedure, "USP_TBL_MAIN_COURSE_InsertUpdate", new SqlParameter("@MAIN_COURSE_ID", obj.MAIN_COURSE_ID), new SqlParameter("@COURSE_NAME", obj.COURSE_NAME), new SqlParameter("@COURSE_DESC", obj.COURSE_DESC), new SqlParameter("@CREATED_ON", obj.CREATED_ON), new SqlParameter("@CREATED_BY", obj.CREATED_BY), new SqlParameter("@MODIFIED_ON", obj.MODIFIED_ON), new SqlParameter("@MODIFIED_BY", obj.MODIFIED_BY), new SqlParameter("@PURGEFLAG", obj.PURGEFLAG), resultNoSQL, resultDescSQL); resultNo = Convert.ToInt32(resultNoSQL.Value.ToString()); resultDesc = resultDescSQL.Value.ToString(); CloseAll(); }