public Int32 insertDisbursementLine(Models.TrnDisbursementLine disbursementLine)
{
try
{
Data.TrnDisbursementLine newDisbursementLine = new Data.TrnDisbursementLine();
newDisbursementLine.CVId = disbursementLine.CVId;
newDisbursementLine.BranchId = disbursementLine.BranchId;
newDisbursementLine.AccountId = disbursementLine.AccountId;
newDisbursementLine.ArticleId = disbursementLine.ArticleId;
newDisbursementLine.RRId = disbursementLine.RRId;
newDisbursementLine.Particulars = disbursementLine.Particulars;
newDisbursementLine.Amount = disbursementLine.Amount;
db.TrnDisbursementLines.InsertOnSubmit(newDisbursementLine);
db.SubmitChanges();
var disbursement = from d in db.TrnDisbursements
where d.Id == disbursementLine.CVId
select d;
if (disbursement.Any())
{
var updateDisbursement = disbursement.FirstOrDefault();
updateDisbursement.Amount = disbursement.FirstOrDefault().TrnDisbursementLines.Sum(d => d.Amount);
db.SubmitChanges();
}
return newDisbursementLine.Id;
}
catch
{
return 0;
}
}
public HttpResponseMessage updateDisbursementLine(String id, Models.TrnDisbursementLine disbursementLine)
{
try
{
var disbursementLines = from d in db.TrnDisbursementLines where d.Id == Convert.ToInt32(id) select d;
if (disbursementLines.Any())
{
var updateDisbursementLine = disbursementLines.FirstOrDefault();
updateDisbursementLine.CVId = disbursementLine.CVId;
updateDisbursementLine.BranchId = disbursementLine.BranchId;
updateDisbursementLine.AccountId = disbursementLine.AccountId;
updateDisbursementLine.ArticleId = disbursementLine.ArticleId;
updateDisbursementLine.RRId = disbursementLine.RRId;
updateDisbursementLine.Particulars = disbursementLine.Particulars;
updateDisbursementLine.Amount = disbursementLine.Amount;
db.SubmitChanges();
var disbursement = from d in db.TrnDisbursements
where d.Id == disbursementLines.FirstOrDefault().CVId
select d;
if (disbursement.Any())
{
var updateDisbursement = disbursement.FirstOrDefault();
updateDisbursement.Amount = disbursement.FirstOrDefault().TrnDisbursementLines.Sum(d => d.Amount);
db.SubmitChanges();
}
return Request.CreateResponse(HttpStatusCode.OK);
}
else
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
}
catch
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
public HttpResponseMessage PostAdvances(Models.TrnDisbursementLine disbursementLine, String articleId, String ORId)
{
try
{
var CustomerAdvancesAccountId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.CustomerAdvancesAccountId).SingleOrDefault();
var journals = from d in db.TrnJournals
where d.ArticleId == Convert.ToInt32(articleId) &&
d.AccountId == CustomerAdvancesAccountId &&
d.BranchId == currentBranchId()
group d by new
{
BranchId = d.BranchId,
Branch = d.MstBranch.Branch,
AccountId = d.AccountId,
Account = d.MstAccount.Account,
AccountCode = d.MstAccount.AccountCode,
ArticleId = d.ArticleId,
Article = d.MstArticle.Article,
RRId = d.RRId
} into g
select new Models.TrnJournal
{
BranchId = g.Key.BranchId,
Branch = g.Key.Branch,
AccountId = g.Key.AccountId,
Account = g.Key.Account,
AccountCode = g.Key.AccountCode,
ArticleId = g.Key.ArticleId,
Article = g.Key.Article,
RRId = g.Key.RRId,
DebitAmount = g.Sum(d => d.DebitAmount),
CreditAmount = g.Sum(d => d.CreditAmount),
Balance = g.Sum(d => d.CreditAmount) - g.Sum(d => d.DebitAmount)
};
if (journals.Any())
{
Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine();
var accountId = 0;
foreach (var journal in journals)
{
accountId = (from d in db.MstArticles where d.Id == journal.ArticleId select d.AccountId).SingleOrDefault();
newCollectionLine.ORId = Convert.ToInt32(ORId);
newCollectionLine.BranchId = journal.BranchId;
newCollectionLine.AccountId = accountId;
newCollectionLine.ArticleId = journal.ArticleId;
newCollectionLine.SIId = (from d in db.TrnSalesInvoices select d.Id).FirstOrDefault();
newCollectionLine.Particulars = "Customer Advances";
newCollectionLine.Amount = journal.Balance;
newCollectionLine.PayTypeId = (from d in db.MstPayTypes select d.Id).FirstOrDefault();
newCollectionLine.CheckNumber = "NA";
newCollectionLine.CheckDate = DateTime.Now;
newCollectionLine.CheckBank = "NA";
newCollectionLine.DepositoryBankId = null;
newCollectionLine.IsClear = true;
}
db.TrnCollectionLines.InsertOnSubmit(newCollectionLine);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage insertDisbursementLineAllAccountsPayable(Models.TrnDisbursementLine disbursementLine, String supplierId, String CVId)
{
try
{
var receivingReceipts = from d in db.TrnReceivingReceipts
where d.BranchId == currentBranchId()
&& d.SupplierId == Convert.ToInt32(supplierId)
&& d.BalanceAmount > 0
&& d.IsLocked == true
select new Models.TrnReceivingReceipt
{
Id = d.Id,
BranchId = d.BranchId,
Branch = d.MstBranch.Branch,
RRDate = d.RRDate.ToShortDateString(),
RRNumber = d.RRNumber,
SupplierId = d.SupplierId,
Supplier = d.MstArticle.Article,
AccountId = d.MstArticle.AccountId,
TermId = d.TermId,
Term = d.MstTerm.Term,
DocumentReference = d.DocumentReference,
ManualRRNumber = d.ManualRRNumber,
Remarks = d.Remarks,
Amount = d.Amount,
WTaxAmount = d.WTaxAmount,
PaidAmount = d.PaidAmount,
AdjustmentAmount = d.AdjustmentAmount,
BalanceAmount = d.BalanceAmount,
ReceivedById = d.ReceivedById,
ReceivedBy = d.MstUser4.FullName,
PreparedById = d.PreparedById,
PreparedBy = d.MstUser3.FullName,
CheckedById = d.CheckedById,
CheckedBy = d.MstUser1.FullName,
ApprovedById = d.ApprovedById,
ApprovedBy = d.MstUser.FullName
};
if (receivingReceipts.Any())
{
foreach (var receivingReceipt in receivingReceipts)
{
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);
}
else
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
}
catch
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
public HttpResponseMessage insertDisbursementLineAdvances(Models.TrnDisbursementLine disbursementLine, String articleId, String CVId)
{
try
{
var SupplierAdvancesAccountId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.SupplierAdvancesAccountId).SingleOrDefault();
var journals = from d in db.TrnJournals
where d.ArticleId == Convert.ToInt32(articleId)
&& d.AccountId == SupplierAdvancesAccountId
&& d.BranchId == currentBranchId()
group d by new
{
BranchId = d.BranchId,
Branch = d.MstBranch.Branch,
AccountId = d.AccountId,
Account = d.MstAccount.Account,
AccountCode = d.MstAccount.AccountCode,
ArticleId = d.ArticleId,
Article = d.MstArticle.Article,
RRId = d.RRId
} into g
select new Models.TrnJournal
{
BranchId = g.Key.BranchId,
Branch = g.Key.Branch,
AccountId = g.Key.AccountId,
Account = g.Key.Account,
AccountCode = g.Key.AccountCode,
ArticleId = g.Key.ArticleId,
Article = g.Key.Article,
RRId = g.Key.RRId,
DebitAmount = g.Sum(d => d.DebitAmount),
CreditAmount = g.Sum(d => d.CreditAmount),
Balance = g.Sum(d => d.DebitAmount) - g.Sum(d => d.CreditAmount)
};
if (journals.Any())
{
Data.TrnDisbursementLine newDisbursementLine = new Data.TrnDisbursementLine();
foreach (var journal in journals)
{
newDisbursementLine.CVId = Convert.ToInt32(CVId);
newDisbursementLine.BranchId = journal.BranchId;
newDisbursementLine.AccountId = journal.AccountId;
newDisbursementLine.ArticleId = journal.ArticleId;
newDisbursementLine.RRId = journal.RRId;
newDisbursementLine.Particulars = "Supplier Advances";
newDisbursementLine.Amount = journal.Balance * -1;
}
db.TrnDisbursementLines.InsertOnSubmit(newDisbursementLine);
db.SubmitChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
else
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
}
catch
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
