internal int UpdateDepartment(tbl_DepartmentInfo atbl_DepartmentInfo, int Department_Id) { tbl_DepartmentInfo objtbl_DepartmentInfo = _context.tbl_DepartmentInfo.First(x => x.Department_Id == Department_Id); objtbl_DepartmentInfo.Department_Name = atbl_DepartmentInfo.Department_Name; objtbl_DepartmentInfo.Office_Id = atbl_DepartmentInfo.Office_Id; _context.SaveChanges(); return(1); }
protected void btnSave_Click(object sender, EventArgs e) { tbl_DepartmentInfo atbl_DepartmentInfo = new tbl_DepartmentInfo(); atbl_DepartmentInfo.Department_Name = txtDepartmentName.Text; atbl_DepartmentInfo.Office_Id = Convert.ToInt16(ddlOfficeName.SelectedValue); int count = (from emp in _context.tbl_DepartmentInfo where emp.Department_Name == atbl_DepartmentInfo.Department_Name && emp.Office_Id == atbl_DepartmentInfo.Office_Id select emp.Department_Name).Count(); if (btnSave.Text == "Save") { if (count > 0) { lblMessage.Visible = true; lblMessage.Text = "E-ID already exists!"; return; } objDepartmentSetup_BLL.SaveDepartment(atbl_DepartmentInfo); lblMessage.Visible = true; lblMessage.Text = "Data Save Successfully"; } else { objDepartmentSetup_BLL.UpdateDepartment(atbl_DepartmentInfo, Convert.ToInt16(hdndeptID.Value)); lblMessage.Visible = true; lblMessage.Text = "Data Update Successfully"; btnCancel.Visible = false; btnSave.Text = "Save"; } Clearform(); GetAllDepartmentDetails(); }
internal int UpdateDepartment(tbl_DepartmentInfo atbl_DepartmentInfo, int Department_Id) { return(aDepartmentSetup_DAL.UpdateDepartment(atbl_DepartmentInfo, Department_Id)); }
internal int SaveDepartment(tbl_DepartmentInfo atbl_DepartmentInfo) { return(aDepartmentSetup_DAL.SaveDepartment(atbl_DepartmentInfo)); }
internal int SaveDepartment(tbl_DepartmentInfo atbl_DepartmentInfo) { _context.tbl_DepartmentInfo.Add(atbl_DepartmentInfo); _context.SaveChanges(); return(1); }