internal Inv_DepartmentType GetDepartmentByDepartmentId(string deparId, string OCODE) { int DepId = Convert.ToInt32(deparId); Inv_DepartmentType dep = _context.Inv_DepartmentType.First(x => x.DepartmentTypeId == DepId); return(dep); }
internal int InsertDepartment(Inv_DepartmentType objDepartment) { try { _context.Inv_DepartmentType.AddObject(objDepartment); _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void imgbtnDepartmentEdit_Click(object sender, EventArgs e) { Inv_DepartmentType objectDepartment = new Inv_DepartmentType(); ImageButton imgbtn = (ImageButton)sender; GridViewRow row = (GridViewRow)imgbtn.NamingContainer; try { string deparId = ""; Label lblDepartmentId = (Label)gridviewDepartmetn.Rows[row.RowIndex].FindControl("lblDepartmetn"); if (lblDepartmentId != null) { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; deparId = lblDepartmentId.Text; objectDepartment = objDept_BLL.GetDepartmentByDepartmentId(deparId, OCODE); if (objectDepartment != null) { hidDepartmentId.Value = objectDepartment.DepartmentTypeId.ToString(); drpdwnResionForDepartment.SelectedValue = objectDepartment.ResionId.ToString(); int resionId = Convert.ToInt32(objectDepartment.ResionId.ToString()); BridOfficeByResion(resionId); drpdwnOffice.SelectedValue = objectDepartment.Office_ID.ToString(); txtbxDepartemntName.Text = objectDepartment.DPT_NAME.ToString(); txtbxType.Text = objectDepartment.DepartmentType.ToString(); string officeCode = objectDepartment.DPT_CODE.ToString(); string[] occode = officeCode.Split('-'); lblOfficeCode.Text = occode[0] + "-" + occode[1] + "-"; txtbxDepartmentCode.Text = occode[2]; if (btnDepartmentSubmit.Text == "Submit") { btnDepartmentSubmit.Text = "Update"; } } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int UpdateDepartment(Inv_DepartmentType objDepartment, int DepartmentId) { try { Inv_DepartmentType obj = _context.Inv_DepartmentType.First(x => x.DepartmentTypeId == DepartmentId); obj.DPT_NAME = objDepartment.DPT_NAME; obj.DPT_CODE = objDepartment.DPT_CODE; obj.EDIT_USER = objDepartment.EDIT_USER; obj.EDIT_DATE = objDepartment.EDIT_DATE; obj.Office_ID = objDepartment.Office_ID; obj.ResionId = objDepartment.ResionId; obj.DepartmentType = objDepartment.DepartmentType; _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void btnDepartmentSubmit_Click(object sender, EventArgs e) { try { if (drpdwnResionForDepartment.SelectedItem.ToString() == "--Select--") { // lblMessage.Text = "Please Select Resion!"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Resion!')", true); } else if (txtbxDepartemntName.Text == "") { // lblMessage.Text = "Please Input Department Name!"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Name!')", true); } else if (txtbxDepartmentCode.Text == "") { // lblMessage.Text = "Please Input Department Code!"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Code!')", true); } else if (txtbxDepartmentCode.Text.Length < 3) { // lblMessage.Text = "Department Code Minmum Length 3!"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Department Code Minmum Length 3!')", true); } else if (txtbxType.Text == "") { // lblMessage.Text = "Please Input Department Type!"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Department Type!')", true); } else { if (drpdwnOffice.SelectedItem.ToString() == "--Select--") { // lblMessage.Text = "Please Select Office"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Office')", true); } else { Inv_DepartmentType objDepartment = new Inv_DepartmentType(); objDepartment.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; objDepartment.EDIT_DATE = DateTime.Now; objDepartment.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); objDepartment.Office_ID = Convert.ToInt32(drpdwnOffice.SelectedValue.ToString()); objDepartment.DPT_NAME = txtbxDepartemntName.Text; objDepartment.DepartmentType = txtbxType.Text; objDepartment.ResionId = Convert.ToInt32(drpdwnResionForDepartment.SelectedValue.ToString()); string offcode = lblOfficeCode.Text + txtbxDepartmentCode.Text; objDepartment.DPT_CODE = offcode; if (btnDepartmentSubmit.Text == "Submit") { int result = objDept_BLL.InsertDepartment(objDepartment); if (result == 1) { // lblMessage.Text = "Data Save successfully!"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save successfully!')", true); } } else { int DepartmentId = Convert.ToInt32(hidDepartmentId.Value); int result = objDept_BLL.UpdateDepartment(objDepartment, DepartmentId); if (result == 1) { // lblMessage.Text = "Data Update successfully!"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update successfully!')", true); } } GetAllDepartmentforGridview(); ClearDepartmentUi(); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }