public HttpResponseMessage unlockDisbursement(String id, Models.TrnDisbursement disbursement)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var disbursements = from d in db.TrnDisbursements where d.Id == Convert.ToInt32(id) select d;
if (disbursements.Any())
{
var updateDisbursement = disbursements.FirstOrDefault();
updateDisbursement.IsLocked = false;
updateDisbursement.UpdatedById = userId;
updateDisbursement.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
journal.DeleteCashVoucherJournal(Convert.ToInt32(id));
updateAPDisbursement(Convert.ToInt32(id));
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 insertDisbursement(Models.TrnDisbursement disbursement)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var lastCVBNumber = from d in db.TrnDisbursements.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
var CVNumberResult = "0000000001";
if (lastCVBNumber.Any())
{
var CVNumber = Convert.ToInt32(lastCVBNumber.FirstOrDefault().CVNumber) + 0000000001;
CVNumberResult = zeroFill(CVNumber, 10);
}
Data.TrnDisbursement newDisbursement = new Data.TrnDisbursement();
newDisbursement.BranchId = currentBranchId();
newDisbursement.CVNumber = CVNumberResult;
newDisbursement.CVDate = DateTime.Today;
newDisbursement.SupplierId = (from d in db.MstArticles where d.ArticleTypeId == 3 select d.Id).FirstOrDefault();
newDisbursement.Payee = (from d in db.MstArticles where d.ArticleTypeId == 3 select d.Article).FirstOrDefault();
newDisbursement.PayTypeId = (from d in db.MstPayTypes select d.Id).FirstOrDefault();
newDisbursement.BankId = (from d in db.MstArticles where d.ArticleTypeId == 5 select d.Id).FirstOrDefault();
newDisbursement.ManualCVNumber = "NA";
newDisbursement.Particulars = "NA";
newDisbursement.CheckNumber = "NA";
newDisbursement.CheckDate = DateTime.Today;
newDisbursement.Amount = 0;
newDisbursement.IsCrossCheck = false;
newDisbursement.IsClear = false;
newDisbursement.PreparedById = userId;
newDisbursement.CheckedById = userId;
newDisbursement.ApprovedById = userId;
newDisbursement.IsLocked = false;
newDisbursement.CreatedById = userId;
newDisbursement.CreatedDateTime = DateTime.Now;
newDisbursement.UpdatedById = userId;
newDisbursement.UpdatedDateTime = DateTime.Now;
db.TrnDisbursements.InsertOnSubmit(newDisbursement);
db.SubmitChanges();
return(newDisbursement.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage updateDisbursement(String id, Models.TrnDisbursement disbursement)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var disbursements = from d in db.TrnDisbursements where d.Id == Convert.ToInt32(id) select d;
if (disbursements.Any())
{
var updateDisbursement = disbursements.FirstOrDefault();
updateDisbursement.BranchId = disbursement.BranchId;
updateDisbursement.CVNumber = disbursement.CVNumber;
updateDisbursement.CVDate = Convert.ToDateTime(disbursement.CVDate);
updateDisbursement.SupplierId = disbursement.SupplierId;
updateDisbursement.Payee = disbursement.Payee;
updateDisbursement.PayTypeId = disbursement.PayTypeId;
updateDisbursement.BankId = disbursement.BankId;
updateDisbursement.ManualCVNumber = disbursement.ManualCVNumber;
updateDisbursement.Particulars = disbursement.Particulars;
updateDisbursement.CheckNumber = disbursement.CheckNumber;
updateDisbursement.CheckDate = Convert.ToDateTime(disbursement.CheckDate);
updateDisbursement.Amount = updateDisbursement.TrnDisbursementLines.Sum(d => d.Amount);
updateDisbursement.IsCrossCheck = disbursement.IsCrossCheck;
updateDisbursement.IsClear = disbursement.IsClear;
updateDisbursement.PreparedById = disbursement.PreparedById;
updateDisbursement.CheckedById = disbursement.CheckedById;
updateDisbursement.ApprovedById = disbursement.ApprovedById;
updateDisbursement.IsLocked = true;
updateDisbursement.UpdatedById = userId;
updateDisbursement.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
journal.InsertCashVoucherJournal(Convert.ToInt32(id));
updateAPDisbursement(Convert.ToInt32(id));
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
