public ResponseMessage UpdatePeriodDetail(PeriodDetailEntity periodUpdateDetail)
{
ResponseMessage response = new ResponseMessage();
using (var trans = db.Database.BeginTransaction())
{
try
{
PeriodDetail periodDetail = db.PeriodDetails.Find(periodUpdateDetail.PeriodDetailId);
periodDetail.Type = periodUpdateDetail.Type;
periodDetail.Amount = periodUpdateDetail.Amount;
periodDetail.AmountDate = periodUpdateDetail.AmountDate;
periodDetail.Note = periodUpdateDetail.Note;
periodDetail.AdvanceAmount = periodUpdateDetail.AdvanceAmount;
periodDetail.AdvanceDate = periodUpdateDetail.AdvanceDate;
periodDetail.Payment = periodUpdateDetail.Payment;
periodDetail.PaymentDate = periodUpdateDetail.PaymentDate;
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
Console.Error.WriteLine(ex.Message);
response.MessageText = ResponseMessage.MSG_CANNOT_CONNECT_TO_THE_DATABASE;
response.Data = null;
return(response);
}
}
return(response);
}
public ResponseMessage SearchPeriodDetailById(PeriodDetailEntity periodDetailSearch)
{
PeriodDetailEntity result = new PeriodDetailEntity();
var periodDetail = db.PeriodDetails.Find(periodDetailSearch.PeriodDetailId);
ResponseMessage response = new ResponseMessage();
response.Data = periodDetail;
return(response);
}
public HttpResponseMessage DeletePeriodDetail(PeriodDetailEntity period)
{
NV5000_FundsForBusiness FundsForBusiness = new NV5000_FundsForBusiness();
ResponseMessage response = FundsForBusiness.DeletePeriodDetail(period);
if (response.IsSuccess)
{
return(Request.CreateResponse(HttpStatusCode.OK, response.Data));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, response.MessageText));
}
}
public ResponseMessage DeletePeriodDetail(PeriodDetailEntity periodDetailDelete)
{
ResponseMessage response = new ResponseMessage();
using (var trans = db.Database.BeginTransaction())
{
try
{
PeriodDetail periodDetail = db.PeriodDetails.Find(periodDetailDelete.PeriodDetailId);
db.PeriodDetails.Remove(periodDetail);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
Console.Error.WriteLine(ex.Message);
response.MessageText = ResponseMessage.MSG_CANNOT_CONNECT_TO_THE_DATABASE;
response.Data = null;
return(response);
}
}
return(response);
}
public ResponseMessage AddPeriodDetail(PeriodDetailEntity periodDetailAdd)
{
ResponseMessage response = new ResponseMessage();
using (var trans = db.Database.BeginTransaction())
{
try
{
PeriodDetail p = new PeriodDetail()
{
PeriodDetailId = Guid.NewGuid().ToString(),
Type = periodDetailAdd.Type,
Amount = periodDetailAdd.Amount,
AmountDate = periodDetailAdd.AmountDate,
AdvanceAmount = periodDetailAdd.AdvanceAmount,
AdvanceDate = periodDetailAdd.AdvanceDate,
Payment = periodDetailAdd.Payment,
PaymentDate = periodDetailAdd.PaymentDate,
Note = periodDetailAdd.Note,
ProjectId = periodDetailAdd.ProjectId
};
db.PeriodDetails.Add(p);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
Console.Error.WriteLine(ex.Message);
response.MessageText = ResponseMessage.MSG_CANNOT_CONNECT_TO_THE_DATABASE;
response.Data = null;
return(response);
}
return(response);
}
}
