public async Task InsertADMasterEmployee(ADMasterEmployee objADMasterEmployee) { using (var transaction = _Context.Database.BeginTransaction()) { try { _Context.ADMasterEmployees.Add(objADMasterEmployee); await _Context.SaveChangesAsync(); ADMasterLogin objADMasterLogin = new ADMasterLogin(); objADMasterLogin.MasterLoginId = 0; objADMasterLogin.MasterRegistrationTypeId = 3; objADMasterLogin.MasterRegistrationId = objADMasterEmployee.MasterEmployeeId; objADMasterLogin.MasterProfileId = 3; objADMasterLogin.UserName = objADMasterEmployee.Email; objADMasterLogin.Password = "******"; objADMasterLogin.VerificationCode = ""; objADMasterLogin.IsFirstLogin = true; objADMasterLogin.IsVerified = false; objADMasterLogin.IsActive = false; objADMasterLogin.EnterById = objADMasterEmployee.EnterById; objADMasterLogin.EnterDate = objADMasterEmployee.EnterDate; objADMasterLogin.ModifiedById = objADMasterEmployee.ModifiedById; objADMasterLogin.ModifiedDate = objADMasterEmployee.ModifiedDate; _Context.ADMasterLogins.Add(objADMasterLogin); await _Context.SaveChangesAsync(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } }
public async Task UpdateADMasterEmployee(ADMasterEmployee objADMasterEmployee) { using (var transaction = _Context.Database.BeginTransaction()) { try { _Context.Entry(objADMasterEmployee).State = EntityState.Modified; await _Context.SaveChangesAsync(); var ADMasterLogin = _Context.ADMasterLogins.Where(a => a.MasterRegistrationId == objADMasterEmployee.MasterEmployeeId).FirstOrDefault(); ADMasterLogin.UserName = objADMasterEmployee.Email; _Context.Entry(ADMasterLogin).State = EntityState.Modified; await _Context.SaveChangesAsync(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } }
public async Task <ActionResult <MasterEmployeeResult> > PutADMasterEmployee(long id, ADMasterEmployee objADMasterEmployee) { if (id != objADMasterEmployee.MasterEmployeeId) { return(BadRequest()); } try { await _IMasterEmployeeInterface.UpdateADMasterEmployee(objADMasterEmployee); //MasterEmployeeResult objMasterEmployeeResult = new MasterEmployeeResult(); return(_IMasterEmployeeInterface.GetADMasterEmployeeByID(id)); } catch (DbUpdateConcurrencyException) { if (!_IMasterEmployeeInterface.ADMasterEmployeeExists(id)) { return(NotFound()); } else { throw; } } catch (Exception ex) { throw new Exception(ex.Message); } return(NoContent()); }
public async Task <ActionResult <MasterEmployeeResult> > PostADMasterEmployee(ADMasterEmployee objADMasterEmployee) { try { await _IMasterEmployeeInterface.InsertADMasterEmployee(objADMasterEmployee); return(CreatedAtAction("GetADMasterEmployee", new { id = objADMasterEmployee.MasterEmployeeId }, objADMasterEmployee)); } catch (Exception ex) { throw new Exception(ex.Message); } }