public Data.Entity.Employee Save(Data.Entity.Employee entity) { EmployeeStorage.EmployeeList.Add(entity); EmployeeStorage.EmployeeDictionary.Add(entity.Id, entity); return(entity); }
public EmployeeResult Find(long id) { Data.Entity.Employee entity = EmployeeDao.Find(id); EmployeeResult result = EmployeeResultConverter.Convert(entity); return(result); }
public EmployeeResult Create(EmployeeParam param) { Data.Entity.Employee entity = EmployeeParamConverter.Convert(param, null); EmployeeDao.Save(entity); return(EmployeeResultConverter.Convert(entity)); }
static EmployeeStorage() { Data.Entity.Employee Employee1 = new Data.Entity.Employee { }; Data.Entity.Employee Employee2 = new Data.Entity.Employee { }; Data.Entity.Employee Employee3 = new Data.Entity.Employee { }; Data.Entity.Employee Employee4 = new Data.Entity.Employee { }; Data.Entity.Employee Employee5 = new Data.Entity.Employee { }; Data.Entity.Employee Employee6 = new Data.Entity.Employee { }; Data.Entity.Employee Employee7 = new Data.Entity.Employee { }; Data.Entity.Employee Employee8 = new Data.Entity.Employee { }; Data.Entity.Employee Employee9 = new Data.Entity.Employee { }; Data.Entity.Employee Employee10 = new Data.Entity.Employee { }; EmployeeList.Add(Employee1); EmployeeList.Add(Employee2); EmployeeList.Add(Employee3); EmployeeList.Add(Employee4); EmployeeList.Add(Employee5); EmployeeList.Add(Employee6); EmployeeList.Add(Employee7); EmployeeList.Add(Employee8); EmployeeList.Add(Employee9); EmployeeList.Add(Employee10); EmployeeDictionary.Add(Employee1.Id, Employee1); EmployeeDictionary.Add(Employee2.Id, Employee2); EmployeeDictionary.Add(Employee3.Id, Employee3); EmployeeDictionary.Add(Employee4.Id, Employee4); EmployeeDictionary.Add(Employee5.Id, Employee5); EmployeeDictionary.Add(Employee6.Id, Employee6); EmployeeDictionary.Add(Employee7.Id, Employee7); EmployeeDictionary.Add(Employee8.Id, Employee8); EmployeeDictionary.Add(Employee9.Id, Employee9); EmployeeDictionary.Add(Employee10.Id, Employee10); }
public int Update(Data.Entity.Employee record) { int result = 0; using (AppDBContext dbContext = new AppDBContext(_config)) { dbContext.Entry(record).State = EntityState.Modified; result = dbContext.SaveChanges(); } return(result); }
public void Update(List <EmployeeParam> param) { List <Data.Entity.Employee> entity = new List <Data.Entity.Employee>(); foreach (var item in param) { Data.Entity.Employee oldEntity = EmployeeDao.Find(item.Id); Data.Entity.Employee newEntity = EmployeeParamConverter.Convert(item, null); EmployeeDao.Update(newEntity); } }
public static string SP_GetEmployeeById(out Data.Entity.Employee e, int userId) { e = null; SqlConnection sqlConn = new SqlConnection(); //defines database connection SqlCommand sqlCmd = new SqlCommand(); //defines what to do SqlDataAdapter sqlAdap = new SqlDataAdapter(); try { sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["AMS_StockConnectionString"].ToString(); sqlConn.Open(); sqlCmd.CommandText = "SP_GetEmployeeById"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Connection = sqlConn; SqlParameter parm1 = new SqlParameter("@CurrUser", SqlDbType.Int); parm1.Value = userId; parm1.Direction = ParameterDirection.Input; sqlCmd.Parameters.Add(parm1); sqlAdap.SelectCommand = sqlCmd; DataSet ds = new DataSet(); sqlAdap.Fill(ds); DataRow dr = ds.Tables[0].Rows[0]; e = new Data.Entity.Employee { EmployeeSysId = (int)dr["EmployeeSystemId"], EmployeeId = dr["EmployeeId"].ToString(), EmployeeName = dr["EmployeeName"].ToString(), EmployeeDesignation = dr["EmployeeDesignation"].ToString(), EmployeeEmail = dr["EmployeeEmail"].ToString(), EmploeeTelephone = dr["EmployeeTelephone"].ToString(), EmployeeIdNo = dr["EmployeeIdNo"].ToString(), PtjCode = dr["PTJ_Code"].ToString(), PtjName = dr["PTJ_Name"].ToString(), }; return string.Empty; } catch (Exception err) { return err.Message; } finally { sqlConn.Close(); sqlConn.Dispose(); sqlCmd.Dispose(); } }
public EmployeeResult Convert(Data.Entity.Employee param) { EmployeeResult result = new EmployeeResult() { Code = param.Code, Id = param.Id, Description = param.Description, Name = param.Name, ContractId = param.Contract.Id, ContractName = param.Contract.Name, EmployeeStatusId = param.EmployeeStatus.Id, EmployeeStatusName = param.EmployeeStatus.Name }; return(result); }
public Data.Entity.Employee Convert(EmployeeParam param, Data.Entity.Employee oldentity) { Data.Entity.Employee entity = null; if (oldentity != null) { entity = oldentity; } else { entity = new Data.Entity.Employee { Code = param.Code, Id = param.Id, Description = param.Description, Name = param.Name }; } entity.EmployeeStatus = EmployeeStatusDao.Find(param.EmployeeStatusId); entity.Contract = ContractDao.Find(param.ContractId); return(entity); }
public Data.Entity.Employee Update(Data.Entity.Employee entity) { Delete(entity.Id); Save(entity); return(entity); }
public void Delete(Data.Entity.Employee entity) { EmployeeStorage.EmployeeList.Remove(entity); EmployeeStorage.EmployeeDictionary.Remove(entity.Id); }
public void Delete(long id) { Data.Entity.Employee entity = Find(id); Delete(entity); }
public void Update(long id, EmployeeParam param) { Data.Entity.Employee oldEntity = EmployeeDao.Find(id); Data.Entity.Employee newEntity = EmployeeParamConverter.Convert(param, null); EmployeeDao.Update(newEntity); }