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);
}
