public HttpResponseMessage insertDisbursementLineAccountsPayable(Models.TrnReceivingReceipt receivingReceipt, String CVId)
{
try
{
Data.TrnDisbursementLine newDisbursementLine = new Data.TrnDisbursementLine();
newDisbursementLine.CVId = Convert.ToInt32(CVId);
newDisbursementLine.BranchId = receivingReceipt.BranchId;
newDisbursementLine.AccountId = receivingReceipt.AccountId;
newDisbursementLine.ArticleId = receivingReceipt.SupplierId;
newDisbursementLine.RRId = receivingReceipt.Id;
newDisbursementLine.Particulars = receivingReceipt.DocumentReference;
newDisbursementLine.Amount = receivingReceipt.Amount;
db.TrnDisbursementLines.InsertOnSubmit(newDisbursementLine);
db.SubmitChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception e)
{
Debug.WriteLine(e);
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
public Int32 insertReceivingReceipt(Models.TrnReceivingReceipt receivingReceipt)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var RRNumberResult = "0000000001";
var lastRRNumber = from d in db.TrnReceivingReceipts.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
if (lastRRNumber.Any())
{
var PONumber = Convert.ToInt32(lastRRNumber.FirstOrDefault().RRNumber) + 0000000001;
RRNumberResult = zeroFill(PONumber, 10);
}
Data.TrnReceivingReceipt newReceivingReceipt = new Data.TrnReceivingReceipt();
newReceivingReceipt.BranchId = currentBranchId();
newReceivingReceipt.RRDate = DateTime.Today;
newReceivingReceipt.RRNumber = RRNumberResult;
newReceivingReceipt.SupplierId = (from d in db.MstArticles where d.ArticleTypeId == 3 select d.Id).FirstOrDefault();
newReceivingReceipt.TermId = (from d in db.MstTerms select d.Id).FirstOrDefault();
newReceivingReceipt.DocumentReference = "NA";
newReceivingReceipt.ManualRRNumber = "NA";
newReceivingReceipt.Remarks = "NA";
newReceivingReceipt.Amount = 0;
newReceivingReceipt.WTaxAmount = 0;
newReceivingReceipt.PaidAmount = 0;
newReceivingReceipt.AdjustmentAmount = 0;
newReceivingReceipt.BalanceAmount = 0;
newReceivingReceipt.ReceivedById = userId;
newReceivingReceipt.PreparedById = userId;
newReceivingReceipt.CheckedById = userId;
newReceivingReceipt.ApprovedById = userId;
newReceivingReceipt.IsLocked = false;
newReceivingReceipt.CreatedById = userId;
newReceivingReceipt.CreatedDateTime = DateTime.Now;
newReceivingReceipt.UpdatedById = userId;
newReceivingReceipt.UpdatedDateTime = DateTime.Now;
db.TrnReceivingReceipts.InsertOnSubmit(newReceivingReceipt);
db.SubmitChanges();
return(newReceivingReceipt.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage unlockReceivingReceipt(String id, Models.TrnReceivingReceipt receivingReceipt)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var receivingReceipts = from d in db.TrnReceivingReceipts where d.Id == Convert.ToInt32(id) select d;
if (receivingReceipts.Any())
{
var updatereceivingReceipt = receivingReceipts.FirstOrDefault();
updatereceivingReceipt.IsLocked = false;
updatereceivingReceipt.UpdatedById = userId;
updatereceivingReceipt.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
if (updatereceivingReceipt.IsLocked == true)
{
inventory.InsertReceivingReceiptInventory(Convert.ToInt32(id));
journal.InsertReceivingReceiptJournal(Convert.ToInt32(id));
}
else
{
inventory.DeleteReceivingReceiptInventory(Convert.ToInt32(id));
journal.DeleteReceivingReceiptJournal(Convert.ToInt32(id));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage updateReceivingReceipt(String id, Models.TrnReceivingReceipt receivingReceipt)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var receivingReceipts = from d in db.TrnReceivingReceipts where d.Id == Convert.ToInt32(id) select d;
if (receivingReceipts.Any())
{
// get disbursement line for CVId
var disbursementLineCVId = from d in db.TrnDisbursementLines where d.RRId == Convert.ToInt32(id) select d;
Decimal PaidAmount = 0;
if (disbursementLineCVId.Any())
{
Boolean disbursementHeaderIsLocked = (from d in db.TrnDisbursements where d.Id == disbursementLineCVId.First().CVId select d.IsLocked).SingleOrDefault();
// get disbursement line for paid amaount
var disbursementLines = from d in db.TrnDisbursementLines where d.RRId == Convert.ToInt32(id) select d;
if (disbursementLines.Any())
{
if (disbursementHeaderIsLocked == true)
{
PaidAmount = disbursementLines.Sum(d => d.Amount);
}
else
{
PaidAmount = 0;
}
}
else
{
PaidAmount = 0;
}
}
var updatereceivingReceipt = receivingReceipts.FirstOrDefault();
updatereceivingReceipt.BranchId = receivingReceipt.BranchId;
updatereceivingReceipt.RRDate = Convert.ToDateTime(receivingReceipt.RRDate);
updatereceivingReceipt.RRNumber = receivingReceipt.RRNumber;
updatereceivingReceipt.SupplierId = receivingReceipt.SupplierId;
updatereceivingReceipt.TermId = receivingReceipt.TermId;
updatereceivingReceipt.DocumentReference = receivingReceipt.DocumentReference;
updatereceivingReceipt.ManualRRNumber = receivingReceipt.ManualRRNumber;
updatereceivingReceipt.Remarks = receivingReceipt.Remarks;
updatereceivingReceipt.Amount = getAmountReceivingReceiptItem(Convert.ToInt32(id));
updatereceivingReceipt.WTaxAmount = 0;
updatereceivingReceipt.PaidAmount = PaidAmount;
updatereceivingReceipt.AdjustmentAmount = 0;
updatereceivingReceipt.BalanceAmount = getAmountReceivingReceiptItem(Convert.ToInt32(id)) - PaidAmount;
updatereceivingReceipt.ReceivedById = receivingReceipt.ReceivedById;
updatereceivingReceipt.PreparedById = receivingReceipt.PreparedById;
updatereceivingReceipt.CheckedById = receivingReceipt.CheckedById;
updatereceivingReceipt.ApprovedById = receivingReceipt.ApprovedById;
updatereceivingReceipt.IsLocked = true;
updatereceivingReceipt.UpdatedById = userId;
updatereceivingReceipt.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
if (updatereceivingReceipt.IsLocked == true)
{
inventory.InsertReceivingReceiptInventory(Convert.ToInt32(id));
journal.InsertReceivingReceiptJournal(Convert.ToInt32(id));
}
else
{
inventory.DeleteReceivingReceiptInventory(Convert.ToInt32(id));
journal.DeleteReceivingReceiptJournal(Convert.ToInt32(id));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
