public ActionResult UpdateInitialBalance(AccountList accountlist)
{
try
{
AccountList Account = new AccountList();
Account = db.AccountList.Find(accountlist.AccountListID);
Account.InitialBalance = accountlist.InitialBalance;
Account.UpdateBy = AppUtils.GetLoginUserID();
Account.UpdateDate = AppUtils.GetDateTimeNow();
db.Entry(Account).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
AccountingHistory accountingHistory = db.AccountingHistory.Where(x => x.AccountListID == accountlist.AccountListID).FirstOrDefault();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, accountlist, 2);
db.Entry(accountingHistory).State = EntityState.Modified;
db.SaveChanges();
var JSON = Json(new { success = true }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
private void SetInformationForAccountHistory(ref AccountingHistory accountingHistory, AccountList accountlist, int CreateOrUpdate)
{
DateTime dt = AppUtils.GetDateTimeNow();
accountingHistory.Amount = Convert.ToDouble(accountlist.InitialBalance.Value);
if (CreateOrUpdate == 1)//mean create
{
accountingHistory.AccountListID = accountlist.AccountListID;
accountingHistory.ActionTypeID = (int)AppUtils.AccountingHistoryType.AccountList;
accountingHistory.Date = AppUtils.GetDateTimeNow();
accountingHistory.DRCRTypeID = (int)AppUtils.AccountTransactionType.CR;
accountingHistory.Description = "Capital Balance";
accountingHistory.Year = dt.Year;
accountingHistory.Month = dt.Month;
accountingHistory.Day = dt.Day;
accountingHistory.CreateBy = AppUtils.GetLoginUserID();
accountingHistory.CreateDate = dt;
accountingHistory.Status = AppUtils.TableStatusIsActive;
}
else
{
accountingHistory.UpdateBy = AppUtils.GetLoginUserID();
accountingHistory.UpdateDate = dt;
}
}
public ActionResult CreateConfirm(AccountList accountlist)
{
var dbAccounlist = db.AccountList.Where(s => s.AccountTitle == accountlist.AccountTitle).FirstOrDefault();
if (dbAccounlist != null)
{
return(Json(new { nameExist = true }));
}
try
{
accountlist.CreateBy = AppUtils.GetLoginUserID();
accountlist.CreateData = AppUtils.GetDateTimeNow();
accountlist.Status = AppUtils.TableStatusIsActive;
db.AccountList.Add(accountlist);
db.SaveChanges();
AccountingHistory accountingHistory = new AccountingHistory();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, accountlist, 1);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false }));
}
}
public ActionResult DeletePurchasePaymentHistoryByID(GetDetailsByID getByid)
{
try
{
PurchasePaymentHistory pphd = db.PurchasePaymentHistory.Find(getByid.id);
AccountList AccountList = db.AccountList.Find(pphd.AccountListID);
pphd.DeleteBy = AppUtils.GetLoginUserID();
pphd.DeleteDate = AppUtils.GetDateTimeNow();
pphd.Status = AppUtils.TableStatusIsDelete;
db.SaveChanges();
AccountList.InitialBalance += Convert.ToDecimal(pphd.PaymentAmount);
AccountList.UpdateBy = AppUtils.GetLoginUserID();
AccountList.UpdateDate = AppUtils.GetDateTimeNow();
db.SaveChanges();
Purchase purchase = db.Purchase.Find(pphd.PurchaseID);
purchase.PurchasePayment -= pphd.PaymentAmount;
db.SaveChanges();
AccountingHistory accountingHistory = new AccountingHistory();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, pphd, 1);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
return(Json(new { DeleteStatus = true, PaymentStatus = GetPaymentStatus(pphd.Status), DeleteBy = db.Employee.Find(pphd.DeleteBy).LoginName, DeleteDate = pphd.DeleteDate }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { DeleteStatus = false, }, JsonRequestBehavior.AllowGet));
}
}
private void SetInformationForAccountHistory(ref AccountingHistory accountingHistory, PurchasePaymentHistory PurchasePaymentHistory, int CreateOrUpdate)
{
DateTime dt = AppUtils.GetDateTimeNow();
accountingHistory.Amount = Convert.ToDouble(PurchasePaymentHistory.PaymentAmount);
if (CreateOrUpdate == 1)//mean create
{
accountingHistory.PurchaseID = PurchasePaymentHistory.PurchaseID;
accountingHistory.ActionTypeID = (int)AppUtils.AccountingHistoryType.Purchase;
accountingHistory.Date = AppUtils.GetDateTimeNow();
accountingHistory.DRCRTypeID = (int)AppUtils.AccountTransactionType.DR;
accountingHistory.Description = PurchasePaymentHistory.Description;
accountingHistory.Year = dt.Year;
accountingHistory.Month = dt.Month;
accountingHistory.Day = dt.Day;
accountingHistory.CreateBy = AppUtils.GetLoginUserID();
accountingHistory.CreateDate = dt;
accountingHistory.Status = AppUtils.TableStatusIsActive;
}
else
{
accountingHistory.UpdateBy = AppUtils.GetLoginUserID();
accountingHistory.UpdateDate = dt;
}
}
public ActionResult DeleteExpense(int ID)
{
try
{
var Expense = db.Expenses.Where(s => s.ExpenseID == ID).FirstOrDefault();
Expense.DeleteBy = AppUtils.GetLoginUserID();
Expense.DeleteDate = AppUtils.GetDateTimeNow();
Expense.Status = AppUtils.TableStatusIsDelete;
db.Entry(Expense).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
AccountingHistory accountingHistory = db.AccountingHistory.Where(x => x.ExpenseID == Expense.ExpenseID).FirstOrDefault();
accountingHistory.Status = AppUtils.TableStatusIsDelete;
db.SaveChanges();
var JSON = Json(new { success = true }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch (Exception ex)
{
var JSON = Json(new { success = false }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
}
public ActionResult UpdateExpense(FormCollection form, HttpPostedFileBase ExpenseUpdateImage)
{
Expense Expense_Details = JsonConvert.DeserializeObject <Expense>(form["Expense_details"]);
Expense Expense_Db = db.Expenses.Where(s => s.ExpenseID == Expense_Details.ExpenseID).FirstOrDefault();
try
{
AddGivenImageInCurrentRow(ref Expense_Db, Expense_Details, "DescriptionFile", ExpenseUpdateImage, form["DescriptionFilePath"]);
if (Expense_Db.ExpenseID > 0)
{
SetClientExpenseToDatabaseDB(ref Expense_Db, Expense_Details);
db.Entry(Expense_Db).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
AccountingHistory accountingHistory = db.AccountingHistory.Where(x => x.DepositID == Expense_Db.ExpenseID).FirstOrDefault();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, Expense_Db, 2);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult InsertNewExpense(FormCollection form, HttpPostedFileBase DescriptionImage)
{
Expense ExpenseInfo = JsonConvert.DeserializeObject <Expense>(form["NewExpenseInformation"]);
Expense ExpenseReturn = new Expense();
try
{
ExpenseInfo.Status = AppUtils.TableStatusIsActive;
ExpenseInfo.CreateBy = AppUtils.GetLoginUserID();
ExpenseInfo.CreateDate = AppUtils.GetDateTimeNow();
ExpenseReturn = db.Expenses.Add(ExpenseInfo);
db.SaveChanges();
if (DescriptionImage != null)
{
SaveImageInFolderAndAddInformationInVendorTable(ref ExpenseInfo, "DescriptionFile", DescriptionImage);
}
if (ExpenseReturn.ExpenseID > 0)
{
db.SaveChanges();
AccountingHistory accountingHistory = new AccountingHistory();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, ExpenseReturn, 1);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SavePurchasePayment(PurchasePaymentHistory pph)
{
AccountList accountList = db.AccountList.Find(pph.AccountListID);
if (Convert.ToDouble(accountList.InitialBalance.Value) < pph.PaymentAmount)
{
return(Json(new { Success = false, Message = "Sorry This Account Does Not Have Suffiecient Balance ." }, JsonRequestBehavior.AllowGet));
}
accountList.InitialBalance -= Convert.ToDecimal(pph.PaymentAmount);
db.SaveChanges();
DateTime dt = new DateTime();
pph.PurchasePaymentDate = pph.PurchasePaymentDate.AddHours(dt.Hour).AddMinutes(dt.Minute).AddSeconds(dt.Second);
pph.Status = AppUtils.TableStatusIsActive;
pph.CreateBy = AppUtils.GetLoginUserID();
pph.CreateDate = AppUtils.GetDateTimeNow();
db.PurchasePaymentHistory.Add(pph);
db.SaveChanges();
Purchase purchase = db.Purchase.Where(x => x.PurchaseID == pph.PurchaseID).FirstOrDefault();
purchase.PurchasePayment += pph.PaymentAmount;
//db.Entry(purchase).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
AccountingHistory accountingHistory = new AccountingHistory();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, pph, 1);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
return(Json(new { Success = true, Message = "Purchase Payment Added Successfully.", DueAmount = purchase.SubTotal - purchase.PurchasePayment, PaymentStatus = purchase.SubTotal > purchase.PurchasePayment ? "Pending" : "Paid" }, JsonRequestBehavior.AllowGet));
}
public ActionResult SavePurchase(VM_PurchaseAndDetails VM_PurchaseAndDetails)
{
if (VM_PurchaseAndDetails.purchase.PurchaseID == 0)
{
Purchase purchase = db.Purchase.Where(x => x.InvoiceID.ToLower().ToString() == VM_PurchaseAndDetails.purchase.InvoiceID.ToLower().ToString()).FirstOrDefault();
if (purchase != null)
{
return(Json(new { Success = false, Message = "Sorry Invoice Id Already Exist. Please Add Different One." }, JsonRequestBehavior.AllowGet));
}
if (VM_PurchaseAndDetails.purchasedeatils.Count() == 0)
{
return(Json(new { Success = false, Message = "Add Item In Purchsase List." }, JsonRequestBehavior.AllowGet));
}
VM_PurchaseAndDetails.purchase.Total = VM_PurchaseAndDetails.purchasedeatils.Sum(x => x.Price);
//if (VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount > 0)
//{
// if (VM_PurchaseAndDetails.purchase.DiscountType == 1)
// {
// VM_PurchaseAndDetails.purchase.DiscountAmount = (VM_PurchaseAndDetails.purchase.Total / 100) * VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount;
// }
// else
// {
// VM_PurchaseAndDetails.purchase.DiscountAmount = VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount;
// }
//}
if (VM_PurchaseAndDetails.purchase.Discount > 0)
{
if (VM_PurchaseAndDetails.purchase.DiscountType == 1)
{
VM_PurchaseAndDetails.purchase.DiscountAmount = (VM_PurchaseAndDetails.purchase.Total / 100) * VM_PurchaseAndDetails.purchase.Discount;
}
else
{
VM_PurchaseAndDetails.purchase.DiscountAmount = VM_PurchaseAndDetails.purchase.Discount;
}
}
VM_PurchaseAndDetails.purchase.SubTotal = VM_PurchaseAndDetails.purchase.Total - VM_PurchaseAndDetails.purchase.DiscountAmount;
if (VM_PurchaseAndDetails.purchase.IssuedAt.Year == 1)
{
VM_PurchaseAndDetails.purchase.IssuedAt = AppUtils.GetDateNow();
}
VM_PurchaseAndDetails.purchase.Status = AppUtils.TableStatusIsActive;
VM_PurchaseAndDetails.purchase.CreateBy = AppUtils.GetLoginUserID();
VM_PurchaseAndDetails.purchase.CreateDate = AppUtils.GetDateTimeNow();
db.Purchase.Add(VM_PurchaseAndDetails.purchase);
db.SaveChanges();
if (VM_PurchaseAndDetails.purchase.PurchaseID > 0)
{
foreach (var item in VM_PurchaseAndDetails.purchasedeatils)
{
item.PurchaseID = VM_PurchaseAndDetails.purchase.PurchaseID;
item.Status = AppUtils.TableStatusIsActive;
item.CreateBy = AppUtils.GetLoginUserID();
item.CreateDate = AppUtils.GetDateTimeNow();
}
db.PurchaseDeatils.AddRange(VM_PurchaseAndDetails.purchasedeatils);
db.SaveChanges();
AccountingHistory accountingHistory = new AccountingHistory();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, VM_PurchaseAndDetails.purchase, 1);
db.AccountingHistory.Add(accountingHistory);
db.SaveChanges();
}
return(Json(new { Type = "create", Success = true, Message = "Purchase Saved Successfully." }, JsonRequestBehavior.AllowGet));
}
else
{
Purchase purchase = db.Purchase.Where(x => x.InvoiceID.ToLower().ToString() == VM_PurchaseAndDetails.purchase.InvoiceID.ToLower().ToString() && x.PurchaseID != VM_PurchaseAndDetails.purchase.PurchaseID).FirstOrDefault();
if (purchase != null)
{
return(Json(new { Success = false, Message = "Sorry Invoice Id Already Exist. Please Add Different One." }, JsonRequestBehavior.AllowGet));
}
if (VM_PurchaseAndDetails.purchasedeatils.Count() == 0)
{
return(Json(new { Success = false, Message = "Add Item In Purchsase List." }, JsonRequestBehavior.AllowGet));
}
Purchase purchaseDB = db.Purchase.Where(x => x.PurchaseID == VM_PurchaseAndDetails.purchase.PurchaseID).FirstOrDefault();
List <PurchaseDeatils> lstNewPurchaseDetails = VM_PurchaseAndDetails.purchasedeatils.Where(x => x.PurchaseDeatilsID == 0).ToList();
List <PurchaseDeatils> lstOldPurchaseDeatils = VM_PurchaseAndDetails.purchasedeatils.Where(x => x.PurchaseDeatilsID > 0).ToList();
//deleting item if delete from client
List <int> lstOldPurchaseDetails = lstOldPurchaseDeatils.Select(x => x.PurchaseDeatilsID).ToList();
List <PurchaseDeatils> lstDeletePurchaseDetails = db.PurchaseDeatils
.Where(x => !lstOldPurchaseDetails.Contains(x.PurchaseDeatilsID) && x.PurchaseID == VM_PurchaseAndDetails.purchase.PurchaseID && x.Status != AppUtils.TableStatusIsDelete).ToList();
if (lstDeletePurchaseDetails.Count() > 0)
{
lstDeletePurchaseDetails.ForEach(x => { x.Status = AppUtils.TableStatusIsDelete; x.DeleteBy = AppUtils.GetLoginUserID(); x.DeleteDate = AppUtils.GetDateTimeNow(); });
db.SaveChanges();
}
//delete done
// Updating Part
foreach (var item in lstOldPurchaseDeatils)
{
var purchaseDetails = db.PurchaseDeatils.Where(x => x.PurchaseDeatilsID == item.PurchaseDeatilsID).FirstOrDefault();
purchaseDetails.Serial = item.Serial;
purchaseDetails.Price = item.Price;
purchaseDetails.HasWarrenty = item.HasWarrenty;
purchaseDetails.WarrentyStart = item.WarrentyStart;
purchaseDetails.WarrentyEnd = item.WarrentyEnd;
purchaseDetails.UpdateBy = AppUtils.GetLoginUserID();
purchaseDetails.UpdateDate = AppUtils.GetDateTimeNow();
db.Entry(purchaseDetails).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// Update Done
//Create New Details In Purchase
foreach (var item in lstNewPurchaseDetails)
{
item.PurchaseID = VM_PurchaseAndDetails.purchase.PurchaseID;
item.CreateBy = AppUtils.GetLoginUserID();
item.CreateDate = AppUtils.GetDateTimeNow();
db.PurchaseDeatils.Add(item);
db.SaveChanges();
}
//Create Done
//Updating Purchase
purchaseDB.Total = VM_PurchaseAndDetails.purchasedeatils.Where(x => x.Status != AppUtils.TableStatusIsDelete).Sum(x => x.Price);
//if (VM_PurchaseAndDetails.purchase.DiscountType == 1)
//{
// purchaseDB.DiscountPercentOrFixedAmount = Math.Round(VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount);
// purchaseDB.DiscountAmount = Math.Round((purchaseDB.Total / 100) * VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount);
//}
//else
//{
// purchaseDB.DiscountPercentOrFixedAmount = Math.Round(VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount);
// purchaseDB.DiscountAmount = Math.Round(VM_PurchaseAndDetails.purchase.DiscountPercentOrFixedAmount);
//}
if (VM_PurchaseAndDetails.purchase.Discount > 0)
{
if (VM_PurchaseAndDetails.purchase.DiscountType == 1)
{
purchaseDB.DiscountAmount = Math.Round((purchaseDB.Total / 100) * VM_PurchaseAndDetails.purchase.Discount);
}
else
{
purchaseDB.DiscountAmount = Math.Round(VM_PurchaseAndDetails.purchase.Discount);
}
}
purchaseDB.SubTotal = Math.Round(purchaseDB.Total - purchaseDB.DiscountAmount);
purchaseDB.DiscountType = VM_PurchaseAndDetails.purchase.DiscountType;
purchaseDB.UpdateBy = AppUtils.GetLoginUserID();
purchaseDB.UpdateDate = AppUtils.GetDateTimeNow();
purchaseDB.SupplierNoted = VM_PurchaseAndDetails.purchase.SupplierNoted;
db.Entry(purchaseDB).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//Updating Purchase Done
AccountingHistory accountingHistory = db.AccountingHistory.Where(x => x.PurchaseID == purchaseDB.PurchaseID).FirstOrDefault();
//Mode 1 mean Create 2 mean Update
SetInformationForAccountHistory(ref accountingHistory, purchaseDB, 1);
db.Entry(purchaseDB).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new { Type = "update", Success = true, Message = "Purchase Update Successfully." }, JsonRequestBehavior.AllowGet));
}
}
