public RejectReasonDTO UpdateRejectReasonInDB(RejectReasonDTO rejectReasonDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRejectReasonAsInput(rejectReasonDTO))
{
// 2- Select RejectReason to be updated
RejectReasonBusiness rejectReasonBusiness = new RejectReasonBusiness();
RejectReasonList rejectReasonList = rejectReasonBusiness.SelectRows(Mapper._WorkField.Id, null, null);
if (rejectReasonList != null && rejectReasonList.Count > 0)
{
rejectReasonList[0].Id = Mapper._RejectReason.Id;
rejectReasonList[0].name = Mapper._RejectReason.name;
rejectReasonList[0].nameAr = Mapper._RejectReason.nameAr;
// 3- Update RejectReason Data by Input Values
rejectReasonBusiness = new RejectReasonBusiness();
if (rejectReasonBusiness.UpdateRow(dbTransaction, rejectReasonList[0]) > 0)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
else
{
dbTransaction.Rollback();
throw new Exception("RejectReason Id Not Found in DB");
}
}
else
{
throw new ArgumentNullException("rejectReasonDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
return(rejectReasonDTO);
}
private static RejectReasonDTO mapRejectReason(RejectReason rejectReason)
{
RejectReasonDTO _RejectReasonMap = new RejectReasonDTO();
_RejectReasonMap = fillRejectReasonDTObyRejectReasonID(rejectReason.Id);
return(_RejectReasonMap);
}
public RejectReasonDTO UpdateRejectReason(RejectReasonDTO rejectReasonDTO)
{
try
{
return(_IRejectReasonDAL.UpdateRejectReasonInDB(rejectReasonDTO));
}
catch (Exception)
{
throw;
}
}
public RejectReasonDTO AddRejectReason(RejectReasonDTO rejectReasonDTO)
{
try
{
return(_IRejectReasonDAL.AddRejectReasonToDB(rejectReasonDTO));
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetRejectReasonByIdentity(int id)
{
try
{
RejectReasonDTO _Output = _IRejectReasonBLL.GetRejectReasonByID(id);
return(Request.CreateResponse(HttpStatusCode.OK, _Output));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
private static RejectReasonDTO fillRejectReasonDTObyRejectReasonID(int?RejectReasonID)
{
RejectReasonDTO _RejectReasonDTO = default(RejectReasonDTO);
RejectReason _RejectReason = _RejectReasonList.FirstOrDefault(i => i.Id == RejectReasonID.Value);
if (_RejectReason != default(RejectReason))
{
_RejectReasonDTO = new RejectReasonDTO();
_RejectReasonDTO.Id = _RejectReason.Id;
_RejectReasonDTO.name = _RejectReason.name;
_RejectReasonDTO.nameAr = _RejectReason.nameAr;
}
return(_RejectReasonDTO);
}
public HttpResponseMessage UpdateRejectReason(RejectReasonDTO rejectReasonDTO)
{
try
{
if (rejectReasonDTO == null)
{
throw new ArgumentNullException("rejectReasonDTO");
}
RejectReasonDTO _Output = _IRejectReasonBLL.UpdateRejectReason(rejectReasonDTO);
return(Request.CreateResponse(HttpStatusCode.OK, _Output));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public static ICollection <RejectReasonDTO> MapRejectReasonAsOutput()
{
{
List <RejectReasonDTO> _RejectReasonDTOList = new List <RejectReasonDTO>();
RejectReasonDTO _RejectReasonDTO = default(RejectReasonDTO);
if (_RejectReasonList != null && _RejectReasonList.Count > 0)
{
foreach (RejectReason _RejectReason in _RejectReasonList)
{
_RejectReasonDTO = mapRejectReason(_RejectReason);
_RejectReasonDTOList.Add(_RejectReasonDTO);
}
}
return(_RejectReasonDTOList);
}
}
public RejectReasonDTO AddRejectReasonToDB(RejectReasonDTO rejectReasonDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRejectReasonAsInput(rejectReasonDTO))
{
////User user = Mapper._User;
////List<UserGroup> userGroups = Mapper._UserGroupListInput;
//Mapper._User.createDate = DateTime.Now;
// 2- Insert RejectReason in DB
RejectReasonBusiness rejectReasonBusiness = new RejectReasonBusiness();
if (rejectReasonBusiness.InsertRow(dbTransaction, Mapper._RejectReason) > 0)
{
dbTransaction.Commit();
rejectReasonDTO.Id = Mapper._RejectReason.Id;
}
else
{
dbTransaction.Rollback();
throw new DataException("DataBase Operation Failure");
}
}
else
{
throw new ArgumentNullException("rejectReasonDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
return(rejectReasonDTO);
}
public static bool MapRejectReasonAsInput(RejectReasonDTO rejectReasonDTO)
{
bool result = default(bool);
_RejectReason = new RejectReason();
if (rejectReasonDTO != null)
{
// RejectReason Data part
_RejectReason.Id = rejectReasonDTO.Id;
_RejectReason.name = rejectReasonDTO.name;
_RejectReason.nameAr = rejectReasonDTO.nameAr;
result = true;
}
return(result);
}
public RejectReasonDTO GetRejectReasonByIDFromDB(int id)
{
{
ICollection <RejectReasonDTO> outputList = default(ICollection <RejectReasonDTO>);
RejectReasonDTO output = new RejectReasonDTO();
try
{
RejectReasonBusiness _RejectReasonBusiness = new RejectReasonBusiness();
RejectReasonList _RejectReasonList = _RejectReasonBusiness.SelectRows(id, null, null);
if (_RejectReasonList != null && _RejectReasonList.Count > 0)
//outputList = Mapper.MapUserAsOutput();
{
// 2- Prepare Mapping Objects (Fill Values from DB)
Mapper._RejectReasonList = _RejectReasonList;
// 3- Perform Mapping to Output
outputList = Mapper.MapRejectReasonAsOutput();
if (outputList != null && outputList.Count > 0)
{
output = outputList.FirstOrDefault();
}
}
}
catch (Exception ex)
{
// Log Exception Here
throw; //new Exception(ex.Message);
}
return(output);
}
}
