public WorkFieldDTO GetWorkFieldFromDB(int id)
{
{
ICollection <WorkFieldDTO> outputList = default(ICollection <WorkFieldDTO>);
WorkFieldDTO output = new WorkFieldDTO();
try
{
WorkFieldBusiness _WorkFieldBusiness = new WorkFieldBusiness();
WorkFieldList _WorkFieldList = _WorkFieldBusiness.SelectRows(id, null, null);
if (_WorkFieldList != null && _WorkFieldList.Count > 0)
//outputList = Mapper.MapUserAsOutput();
{
// 2- Prepare Mapping Objects (Fill Values from DB)
Mapper._WorkFieldList = _WorkFieldList;
// 3- Perform Mapping to Output
outputList = Mapper.MapWorkFieldAsOutput();
if (outputList != null && outputList.Count > 0)
{
output = outputList.FirstOrDefault();
}
}
}
catch (Exception ex)
{
// Log Exception Here
throw; //new Exception(ex.Message);
}
return(output);
}
}
private static WorkFieldDTO mapWorkField(WorkField workField)
{
WorkFieldDTO _WorkFieldMap = new WorkFieldDTO();
_WorkFieldMap = fillWorkFieldDTObyWorkFieldID(workField.Id);
// _WorkFieldMap.WorkFieldDTO = fillWorkfieldDTObyCustomerID(workField.Id);
return(_WorkFieldMap);;
}
public WorkFieldDTO UpdateWorkFieldInDB(WorkFieldDTO workFieldDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapWorkFieldAsInput(workFieldDTO))
{
// 2- Select WorkField to be updated
WorkFieldBusiness workFieldBusiness = new WorkFieldBusiness();
WorkFieldList workFieldList = workFieldBusiness.SelectRows(Mapper._WorkField.Id, null, null);
if (workFieldList != null && workFieldList.Count > 0)
{
workFieldList[0].Id = Mapper._WorkField.Id;
workFieldList[0].name = Mapper._WorkField.name;
workFieldList[0].nameAr = Mapper._WorkField.nameAr;
// 3- Update WorkField Data by Input Values
workFieldBusiness = new WorkFieldBusiness();
if (workFieldBusiness.UpdateRow(dbTransaction, workFieldList[0]) > 0)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
else
{
dbTransaction.Rollback();
throw new Exception("WorkField Id Not Found in DB");
}
}
else
{
throw new ArgumentNullException("workFieldDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
return(workFieldDTO);
}
public WorkFieldDTO UpdateWorkField(WorkFieldDTO workFieldDTO)
{
try
{
return(_IWorkFieldDAL.UpdateWorkFieldInDB(workFieldDTO));
}
catch (Exception)
{
throw;
}
}
public WorkFieldDTO AddWorkField(WorkFieldDTO workFieldDTO)
{
try
{
return(_IWorkFieldDAL.AddWorkFieldToDB(workFieldDTO));
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetWorkFieldByIdentity(int id)
{
try
{
WorkFieldDTO _Output = _IWorkFieldBLL.GetWorkFieldByID(id);
return(Request.CreateResponse(HttpStatusCode.OK, _Output));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
private static WorkFieldDTO fillWorkfieldDTObyCustomerID(int id)
{
WorkFieldDTO workFieldDTO = default(WorkFieldDTO); //new WorkFieldDTO();
WorkField _WorkField = _WorkFieldList.FirstOrDefault(i => i.Id == id);
if (_WorkField != default(WorkField))
{
workFieldDTO = new WorkFieldDTO();
workFieldDTO.Id = _WorkField.Id;
workFieldDTO.name = _WorkField.name;
workFieldDTO.nameAr = _WorkField.nameAr;
}
return(workFieldDTO);
}
public HttpResponseMessage UpdateWorkField(WorkFieldDTO workFieldDTO)
{
try
{
if (workFieldDTO == null)
{
throw new ArgumentNullException("workFieldDTO");
}
WorkFieldDTO _Output = _IWorkFieldBLL.UpdateWorkField(workFieldDTO);
return(Request.CreateResponse(HttpStatusCode.OK, _Output));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
private static WorkFieldDTO fillWorkFieldDTObyWorkFieldID(int?WorkFieldID)
{
{
WorkFieldDTO _WorkFieldDTO = default(WorkFieldDTO);
WorkField _WorkField = _WorkFieldList.FirstOrDefault(i => i.Id == WorkFieldID.Value);
if (_WorkField != default(WorkField))
{
_WorkFieldDTO = new WorkFieldDTO();
_WorkFieldDTO.Id = _WorkField.Id;
_WorkFieldDTO.name = _WorkField.name;
_WorkFieldDTO.nameAr = _WorkField.nameAr;
}
return(_WorkFieldDTO);
}
}
public static ICollection <WorkFieldDTO> MapWorkFieldAsOutput()
{
{
List <WorkFieldDTO> _WorkFieldDTOList = new List <WorkFieldDTO>();
WorkFieldDTO _WorkFieldDTO = default(WorkFieldDTO);
if (_WorkFieldList != null && _WorkFieldList.Count > 0)
{
foreach (WorkField __WorkField in _WorkFieldList)
{
_WorkFieldDTO = mapWorkField(__WorkField);
_WorkFieldDTOList.Add(_WorkFieldDTO);
}
}
return(_WorkFieldDTOList);
}
}
WorkFieldDTO IWorkFieldDAL.AddWorkFieldToDB(WorkFieldDTO workFieldDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapWorkFieldAsInput(workFieldDTO))
{
// 2- Insert WorkField in DB
WorkFieldBusiness workFieldBusiness = new WorkFieldBusiness();
if (workFieldBusiness.InsertRow(dbTransaction, Mapper._WorkField) > 0)
{
dbTransaction.Commit();
workFieldDTO.Id = Mapper._WorkField.Id;
}
else
{
dbTransaction.Rollback();
throw new DataException("DataBase Operation Failure");
}
}
else
{
throw new ArgumentNullException("workFieldDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
return(workFieldDTO);
}
public static bool MapWorkFieldAsInput(WorkFieldDTO workFieldDTO)
{
bool result = default(bool);
_WorkField = new WorkField();
if (workFieldDTO != null)
{
// WorkField Data part
_WorkField.Id = workFieldDTO.Id;
_WorkField.name = workFieldDTO.name;
_WorkField.nameAr = workFieldDTO.nameAr;
result = true;
}
return(result);
}
