internal int UpdateEmployee(tbl_EmployeeInfo atbl_EmployeeInfo, string EID) { tbl_EmployeeInfo objtbl_EmployeeInfo = _context.tbl_EmployeeInfo.First(x => x.EID == EID); objtbl_EmployeeInfo.EmployeeName = atbl_EmployeeInfo.EmployeeName; objtbl_EmployeeInfo.Office_Id = atbl_EmployeeInfo.Office_Id; objtbl_EmployeeInfo.Department_Id = atbl_EmployeeInfo.Department_Id; _context.SaveChanges(); return(1); }
protected void btnSave_Click(object sender, EventArgs e) { tbl_EmployeeInfo atbl_EmployeeInfo = new tbl_EmployeeInfo(); atbl_EmployeeInfo.EID = txtEID.Text; atbl_EmployeeInfo.EmployeeName = txtEmployeeName.Text; atbl_EmployeeInfo.Office_Id = Convert.ToInt16(ddlOfficeName.SelectedValue); atbl_EmployeeInfo.Department_Id = Convert.ToInt16(ddlDepartmentName.SelectedValue); int count = (from emp in context.tbl_EmployeeInfo where emp.EID == atbl_EmployeeInfo.EID select emp.EID).Count(); if (btnSave.Text == "Save") { if (count > 0) { lblMessage.Visible = true; lblMessage.Text = "E-ID already exists!"; return; } aEmployeeSetup_BLL.SaveEmployee(atbl_EmployeeInfo); //context.tbl_EmployeeInfo.Add(atbl_EmployeeInfo); //Add object into DBset //context.SaveChanges(); // call SaveChanges method to save into database lblMessage.Visible = true; lblMessage.Text = "Data Save Successfully"; } else { aEmployeeSetup_BLL.UpdateEmployee(atbl_EmployeeInfo, txtEID.Text); lblMessage.Visible = true; lblMessage.Text = "Data Update Successfully"; btnCancel.Visible = false; //btnSave.Text = "Save"; } Clearform(); GetAllEmployeeDetails(); }
internal int UpdateEmployee(tbl_EmployeeInfo atbl_EmployeeInfo, string EID) { return(objEmployeeSetup_DAL.UpdateEmployee(atbl_EmployeeInfo, EID)); }
internal int SaveEmployee(tbl_EmployeeInfo atbl_EmployeeInfo) { return(objEmployeeSetup_DAL.SaveEmployee(atbl_EmployeeInfo)); }
internal int SaveEmployee(tbl_EmployeeInfo atbl_EmployeeInfo) { _context.tbl_EmployeeInfo.Add(atbl_EmployeeInfo); _context.SaveChanges(); return(1); }