public Int32 insertJournalVoucherLine(Models.TrnJournalVoucherLine journalVoucherLine)
{
try
{
Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine();
newJournalVoucherLine.JVId = journalVoucherLine.JVId;
newJournalVoucherLine.BranchId = journalVoucherLine.BranchId;
newJournalVoucherLine.AccountId = journalVoucherLine.AccountId;
newJournalVoucherLine.ArticleId = journalVoucherLine.ArticleId;
newJournalVoucherLine.Particulars = journalVoucherLine.Particulars;
newJournalVoucherLine.DebitAmount = journalVoucherLine.DebitAmount;
newJournalVoucherLine.CreditAmount = journalVoucherLine.CreditAmount;
newJournalVoucherLine.APRRId = journalVoucherLine.APRRId;
newJournalVoucherLine.ARSIId = journalVoucherLine.ARSIId;
newJournalVoucherLine.IsClear = journalVoucherLine.IsClear;
db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
db.SubmitChanges();
return(newJournalVoucherLine.Id);
}
catch
{
return(0);
}
}
public Int32 insertJournalVoucherLine(Models.TrnJournalVoucherLine journalVoucherLine)
{
try
{
Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine();
newJournalVoucherLine.JVId = journalVoucherLine.JVId;
newJournalVoucherLine.BranchId = journalVoucherLine.BranchId;
newJournalVoucherLine.AccountId = journalVoucherLine.AccountId;
newJournalVoucherLine.ArticleId = journalVoucherLine.ArticleId;
newJournalVoucherLine.Particulars = journalVoucherLine.Particulars;
newJournalVoucherLine.DebitAmount = journalVoucherLine.DebitAmount;
newJournalVoucherLine.CreditAmount = journalVoucherLine.CreditAmount;
newJournalVoucherLine.APRRId = journalVoucherLine.APRRId;
newJournalVoucherLine.ARSIId = journalVoucherLine.ARSIId;
newJournalVoucherLine.IsClear = journalVoucherLine.IsClear;
db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
db.SubmitChanges();
return newJournalVoucherLine.Id;
}
catch
{
return 0;
}
}
public HttpResponseMessage AddFolderMonitoringJournalVoucher(List <Entities.FolderMonitoringTrnJournalVoucher> folderMonitoringTrnJournalVoucherObjects)
{
try
{
if (folderMonitoringTrnJournalVoucherObjects.Any())
{
String returnMessage = "";
List <Entities.FolderMonitoringTrnJournalVoucherHeader> newFolderMonitoringTrnJournalVoucherHeaders = new List <Entities.FolderMonitoringTrnJournalVoucherHeader>();
List <Entities.FolderMonitoringTrnJournalVoucherLine> newFolderMonitoringTrnJournalVoucherLines = new List <Entities.FolderMonitoringTrnJournalVoucherLine>();
Boolean isDataValid = false;
foreach (var folderMonitoringTrnJournalVoucherObject in folderMonitoringTrnJournalVoucherObjects)
{
Boolean isBranchExist = false,
isUserExist = false,
isEntryBranchCodeExist = false,
isAccountExist = false,
isArticleExist = false;
var branch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnJournalVoucherObject.BranchCode) select d;
if (branch.Any())
{
isBranchExist = true;
}
var user = from d in db.MstUsers where d.UserName.Equals(folderMonitoringTrnJournalVoucherObject.UserCode) select d;
if (user.Any())
{
isUserExist = true;
}
var entryBranch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnJournalVoucherObject.EntryBranchCode) select d;
if (entryBranch.Any())
{
isEntryBranchCodeExist = true;
}
List <easyfis.Entities.MstArticle> listArticles = new List <easyfis.Entities.MstArticle>();
var account = from d in db.MstAccounts where d.AccountCode.Equals(folderMonitoringTrnJournalVoucherObject.AccountCode) select d;
if (account.Any())
{
isAccountExist = true;
var accountArticleTypes = from d in db.MstAccountArticleTypes
where d.AccountId == Convert.ToInt32(account.FirstOrDefault().Id)
group d by d.ArticleTypeId into g
select g;
if (accountArticleTypes.Any())
{
foreach (var accountArticleType in accountArticleTypes)
{
var articles = from d in db.MstArticles
where d.ArticleTypeId == accountArticleType.Key &&
d.IsLocked == true
select d;
if (articles.Any())
{
foreach (var articleObject in articles)
{
listArticles.Add(new easyfis.Entities.MstArticle()
{
Id = articleObject.Id,
ManualArticleCode = articleObject.ManualArticleCode,
Article = articleObject.Article
});
}
}
}
}
}
var article = from d in listArticles where d.ManualArticleCode.Equals(folderMonitoringTrnJournalVoucherObject.ArticleCode) select d;
if (article.Any())
{
isArticleExist = true;
}
if (!isBranchExist)
{
returnMessage = "Invalid Branch Code: " + folderMonitoringTrnJournalVoucherObject.BranchCode; isDataValid = false; break;
}
else if (!isUserExist)
{
returnMessage = "Invalid User Code: " + folderMonitoringTrnJournalVoucherObject.UserCode; isDataValid = false; break;
}
else if (!isEntryBranchCodeExist)
{
returnMessage = "Invalid Entry Branch Code: " + folderMonitoringTrnJournalVoucherObject.EntryBranchCode; isDataValid = false; break;
}
else if (!isAccountExist)
{
returnMessage = "Invalid Account Code: " + folderMonitoringTrnJournalVoucherObject.AccountCode; isDataValid = false; break;
}
else if (!isArticleExist)
{
returnMessage = "Invalid Article Code: " + folderMonitoringTrnJournalVoucherObject.ArticleCode; isDataValid = false; break;
}
else
{
var journalVoucher = from d in db.TrnJournalVouchers
where d.BranchId == branch.FirstOrDefault().Id &&
d.ManualJVNumber.Equals(folderMonitoringTrnJournalVoucherObject.ManualJVNumber) &&
d.IsLocked == true
select d;
if (journalVoucher.Any())
{
returnMessage = "This Manual JV No. " + folderMonitoringTrnJournalVoucherObject.ManualJVNumber + " is already exist!";
isDataValid = false;
break;
}
else
{
Int32?APRRId = null;
if (!folderMonitoringTrnJournalVoucherObject.APManualRRNumber.Equals("") || !folderMonitoringTrnJournalVoucherObject.APManualRRNumber.Equals("NA"))
{
var receivingReceipt = from d in db.TrnReceivingReceipts
where d.BranchId == branch.FirstOrDefault().Id &&
d.ManualRRNumber.Equals(folderMonitoringTrnJournalVoucherObject.APManualRRNumber) &&
d.IsLocked == true
select d;
if (receivingReceipt.Any())
{
APRRId = receivingReceipt.FirstOrDefault().Id;
}
}
Int32?ARSIId = null;
if (!folderMonitoringTrnJournalVoucherObject.ARManualSINumber.Equals("") || !folderMonitoringTrnJournalVoucherObject.ARManualSINumber.Equals("NA"))
{
var salesInvoice = from d in db.TrnSalesInvoices
where d.BranchId == branch.FirstOrDefault().Id &&
d.ManualSINumber.Equals(folderMonitoringTrnJournalVoucherObject.ARManualSINumber) &&
d.IsLocked == true
select d;
if (salesInvoice.Any())
{
ARSIId = salesInvoice.FirstOrDefault().Id;
}
}
var folderMonitoringTrnJournalVoucherHeader = from d in newFolderMonitoringTrnJournalVoucherHeaders
where d.BranchId == branch.FirstOrDefault().Id &&
d.ManualJVNumber.Equals(folderMonitoringTrnJournalVoucherObject.ManualJVNumber)
select d;
if (folderMonitoringTrnJournalVoucherHeader.Any())
{
var currentFolderMonitoringTrnJournalVoucherHeader = folderMonitoringTrnJournalVoucherHeader.FirstOrDefault();
currentFolderMonitoringTrnJournalVoucherHeader.ListFolderMonitoringTrnJournalVoucherLines.Add(new Entities.FolderMonitoringTrnJournalVoucherLine()
{
ManualJVNumber = folderMonitoringTrnJournalVoucherObject.ManualJVNumber,
BranchId = entryBranch.FirstOrDefault().Id,
AccountId = account.FirstOrDefault().Id,
ArticleId = article.FirstOrDefault().Id,
Particulars = folderMonitoringTrnJournalVoucherObject.Particulars,
DebitAmount = folderMonitoringTrnJournalVoucherObject.DebitAmount,
CreditAmount = folderMonitoringTrnJournalVoucherObject.CreditAmount,
APRRId = APRRId,
ARSIId = ARSIId,
IsClear = folderMonitoringTrnJournalVoucherObject.IsClear
});
}
else
{
newFolderMonitoringTrnJournalVoucherLines = new List <Entities.FolderMonitoringTrnJournalVoucherLine>
{
new Entities.FolderMonitoringTrnJournalVoucherLine()
{
ManualJVNumber = folderMonitoringTrnJournalVoucherObject.ManualJVNumber,
BranchId = entryBranch.FirstOrDefault().Id,
AccountId = account.FirstOrDefault().Id,
ArticleId = article.FirstOrDefault().Id,
Particulars = folderMonitoringTrnJournalVoucherObject.Particulars,
DebitAmount = folderMonitoringTrnJournalVoucherObject.DebitAmount,
CreditAmount = folderMonitoringTrnJournalVoucherObject.CreditAmount,
APRRId = APRRId,
ARSIId = ARSIId,
IsClear = folderMonitoringTrnJournalVoucherObject.IsClear
}
};
if (newFolderMonitoringTrnJournalVoucherLines.Any())
{
newFolderMonitoringTrnJournalVoucherHeaders.Add(new Entities.FolderMonitoringTrnJournalVoucherHeader()
{
BranchId = branch.FirstOrDefault().Id,
JVNumber = "0000000000",
JVDate = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.JVDate),
ManualJVNumber = folderMonitoringTrnJournalVoucherObject.ManualJVNumber,
Particulars = folderMonitoringTrnJournalVoucherObject.Remarks,
PreparedById = user.FirstOrDefault().Id,
CheckedById = user.FirstOrDefault().Id,
ApprovedById = user.FirstOrDefault().Id,
Status = null,
IsCancelled = false,
IsPrinted = false,
IsLocked = false,
CreatedById = user.FirstOrDefault().Id,
CreatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime),
UpdatedById = user.FirstOrDefault().Id,
UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime),
ListFolderMonitoringTrnJournalVoucherLines = newFolderMonitoringTrnJournalVoucherLines
});
}
}
isDataValid = true;
}
}
}
if (isDataValid)
{
if (newFolderMonitoringTrnJournalVoucherHeaders.Any())
{
foreach (var newFolderMonitoringTrnJournalVoucherHeader in newFolderMonitoringTrnJournalVoucherHeaders)
{
Int32 JVId = 0;
var defaultJVNumber = "0000000001";
var lastJournalVoucher = from d in db.TrnJournalVouchers.OrderByDescending(d => d.Id) where d.BranchId == newFolderMonitoringTrnJournalVoucherHeader.BranchId select d;
if (lastJournalVoucher.Any())
{
var JVNumber = Convert.ToInt32(lastJournalVoucher.FirstOrDefault().JVNumber) + 0000000001;
defaultJVNumber = FillLeadingZeroes(JVNumber, 10);
}
Data.TrnJournalVoucher newJournalVoucher = new Data.TrnJournalVoucher
{
BranchId = newFolderMonitoringTrnJournalVoucherHeader.BranchId,
JVNumber = defaultJVNumber,
JVDate = newFolderMonitoringTrnJournalVoucherHeader.JVDate,
ManualJVNumber = newFolderMonitoringTrnJournalVoucherHeader.ManualJVNumber,
Particulars = newFolderMonitoringTrnJournalVoucherHeader.Particulars,
PreparedById = newFolderMonitoringTrnJournalVoucherHeader.PreparedById,
CheckedById = newFolderMonitoringTrnJournalVoucherHeader.CheckedById,
ApprovedById = newFolderMonitoringTrnJournalVoucherHeader.ApprovedById,
Status = newFolderMonitoringTrnJournalVoucherHeader.Status,
IsCancelled = newFolderMonitoringTrnJournalVoucherHeader.IsCancelled,
IsPrinted = newFolderMonitoringTrnJournalVoucherHeader.IsPrinted,
IsLocked = newFolderMonitoringTrnJournalVoucherHeader.IsLocked,
CreatedById = newFolderMonitoringTrnJournalVoucherHeader.CreatedById,
CreatedDateTime = newFolderMonitoringTrnJournalVoucherHeader.CreatedDateTime,
UpdatedById = newFolderMonitoringTrnJournalVoucherHeader.UpdatedById,
UpdatedDateTime = newFolderMonitoringTrnJournalVoucherHeader.UpdatedDateTime
};
db.TrnJournalVouchers.InsertOnSubmit(newJournalVoucher);
db.SubmitChanges();
JVId = newJournalVoucher.Id;
if (newFolderMonitoringTrnJournalVoucherHeader.ListFolderMonitoringTrnJournalVoucherLines.Any())
{
foreach (var listFolderMonitoringTrnJournalVoucherLine in newFolderMonitoringTrnJournalVoucherHeader.ListFolderMonitoringTrnJournalVoucherLines)
{
Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine
{
JVId = JVId,
BranchId = listFolderMonitoringTrnJournalVoucherLine.BranchId,
AccountId = listFolderMonitoringTrnJournalVoucherLine.AccountId,
ArticleId = listFolderMonitoringTrnJournalVoucherLine.ArticleId,
Particulars = listFolderMonitoringTrnJournalVoucherLine.Particulars,
DebitAmount = listFolderMonitoringTrnJournalVoucherLine.DebitAmount,
CreditAmount = listFolderMonitoringTrnJournalVoucherLine.CreditAmount,
APRRId = listFolderMonitoringTrnJournalVoucherLine.APRRId,
ARSIId = listFolderMonitoringTrnJournalVoucherLine.ARSIId,
IsClear = listFolderMonitoringTrnJournalVoucherLine.IsClear
};
db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
}
db.SubmitChanges();
}
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, returnMessage));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data Source is Invalid or Empty."));
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Backend Error: " + ex.Message));
}
}
public HttpResponseMessage AddJournalVoucherLine(Entities.TrnJournalVoucherLine objJournalVoucherLine, String JVId)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("JournalVoucherDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var journalVoucher = from d in db.TrnJournalVouchers
where d.Id == Convert.ToInt32(JVId)
select d;
if (journalVoucher.Any())
{
if (!journalVoucher.FirstOrDefault().IsLocked)
{
var accounts = from d in db.MstAccounts.OrderBy(d => d.Account)
where d.Id == objJournalVoucherLine.AccountId &&
d.IsLocked == true
select d;
if (accounts.Any())
{
var articles = from d in db.MstArticles
where d.Id == objJournalVoucherLine.ArticleId &&
d.IsLocked == true
select d;
if (articles.Any())
{
Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine
{
JVId = Convert.ToInt32(JVId),
BranchId = objJournalVoucherLine.BranchId,
AccountId = objJournalVoucherLine.AccountId,
ArticleId = objJournalVoucherLine.ArticleId,
Particulars = objJournalVoucherLine.Particulars,
DebitAmount = objJournalVoucherLine.DebitAmount,
CreditAmount = objJournalVoucherLine.CreditAmount,
APRRId = objJournalVoucherLine.APRRId,
ARSIId = objJournalVoucherLine.ARSIId,
IsClear = objJournalVoucherLine.IsClear
};
db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No Article."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "No Account."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new journal voucher line if the current journal voucher detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "These current journal voucher details are not found in the server. Please add new journal voucher first before proceeding."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new journal voucher line in this journal voucher detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this journal voucher detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage AddFolderMonitoringJournalVoucher(List <Entities.FolderMonitoringTrnJournalVoucher> folderMonitoringTrnJournalVoucherObjects)
{
try
{
if (folderMonitoringTrnJournalVoucherObjects.Any())
{
foreach (var folderMonitoringTrnJournalVoucherObject in folderMonitoringTrnJournalVoucherObjects)
{
Boolean isBranchExist = false,
isUserExist = false,
isEntryBranchCodeExist = false,
isAccountExist = false,
isArticleExist = false,
isReceivingReceiptExist = false,
isSalesInvoiceExist = false;
IQueryable <Data.TrnReceivingReceipt> receivingReceipt = null;
IQueryable <Data.TrnSalesInvoice> salesInvoice = null;
var branch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnJournalVoucherObject.BranchCode) select d;
if (branch.Any())
{
isBranchExist = true;
if (!folderMonitoringTrnJournalVoucherObject.APRRNumber.Equals("") || !folderMonitoringTrnJournalVoucherObject.APRRNumber.Equals("NA"))
{
receivingReceipt = from d in db.TrnReceivingReceipts where d.BranchId == branch.FirstOrDefault().Id&& d.RRNumber.Equals(folderMonitoringTrnJournalVoucherObject.APRRNumber) && d.IsLocked == true select d;
if (receivingReceipt.Any())
{
isReceivingReceiptExist = true;
}
}
if (!folderMonitoringTrnJournalVoucherObject.ARSINumber.Equals("") || !folderMonitoringTrnJournalVoucherObject.ARSINumber.Equals("NA"))
{
salesInvoice = from d in db.TrnSalesInvoices where d.BranchId == branch.FirstOrDefault().Id&& d.SINumber.Equals(folderMonitoringTrnJournalVoucherObject.ARSINumber) && d.IsLocked == true select d;
if (salesInvoice.Any())
{
isSalesInvoiceExist = true;
}
}
}
var user = from d in db.MstUsers where d.UserName.Equals(folderMonitoringTrnJournalVoucherObject.UserCode) select d;
if (user.Any())
{
isUserExist = true;
}
var entryBranch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnJournalVoucherObject.EntryBranchCode) select d;
if (entryBranch.Any())
{
isEntryBranchCodeExist = true;
}
List <easyfis.Entities.MstArticle> listArticles = new List <easyfis.Entities.MstArticle>();
var account = from d in db.MstAccounts where d.AccountCode.Equals(folderMonitoringTrnJournalVoucherObject.AccountCode) select d;
if (account.Any())
{
isAccountExist = true;
var accountArticleTypes = from d in db.MstAccountArticleTypes where d.AccountId == Convert.ToInt32(account.FirstOrDefault().Id) select d;
if (accountArticleTypes.Any())
{
foreach (var accountArticleType in accountArticleTypes)
{
var articles = from d in db.MstArticles where d.ArticleTypeId == accountArticleType.ArticleTypeId && d.IsLocked == true select d;
if (articles.Any())
{
foreach (var articleObject in articles)
{
listArticles.Add(new easyfis.Entities.MstArticle()
{
Id = articleObject.Id,
ManualArticleCode = articleObject.ManualArticleCode,
Article = articleObject.Article
});
}
}
}
}
}
var article = from d in listArticles where d.ManualArticleCode.Equals(folderMonitoringTrnJournalVoucherObject.ArticleCode) select d;
if (article.Any())
{
isArticleExist = true;
}
if (isBranchExist && isUserExist && isEntryBranchCodeExist && isAccountExist && isArticleExist)
{
Int32 JVId = 0;
var currentJournalVoucher = from d in db.TrnJournalVouchers where d.BranchId == branch.FirstOrDefault().Id&& d.ManualJVNumber.Equals(folderMonitoringTrnJournalVoucherObject.ManualJVNumber) && d.IsLocked == true select d;
if (currentJournalVoucher.Any())
{
JVId = currentJournalVoucher.FirstOrDefault().Id;
var unlockJournalVoucher = currentJournalVoucher.FirstOrDefault();
unlockJournalVoucher.IsLocked = false;
unlockJournalVoucher.UpdatedById = user.FirstOrDefault().Id;
unlockJournalVoucher.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime);
db.SubmitChanges();
journal.DeleteJournalVoucherJournal(JVId);
}
else
{
var defaultJVNumber = "0000000001";
var lastJournalVoucher = from d in db.TrnJournalVouchers.OrderByDescending(d => d.Id) where d.BranchId == branch.FirstOrDefault().Id select d;
if (lastJournalVoucher.Any())
{
var JVNumber = Convert.ToInt32(lastJournalVoucher.FirstOrDefault().JVNumber) + 0000000001;
defaultJVNumber = FillLeadingZeroes(JVNumber, 10);
}
Data.TrnJournalVoucher newJournalVoucher = new Data.TrnJournalVoucher
{
BranchId = branch.FirstOrDefault().Id,
JVNumber = defaultJVNumber,
JVDate = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.JVDate),
ManualJVNumber = folderMonitoringTrnJournalVoucherObject.ManualJVNumber,
Particulars = folderMonitoringTrnJournalVoucherObject.Remarks,
PreparedById = user.FirstOrDefault().Id,
CheckedById = user.FirstOrDefault().Id,
ApprovedById = user.FirstOrDefault().Id,
Status = null,
IsCancelled = false,
IsPrinted = false,
IsLocked = false,
CreatedById = user.FirstOrDefault().Id,
CreatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime),
UpdatedById = user.FirstOrDefault().Id,
UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime)
};
db.TrnJournalVouchers.InsertOnSubmit(newJournalVoucher);
db.SubmitChanges();
JVId = newJournalVoucher.Id;
}
Int32?APRRId = null;
if (isReceivingReceiptExist)
{
APRRId = receivingReceipt.FirstOrDefault().Id;
}
Int32?ARSIId = null;
if (isSalesInvoiceExist)
{
ARSIId = salesInvoice.FirstOrDefault().Id;
}
Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine
{
JVId = JVId,
BranchId = entryBranch.FirstOrDefault().Id,
AccountId = account.FirstOrDefault().Id,
ArticleId = article.FirstOrDefault().Id,
Particulars = folderMonitoringTrnJournalVoucherObject.Particulars,
DebitAmount = folderMonitoringTrnJournalVoucherObject.DebitAmount,
CreditAmount = folderMonitoringTrnJournalVoucherObject.CreditAmount,
APRRId = APRRId,
ARSIId = ARSIId,
IsClear = folderMonitoringTrnJournalVoucherObject.IsClear
};
db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
db.SubmitChanges();
var journalVoucher = from d in db.TrnJournalVouchers where d.Id == JVId && d.IsLocked == false select d;
if (journalVoucher.Any())
{
var lockJournalVoucher = journalVoucher.FirstOrDefault();
lockJournalVoucher.IsLocked = true;
lockJournalVoucher.UpdatedById = user.FirstOrDefault().Id;
lockJournalVoucher.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnJournalVoucherObject.CreatedDateTime);
db.SubmitChanges();
var journalVoucherLines = from d in db.TrnJournalVoucherLines where d.JVId == JVId select d;
if (journalVoucherLines.Any())
{
foreach (var journalVoucherLine in journalVoucherLines)
{
if (journalVoucherLine.APRRId != null)
{
accountsPayable.UpdateAccountsPayable(Convert.ToInt32(journalVoucherLine.APRRId));
}
if (journalVoucherLine.ARSIId != null)
{
accountsReceivable.UpdateAccountsReceivable(Convert.ToInt32(journalVoucherLine.ARSIId));
}
}
}
journal.InsertJournalVoucherJournal(JVId);
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No data found."));
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage AdjustAPStockOut(Entities.TrnStockOutAdjustAP objStockOutAdjustAP)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var currentBranchId = currentUser.FirstOrDefault().BranchId;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("StockOutDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var defaultJVNumber = "0000000001";
var lastJournalVoucher = from d in db.TrnJournalVouchers.OrderByDescending(d => d.Id)
where d.BranchId == currentBranchId
select d;
if (lastJournalVoucher.Any())
{
var JVNumber = Convert.ToInt32(lastJournalVoucher.FirstOrDefault().JVNumber) + 0000000001;
defaultJVNumber = FillLeadingZeroes(JVNumber, 10);
}
var stockOut = from d in db.TrnStockOuts
where d.Id == objStockOutAdjustAP.Id
select d;
if (stockOut.Any())
{
if (stockOut.FirstOrDefault().IsLocked)
{
var receivingReceipt = from d in db.TrnReceivingReceipts
where d.Id == objStockOutAdjustAP.RRId &&
d.BranchId == currentBranchId &&
d.IsLocked == true
select d;
if (receivingReceipt.Any())
{
Data.TrnJournalVoucher newJournalVoucher = new Data.TrnJournalVoucher
{
BranchId = currentBranchId,
JVNumber = defaultJVNumber,
JVDate = DateTime.Today,
ManualJVNumber = receivingReceipt.FirstOrDefault().ManualRRNumber,
Particulars = receivingReceipt.FirstOrDefault().DocumentReference,
PreparedById = receivingReceipt.FirstOrDefault().PreparedById,
CheckedById = receivingReceipt.FirstOrDefault().CheckedById,
ApprovedById = receivingReceipt.FirstOrDefault().ApprovedById,
Status = null,
IsCancelled = false,
IsPrinted = false,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.TrnJournalVouchers.InsertOnSubmit(newJournalVoucher);
db.SubmitChanges();
String newObject = "[" + auditTrail.GetObjectString(newJournalVoucher) + ", ";
Data.TrnJournalVoucherLine newDebitJournalVoucherLine = new Data.TrnJournalVoucherLine
{
JVId = newJournalVoucher.Id,
BranchId = currentBranchId,
AccountId = receivingReceipt.FirstOrDefault().MstArticle.AccountId,
ArticleId = receivingReceipt.FirstOrDefault().SupplierId,
Particulars = stockOut.FirstOrDefault().Particulars,
DebitAmount = objStockOutAdjustAP.Amount,
CreditAmount = 0,
APRRId = receivingReceipt.FirstOrDefault().Id,
ARSIId = null,
IsClear = false
};
db.TrnJournalVoucherLines.InsertOnSubmit(newDebitJournalVoucherLine);
db.SubmitChanges();
newObject += auditTrail.GetObjectString(newDebitJournalVoucherLine) + ", ";
Data.TrnJournalVoucherLine newCreditJournalVoucherLine = new Data.TrnJournalVoucherLine
{
JVId = newJournalVoucher.Id,
BranchId = currentBranchId,
AccountId = stockOut.FirstOrDefault().AccountId,
ArticleId = stockOut.FirstOrDefault().ArticleId,
Particulars = stockOut.FirstOrDefault().Particulars,
DebitAmount = 0,
CreditAmount = objStockOutAdjustAP.Amount,
APRRId = null,
ARSIId = null,
IsClear = false
};
db.TrnJournalVoucherLines.InsertOnSubmit(newCreditJournalVoucherLine);
db.SubmitChanges();
newObject += auditTrail.GetObjectString(newCreditJournalVoucherLine) + "]";
var journalVoucherLines = from d in db.TrnJournalVoucherLines where d.JVId == newJournalVoucher.Id select d;
if (journalVoucherLines.Any())
{
foreach (var journalVoucherLine in journalVoucherLines)
{
if (journalVoucherLine.APRRId != null)
{
accountsPayable.UpdateAccountsPayable(Convert.ToInt32(journalVoucherLine.APRRId));
}
}
}
Business.Journal journal = new Business.Journal();
journal.InsertJournalVoucherJournal(newJournalVoucher.Id);
auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK, newJournalVoucher.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Sorry. No receiving receipt found."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. Cannot adjust AP if the stock out detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Invalid reference object."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to adjust AP stock out."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this stock out page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
