예제 #1
0
        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);
        }
예제 #2
0
        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));
 }
예제 #5
0
 internal int SaveDepartment(tbl_DepartmentInfo atbl_DepartmentInfo)
 {
     _context.tbl_DepartmentInfo.Add(atbl_DepartmentInfo);
     _context.SaveChanges();
     return(1);
 }