public ActionResult DeleteInvoice(int id) { AcOPInvoiceDetail acopInvoiceD = entity.AcOPInvoiceDetails.Find(id); int acOPInvoiceMasterID = acopInvoiceD.AcOPInvoiceMasterID.Value; int acjournalid = acopInvoiceD.AcJournalID.Value; entity.AcOPInvoiceDetails.Remove(acopInvoiceD); entity.SaveChanges(); AcOPInvoiceMaster acOPInvoiceM = entity.AcOPInvoiceMasters.Find(acOPInvoiceMasterID); entity.AcOPInvoiceMasters.Remove(acOPInvoiceM); entity.SaveChanges(); AcJournalMaster acJournalMaster = entity.AcJournalMasters.Find(acjournalid); entity.AcJournalMasters.Remove(acJournalMaster); entity.SaveChanges(); AcJournalDetail acJournalD = entity.AcJournalDetails.Where(item => item.AcJournalID == acjournalid).FirstOrDefault(); entity.AcJournalDetails.Remove(acJournalD); entity.SaveChanges(); return(RedirectToAction("Index")); }
public int EditAcJDetails(int acjournalId, decimal amount) { using (SHIPPING_FinalEntities Context1 = new SHIPPING_FinalEntities()) { var query = (from t in Context1.AcJournalDetails where t.AcJournalID == acjournalId select t).ToList(); foreach (var itme1 in query) { AcJournalDetail acjD = new AcJournalDetail(); acjD.AcJournalDetailID = itme1.AcJournalDetailID; acjD.AcJournalID = itme1.AcJournalID; acjD.AcHead = itme1.AcHead; acjD.AcHeadID = itme1.AcHeadID; if (itme1.Amount < 0) { acjD.Amount = -(amount); } else { acjD.Amount = (amount); } acjD.BranchID = itme1.BranchID; acjD.ID = itme1.ID; Context1.Entry(itme1).CurrentValues.SetValues(acjD); Context1.SaveChanges(); } return(1); } }
public void saveGridData(string InvoiceNo, string JobCode, DateTime InvoiceDate, DateTime LastTransDate, decimal Amount, int AcJournalID, int AcOPInvoiceMasterId) { //save data in acjournalDetails AcJournalDetail acjournalDetailsDR = new AcJournalDetail(); acjournalDetailsDR.AcJournalID = AcJournalID; acjournalDetailsDR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); //if(CustomerHeadID==0) //{ // acjournalDetailsDR.AcHeadID =SupplierHeadId; //} //if (SupplierHeadId == 0) //{ // acjournalDetailsDR.AcHeadID = CustomerHeadID; //} acjournalDetailsDR.BranchID = Convert.ToInt32(Session["branchid"]); acjournalDetailsDR.PartyID = Convert.ToInt32(Session["AcCompanyID"]); acjournalDetailsDR.Amount = (-1) * Convert.ToDecimal(Amount); entity.AcJournalDetails.Add(acjournalDetailsDR); entity.SaveChanges(); AcJournalDetail acjournalDetailsCR = new AcJournalDetail(); acjournalDetailsCR.AcJournalID = AcJournalID; acjournalDetailsCR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); //if (CustomerHeadID == 0) //{ // acjournalDetailsDR.AcHeadID = SupplierHeadId; //} //if (SupplierHeadId == 0) //{ // acjournalDetailsDR.AcHeadID = CustomerHeadID; //} acjournalDetailsDR.BranchID = Convert.ToInt32(Session["branchid"]); acjournalDetailsDR.PartyID = Convert.ToInt32(Session["AcCompanyID"]); acjournalDetailsCR.Amount = Convert.ToDecimal(Amount); entity.AcJournalDetails.Add(acjournalDetailsCR); entity.SaveChanges(); //save data in acopInvoiceDetails AcOPInvoiceDetail acOPInvoiceDetails = new AcOPInvoiceDetail(); acOPInvoiceDetails.AcOPInvoiceDetailID = objectSourceModel.GetMaxNumberAcOpeningInvoiceDetails(); acOPInvoiceDetails.StatusClose = false; acOPInvoiceDetails.LastTransDate = LastTransDate; acOPInvoiceDetails.JobCode = JobCode; acOPInvoiceDetails.InvoiceNo = InvoiceNo; acOPInvoiceDetails.InvoiceDate = InvoiceDate; acOPInvoiceDetails.Amount = Amount; acOPInvoiceDetails.AcJournalID = AcJournalID; acOPInvoiceDetails.AcOPInvoiceMasterID = AcOPInvoiceMasterId; entity.AcOPInvoiceDetails.Add(acOPInvoiceDetails); entity.SaveChanges(); }
public ActionResult DeleteCustomerJournal( int id) { AcJournalDetail acJournalD = entity.AcJournalDetails.Find(id); int acjournalid = acJournalD.AcJournalID.Value; var data = entity.AcJournalDetails.Where(item => item.AcJournalID == acjournalid).ToList(); foreach (var item in data) { entity.AcJournalDetails.Remove(item); entity.SaveChanges(); } AcJournalMaster acJournalMaster = entity.AcJournalMasters.Find(acjournalid); entity.AcJournalMasters.Remove(acJournalMaster); entity.SaveChanges(); return RedirectToAction("CustomerJList"); }
public void saveGridData(string AcHeadid, string amount, string remark, string debiteorcredit, int AcJournalID) { AcJournalDetail acjournalDetailsDR = new AcJournalDetail(); acjournalDetailsDR.AcJournalID = AcJournalID; acjournalDetailsDR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); acjournalDetailsDR.AcHeadID = Convert.ToInt32(AcHeadid); acjournalDetailsDR.Amount = (-1) * Convert.ToDecimal(amount); acjournalDetailsDR.Remarks = remark; entity.AcJournalDetails.Add(acjournalDetailsDR); entity.SaveChanges(); AcJournalDetail acjournalDetailsCR = new AcJournalDetail(); acjournalDetailsCR.AcJournalID = AcJournalID; acjournalDetailsCR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); acjournalDetailsCR.AcHeadID = Convert.ToInt32(AcHeadid); acjournalDetailsCR.Amount = Convert.ToDecimal(amount); acjournalDetailsCR.Remarks = remark; entity.AcJournalDetails.Add(acjournalDetailsCR); entity.SaveChanges(); }
public ActionResult Create1(DebitNoteVM v) { AcJournalMaster ajm = new AcJournalMaster(); int acjm = 0; acjm = (from c in db.AcJournalMasters orderby c.AcJournalID descending select c.AcJournalID).FirstOrDefault(); ajm.AcJournalID = acjm + 1; ajm.AcCompanyID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); ajm.AcFinancialYearID = Convert.ToInt32(Session["fyearid"].ToString()); ajm.PaymentType = 1; ajm.Remarks = "Debit Note"; ajm.StatusDelete = false; ajm.TransDate = v.Date; ajm.VoucherNo = "DB-" + ajm.AcJournalID; ajm.TransType = 1; ajm.VoucherType = ""; db.AcJournalMasters.Add(ajm); db.SaveChanges(); AcJournalDetail a = new AcJournalDetail(); int maxacj = 0; maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); a.AcJournalDetailID = maxacj + 1; a.AcJournalID = ajm.AcJournalID; a.AcHeadID = v.AcHeadID; a.Amount = v.Amount; a.BranchID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); a.Remarks = ""; db.AcJournalDetails.Add(a); db.SaveChanges(); AcJournalDetail b = new AcJournalDetail(); maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); b.AcJournalDetailID = maxacj + 1; b.AcJournalID = ajm.AcJournalID; b.AcHeadID = v.AcHeadID; b.Amount = -v.Amount; b.BranchID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); b.Remarks = ""; db.AcJournalDetails.Add(b); db.SaveChanges(); //var ids = (from x in db.PurchaseInvoiceDetails where x.PurchaseInvoiceID == v.InvoiceNo select (int?)x.PurchaseInvoiceDetailID).ToList(); //int recpayid = (from c in db.RecPayDetails where ids.Contains(c.InvoiceID) select c.RecPayID).FirstOrDefault().Value; int recpayid = 0; int max = 0; var data = (from c in db.DebitNotes orderby c.DebitNoteID descending select c).FirstOrDefault(); if (data == null) { max = 1; } else { max = data.DebitNoteID + 1; } DebitNote d = new DebitNote(); d.DebitNoteID = max + 1; d.DebitNoteNo = "D-" + (max + 1); d.InvoiceID = v.InvoiceID; d.DebitNoteDate = v.Date; d.Amount = v.Amount; d.AcJournalID = ajm.AcJournalID; d.FYearID = Convert.ToInt32(Session["fyearid"].ToString()); d.AcCompanyID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); d.RecPayID = recpayid; d.AcHeadID = v.AcHeadID; d.SupplierID = v.SupplierID; d.InvoiceType = "S"; //d.IsShipping = true; d.Remarks = v.Remarks; db.DebitNotes.Add(d); db.SaveChanges(); TempData["SuccessMsg"] = "Successfully Added Debit Note"; return(RedirectToAction("List", "DebitNote")); }
public ActionResult Create(DebitNoteVM v) { var userid = Convert.ToInt32(Session["UserID"]); int BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); AcJournalMaster ajm = new AcJournalMaster(); int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); if (v.DebitNoteId > 0) { ajm = db.AcJournalMasters.Find(v.AcJournalID); var ajmd = db.AcJournalDetails.Where(cc => cc.AcJournalID == v.AcJournalID).ToList(); db.AcJournalDetails.RemoveRange(ajmd); db.AcJournalMasters.Remove(ajm); db.SaveChanges(); v.AcJournalID = 0; } if (v.AcJournalID == 0) { int acjm = 0; acjm = (from c in db.AcJournalMasters orderby c.AcJournalID descending select c.AcJournalID).FirstOrDefault(); ajm.AcJournalID = acjm + 1; ajm.AcCompanyID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); ajm.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); ajm.AcFinancialYearID = fyearid; ajm.PaymentType = 1; var customer = db.SupplierMasters.Find(v.SupplierID).SupplierName; ajm.Remarks = v.Remarks; // + " DN: for " + customer + " invoice : " + v.InvoiceNo; ajm.StatusDelete = false; ajm.VoucherNo = AccountsDAO.GetMaxVoucherNo(v.TransType, fyearid); ajm.TransDate = v.Date; ajm.TransType = 1; ajm.VoucherType = v.TransType; db.AcJournalMasters.Add(ajm); db.SaveChanges(); } AcJournalDetail a = new AcJournalDetail(); a = db.AcJournalDetails.Where(cc => cc.AcJournalID == ajm.AcJournalID && cc.Amount > 0).FirstOrDefault(); if (a == null) { a = new AcJournalDetail(); a.AcJournalDetailID = 0; } if (a.AcJournalDetailID == 0) { int maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); a.AcJournalDetailID = maxacj + 1; a.AcJournalID = ajm.AcJournalID; //var customercon = db.AcHeads.Where(cc => cc.AcHead1 == "Supplier Control A/c ( Cr)").FirstOrDefault(); a.AcHeadID = 337; //customercon.AcHeadID; ; } a.Amount = v.Amount; a.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); a.Remarks = v.Remarks; if (a.ID == 0) { db.AcJournalDetails.Add(a); db.SaveChanges(); } else { db.Entry(a).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } foreach (var detail in v.Details) { AcJournalDetail b = new AcJournalDetail(); b = db.AcJournalDetails.Where(cc => cc.AcJournalID == ajm.AcJournalID && cc.Amount < 0).FirstOrDefault(); if (b == null) { b = new AcJournalDetail(); b.AcJournalDetailID = 0; } if (b.AcJournalDetailID == 0) { int maxacj = 0; maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); b.AcJournalDetailID = maxacj + 1; b.AcJournalID = ajm.AcJournalID; } b.AcHeadID = v.AcHeadID; if (v.TransType == "DN") { b.Amount = -1 * detail.Amount; } else { b.Amount = detail.Amount; } b.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); b.Remarks = detail.Remarks; if (b.ID == 0) { db.AcJournalDetails.Add(b); db.SaveChanges(); } else { db.Entry(b).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } DebitNote d = new DebitNote(); if (v.DebitNoteId == 0) { int maxid = 0; var data = (from c in db.DebitNotes orderby c.DebitNoteID descending select c).FirstOrDefault(); if (data == null) { maxid = 1; } else { maxid = data.DebitNoteID + 1; } d.CreatedBy = userid; d.CreatedDate = CommanFunctions.GetCurrentDateTime(); d.DebitNoteID = maxid; d.DebitNoteNo = AccountsDAO.GetMaxDebiteNoteNo(fyearid); } else { d = db.DebitNotes.Find(v.DebitNoteId); var det = db.DebitNoteDetails.Where(cc => cc.DebitNoteID == v.DebitNoteId).ToList(); if (det != null) { db.DebitNoteDetails.RemoveRange(det); db.SaveChanges(); } } d.InvoiceType = v.InvoiceType; d.TransType = v.TransType; if (v.InvoiceID != 0) { if (v.TransType == "DN") { d.InvoiceID = v.InvoiceID; } else { d.RecPayID = v.InvoiceID; } } else { d.InvoiceID = 0; } d.DebitNoteDate = v.Date; d.Amount = v.Amount; d.AcJournalID = ajm.AcJournalID; d.FYearID = Convert.ToInt32(Session["fyearid"].ToString()); d.AcCompanyID = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); d.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); d.AcHeadID = 527;; d.SupplierID = v.SupplierID; d.ModifiedBy = userid; d.ModifiedDate = CommanFunctions.GetCurrentDateTime(); d.Remarks = v.Remarks; //d.IsShipping = true; if (v.DebitNoteId == 0) { db.DebitNotes.Add(d); db.SaveChanges(); TempData["SuccessMsg"] = "Successfully Added Debit Note"; } else { db.Entry(d).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["SuccessMsg"] = "Successfully Updated Debit Note"; } foreach (var detail in v.Details) { DebitNoteDetail det = new DebitNoteDetail(); det.AcHeadID = detail.AcHeadID; det.Amount = detail.Amount; det.Remarks = detail.Remarks; det.DebitNoteID = d.DebitNoteID; db.DebitNoteDetails.Add(det); db.SaveChanges(); } return(RedirectToAction("Index", "DebitNote")); }
public ActionResult Create(DRSReceiptVM v) { DRSReceipt tbl = new DRSReceipt(); AcJournalMaster _AcJournalMaster = new AcJournalMaster(); AcJournalDetail _AcJournalDetail = new AcJournalDetail(); try { int max = (from c in db.DRSReceipts orderby c.DRSReceiptID descending select c.DRSReceiptID).FirstOrDefault(); if (max == null) { max = 1; } else { max = max + 1; } tbl.DRSReceiptID = max; _AcJournalMaster.VoucherNo = tbl.DRSReceiptID.ToString(); tbl.DRSNo = v.DRSNo; tbl.EmployeeID = v.EmployeeID; tbl.DRSReceiptDate = v.DRSReceiptDate; tbl.DepartmentID = v.DepartmentID; tbl.VehicleID = v.VehicleID; tbl.Amount = v.Amount; tbl.Remarks = v.Remarks; tbl.AcCompanyID = Convert.ToInt32(Session["CurrenctCompanyID"].ToString()); tbl.User1 = Convert.ToInt32(Session["UserID"].ToString()); tbl.FYearID = Convert.ToInt32(Session["fyearid"].ToString()); db.DRSReceipts.Add(tbl); db.SaveChanges(); int acjmax = (from c in db.AcJournalMasters orderby c.AcJournalID descending select c.AcJournalID).FirstOrDefault(); if (acjmax == null) { acjmax = 1; } else { acjmax = acjmax + 1; } _AcJournalMaster.AcJournalID = acjmax; _AcJournalMaster.TransDate = v.DRSReceiptDate; _AcJournalMaster.AcFinancialYearID = Convert.ToInt32(Session["fyearid"].ToString()); _AcJournalMaster.UserID = Convert.ToInt32(Session["UserID"].ToString()); _AcJournalMaster.AcCompanyID = Convert.ToInt32(Session["CurrenctCompanyID"].ToString()); _AcJournalMaster.Remarks = v.Remarks; _AcJournalMaster.VoucherType = "CI"; _AcJournalMaster.TransType = 1; _AcJournalMaster.StatusDelete = Convert.ToBoolean(0); db.AcJournalMasters.Add(_AcJournalMaster); db.SaveChanges(); var DRSUpdate = (from a in db.DRSReceipts where a.DRSReceiptID == tbl.DRSReceiptID select a).FirstOrDefault(); var id = (from a in db.AcJournalMasters orderby a.AcJournalID descending select a).FirstOrDefault(); DRSUpdate.AcJournalID = id.AcJournalID; db.Entry(DRSUpdate).State = EntityState.Modified; db.SaveChanges(); int maxacjdid = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); if (maxacjdid == null) { maxacjdid = 1; } else { maxacjdid = maxacjdid + 1; } _AcJournalDetail.AcJournalDetailID = maxacjdid; _AcJournalDetail.AcJournalID = id.AcJournalID; _AcJournalDetail.Amount = v.Amount; _AcJournalDetail.Remarks = v.Remarks; _AcJournalDetail.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); db.AcJournalDetails.Add(_AcJournalDetail); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Added DRS Receipt."; return(RedirectToAction("Index")); } catch (Exception) { throw; } }
private bool DeleteorInsertAcJounalDetails(int?AcMasterId, int salesinvoiceid) { var deleteolddetails = (from d in entity.AcJournalDetails where d.AcJournalID == AcMasterId select d).ToList(); foreach (var item in deleteolddetails) { entity.AcJournalDetails.Remove(item); entity.SaveChanges(); } var salesinvoice = (from d in entity.SalesInvoices where d.SalesInvoiceID == salesinvoiceid select d).FirstOrDefault(); var salesinvoicedetails = (from d in entity.SalesInvoiceDetails where d.SalesInvoiceID == salesinvoiceid select d).ToList(); var pageControl = (from d in entity.PageControlMasters where d.ControlName.ToLower() == "sales invoice" select d).FirstOrDefault(); var ControlFields = (from d in entity.PageControlFields where d.PageControlId == pageControl.Id select d).ToList(); var accontrolheads = (from d in entity.AcHeadControls where d.Pagecontrol == pageControl.Id select d).ToList(); var totalamount = salesinvoicedetails.Sum(d => d.NetValue) - salesinvoicedetails.Sum(d => d.Tax); var totaltax = salesinvoicedetails.Sum(d => d.Tax); var salesval = totalamount + totaltax; decimal?discount = 0; if (salesinvoice.DiscountType == 1) { if (salesinvoice.DiscountValueFC == 0 || salesinvoice.DiscountValueFC == null) { discount = totalamount * salesinvoice.DiscountValueLC / 100; } else { discount = totalamount * salesinvoice.DiscountValueFC / 100; } } else { if (salesinvoice.DiscountValueFC == 0 || salesinvoice.DiscountValueFC == null) { discount = salesinvoice.DiscountValueLC; } else { discount = salesinvoice.DiscountValueFC; } } var sumval = 0; foreach (var item in accontrolheads) { if (item.Remarks == 0) { } else { var field = ControlFields.Where(d => d.Id == item.Remarks).FirstOrDefault(); if (field.FieldName.ToLower() == "invoice total") { var acjournal_details = new AcJournalDetail(); int maxAcJ_DetailID = 0; maxAcJ_DetailID = (from c in entity.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); acjournal_details.AcJournalDetailID = maxAcJ_DetailID + 1; acjournal_details.AcHeadID = item.AccountHeadID;//SalesKt acjournal_details.AcJournalID = AcMasterId; if (item.AccountNature == true) { acjournal_details.Amount = totalamount; } else { acjournal_details.Amount = totalamount * -1; } entity.AcJournalDetails.Add(acjournal_details); entity.SaveChanges(); } else if (field.FieldName.ToLower() == "tax") { var acjournal_details = new AcJournalDetail(); int maxAcJ_DetailID = 0; maxAcJ_DetailID = (from c in entity.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); acjournal_details.AcJournalDetailID = maxAcJ_DetailID + 1; acjournal_details.AcHeadID = item.AccountHeadID;//SalesKt acjournal_details.AcJournalID = AcMasterId; if (item.AccountNature == true) { acjournal_details.Amount = totaltax; } else { acjournal_details.Amount = totaltax * -1; } entity.AcJournalDetails.Add(acjournal_details); entity.SaveChanges(); } else if (field.FieldName.ToLower() == "discount") { var acjournal_details = new AcJournalDetail(); int maxAcJ_DetailID = 0; maxAcJ_DetailID = (from c in entity.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); acjournal_details.AcJournalDetailID = maxAcJ_DetailID + 1; acjournal_details.AcHeadID = item.AccountHeadID;//SalesKt acjournal_details.AcJournalID = AcMasterId; if (item.AccountNature == true) { acjournal_details.Amount = discount; } else { acjournal_details.Amount = discount * -1; } entity.AcJournalDetails.Add(acjournal_details); entity.SaveChanges(); } } } foreach (var item in accontrolheads) { var getallentries = (from d in entity.AcJournalDetails where d.AcJournalID == AcMasterId select d).ToList(); var Creditamount = getallentries.Where(d => d.Amount < 0).ToList(); var Debitamount = getallentries.Where(d => d.Amount > 0).ToList(); var Diffval = (Creditamount.Sum(d => d.Amount) * -1) - Debitamount.Sum(d => d.Amount); if (item.Remarks == 0) { var acjournal_details = new AcJournalDetail(); int maxAcJ_DetailID = 0; maxAcJ_DetailID = (from c in entity.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); acjournal_details.AcJournalDetailID = maxAcJ_DetailID + 1; acjournal_details.AcHeadID = item.AccountHeadID;//SalesKt acjournal_details.AcJournalID = AcMasterId; if (item.AccountNature == true) { acjournal_details.Amount = Diffval; } else { acjournal_details.Amount = Diffval * -1; } entity.AcJournalDetails.Add(acjournal_details); entity.SaveChanges(); break; } } return(true); }
private bool DeleteorInsertAcJounalDetails(int?AcMasterId, int PurchaseInvoiceId) { var deleteolddetails = (from d in entity.AcJournalDetails where d.AcJournalID == AcMasterId select d).ToList(); foreach (var item in deleteolddetails) { entity.AcJournalDetails.Remove(item); entity.SaveChanges(); } var Purchaseinvoicedetails = (from d in entity.PurchaseInvoiceDetails where d.PurchaseInvoiceID == PurchaseInvoiceId select d).ToList(); var totalamount = Purchaseinvoicedetails.Sum(d => d.NetValue) - Purchaseinvoicedetails.Sum(d => d.Tax); var totaltax = Purchaseinvoicedetails.Sum(d => d.Tax); var salesval = totalamount + totaltax; var Cos = totalamount * 10 / 100; //saleskt var acjournaldetails = new AcJournalDetail(); int maxAcJDetailID = 0; maxAcJDetailID = (from c in entity.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); acjournaldetails.AcJournalDetailID = maxAcJDetailID + 1; acjournaldetails.AcHeadID = (from d in entity.AcHeads where d.AcHead1.ToLower() == "sales kt" select d.AcHeadID).FirstOrDefault();//SalesKt acjournaldetails.AcJournalID = AcMasterId; acjournaldetails.Amount = totalamount * -1; entity.AcJournalDetails.Add(acjournaldetails); entity.SaveChanges(); //Vat payable var acjournaldetails1 = new AcJournalDetail(); acjournaldetails1.AcJournalDetailID = maxAcJDetailID + 2; acjournaldetails1.AcHeadID = (from d in entity.AcHeads where d.AcHead1.ToLower() == "vat payable" select d.AcHeadID).FirstOrDefault();//vatpayable acjournaldetails1.AcJournalID = AcMasterId; acjournaldetails1.Amount = totaltax * -1; entity.AcJournalDetails.Add(acjournaldetails1); entity.SaveChanges(); //Customercontrolamt var acjournaldetails2 = new AcJournalDetail(); acjournaldetails2.AcJournalDetailID = maxAcJDetailID + 3; acjournaldetails2.AcHeadID = (from d in entity.AcHeads where d.AcHead1.ToLower() == "customer control accounts" select d.AcHeadID).FirstOrDefault();//customercontrolaccounts acjournaldetails2.AcJournalID = AcMasterId; acjournaldetails2.Amount = salesval; entity.AcJournalDetails.Add(acjournaldetails2); entity.SaveChanges(); //costofsales var acjournaldetails3 = new AcJournalDetail(); acjournaldetails3.AcJournalDetailID = maxAcJDetailID + 4; acjournaldetails3.AcHeadID = (from d in entity.AcHeads where d.AcHead1.ToLower() == "cost of sales" select d.AcHeadID).FirstOrDefault();//costofsales acjournaldetails3.AcJournalID = AcMasterId; acjournaldetails3.Amount = Cos; entity.AcJournalDetails.Add(acjournaldetails3); entity.SaveChanges(); //inventorycontrolaccounts var acjournaldetails4 = new AcJournalDetail(); acjournaldetails4.AcJournalDetailID = maxAcJDetailID + 5; acjournaldetails4.AcHeadID = (from d in entity.AcHeads where d.AcHead1.ToLower() == "inventory control accounts" select d.AcHeadID).FirstOrDefault();//costofsales acjournaldetails4.AcJournalID = AcMasterId; acjournaldetails4.Amount = Cos * -1; entity.AcJournalDetails.Add(acjournaldetails4); entity.SaveChanges(); return(true); }
public ActionResult Create(AWBillVM v) { try { string AWBNo = string.Empty; if (v.AWBNO != string.Empty) { AWBNo = v.AWBNO; } else { string aw = (from c in db.InScans orderby c.AWBNo descending select c.AWBNo).FirstOrDefault(); int a = Convert.ToInt32(aw) + 1; AWBNo = a.ToString(); } int CurrentBranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); var ahead = db.AcHeadAssigns.FirstOrDefault(); // commented on sep 21 2020 Where(x => x.BranchID == CurrentBranchID).FirstOrDefault(); try { var ajm = new AcJournalMaster() { AcJournalID = GetMaxAcJournalID() + 1, VoucherNo = "C.Note" + AWBNo, TransDate = DateTime.UtcNow, AcFinancialYearID = Convert.ToInt32(Session["CurrentYear"].ToString()), VoucherType = "DX", TransType = 1, StatusDelete = false, Remarks = "", UserID = Convert.ToInt32(Session["UserID"].ToString()), AcCompanyID = Convert.ToInt32(Session["CurrenctCompanyID"].ToString()), //BranchID = this.CurrentBranchID, Reference = "", ShiftID = 0, }; db.AcJournalMasters.Add(ajm); db.SaveChanges(); if (v.paymentmode != "CSR" && v.TotalCharges > 0) { if (ahead != null) { int aheadassign = 0; switch (v.paymentmode) { case "COD": aheadassign = ahead.CODControlID.Value; break; //CODControlID case "FOC": aheadassign = ahead.FOCControlID.Value; break; //FOCControlID case "PKP": aheadassign = ahead.ProvisionCostControlAcID.Value; break; //UnPostedSalesAcHeadID default: break; } if (aheadassign != 0 && Convert.ToDecimal(v.TotalCharges) != 0) { AcJournalDetail ajd = new AcJournalDetail() { AcJournalDetailID = GetMaxAcJournalDetailID() + 1, AcJournalID = ajm.AcJournalID, AcHeadID = aheadassign, Amount = Convert.ToDecimal(v.TotalCharges), Remarks = "", }; db.AcJournalDetails.Add(ajd); db.SaveChanges(); ajd = new AcJournalDetail() { AcJournalDetailID = GetMaxAcJournalDetailID() + 1, AcJournalID = ajm.AcJournalID, AcHeadID = aheadassign, Amount = -Convert.ToDecimal(v.TotalCharges), Remarks = "", }; db.AcJournalDetails.Add(ajd); db.SaveChanges(); } } } else if (v.paymentmode == "CSR" && v.TotalCharges > 0) { AcJournalDetail ajd = new AcJournalDetail() { AcJournalDetailID = GetMaxAcJournalDetailID() + 1, AcJournalID = ajm.AcJournalID, AcHeadID = ahead.MaterialCostControlReceivableAcHeadID, Amount = Convert.ToDecimal(v.TotalCharges), Remarks = "", }; db.AcJournalDetails.Add(ajd); db.SaveChanges(); ajd = new AcJournalDetail() { AcJournalDetailID = GetMaxAcJournalDetailID() + 1, AcJournalID = ajm.AcJournalID, AcHeadID = ahead.MaterialCostControlReceivableAcHeadID, Amount = -Convert.ToDecimal(v.TotalCharges), Remarks = "", }; db.AcJournalDetails.Add(ajd); db.SaveChanges(); } InScan inscan = new InScan(); inscan.InScanID = GetMaxInscanID(); //inscan.AWBNumberMode = IsAWBAutoManual; inscan.BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString()); inscan.AWBNo = AWBNo; inscan.Remarks = v.Remarks; inscan.UserID = Convert.ToInt32(Session["UserID"].ToString()); inscan.EnquiryID = 0; inscan.StatusClose = false; inscan.MovementID = v.movementID; inscan.AcJournalID = ajm.AcJournalID; inscan.AcCompanyID = Convert.ToInt32(Session["CurrenctCompanyID"].ToString()); inscan.StatusReconciled = false; if (v.Date != null) { inscan.InScanDate = v.Date.Value; //inscan.InScanDate = DateTime.Parse(deDate.SelectedDate.Value.Date.ToString("dd/MM/yyyy") + " " + deDate.SelectedDate.Value.ToString("HH:mm:ss")); //DateTime.Parse(deDate.SelectedDate.Value.Date.ToString("dd/MM/yyyy") + " " + this.rtpTime.SelectedDate.Value.ToString("HH:mm:ss")), } inscan.StatusInScan = "CN"; inscan.CustomerRateTypeID = 0; if (v.CustomerRateTypeID != null) { inscan.CustomerRateTypeID = v.CustomerRateTypeID; } inscan.Tax = 0; if (v.Tax != null) { inscan.Tax = v.Tax; } if (v.Pieces != null) { inscan.Pieces = v.Pieces; } inscan.StatedWeight = 0; if (v.Weight != null) { inscan.StatedWeight = v.Weight; } inscan.CourierDescriptionID = 0; if (v.CourierType != null) { inscan.CourierDescriptionID = v.CourierType; } inscan.CourierServiceID = 0; if (v.ProductType != null) { inscan.CourierServiceID = v.ProductType; } if (v.Agent != null) { inscan.IAgentID = 0; inscan.PickupCharges = 0; inscan.CollectedAmount = 0; inscan.PickupCharges = 0; inscan.CollectedBy = 0; inscan.ReceivedBy = 0; if (v.Agent != null) { inscan.IAgentID = Convert.ToInt32(v.Agent); if (v.collectedamt != null) { inscan.CollectedAmount = Convert.ToDecimal(v.collectedamt); } if (v.pickupcharge != null) { inscan.PickupCharges = Convert.ToDecimal(v.pickupcharge); } } } else { if (v.CollectedByDetails != null) { inscan.CollectedBy = v.CollectedByDetails; } } inscan.ReceivedBy = 0; if (v.ReceivedBy != null) { inscan.ReceivedBy = v.ReceivedBy; } inscan.CourierCharge = 0; if (v.CourierCharges != null) { inscan.CourierCharge = v.CourierCharges; } inscan.OtherCharge = 0; if (v.OtherCharges != null) { inscan.OtherCharge = v.OtherCharges; } inscan.ServiceCharge = 0; if (v.ServiceCharges != null) { inscan.ServiceCharge = v.ServiceCharges; } inscan.PackingCharge = 0; if (v.PackingCharges != null) { inscan.PackingCharge = v.PackingCharges; } if (v.paymentmode != null) { inscan.StatusPaymentMode = v.paymentmode; } inscan.OriginID = 0; if (v.origincountry != null) { inscan.OriginID = v.origincountry; } if (v.destinationCountry != null) { inscan.DestinationID = v.destinationCountry.ToString(); } inscan.ConsignorCityID = 0; if (v.origincity != null) { inscan.ConsignorCityID = v.origincity; } inscan.ConsigneeCityID = 0; if (v.destinationCity != null) { inscan.ConsigneeCityID = v.destinationCity; } if (v.CourierMode != null && v.CourierType != null) { inscan.TaxconfigurationID = (from tc1 in db.TaxConfigurations where tc1.EffectFromDate <= DateTime.UtcNow && tc1.CourierMoveMentID == Convert.ToInt32(v.CourierMode) && tc1.ParcelTypeId == v.CourierType select tc1.TaxConfigurationID).FirstOrDefault(); } inscan.CustomerID = 0; if (v.CustomerID != null) { inscan.CustomerID = v.CustomerID; } inscan.Consignee = v.consignee; inscan.Consignor = v.shipper; inscan.ConsigneeAddress = v.Consigneeaddress; inscan.ConsignorAddress = v.shipperaddress; if (v.ConsigneePhone != null) { inscan.ConsigneePhone = v.ConsigneePhone; } if (v.shipperphone != null) { inscan.ConsignorPhone = v.shipperphone; } inscan.ConsigneeCountryID = 0; if (v.destinationCountry != null) { inscan.ConsigneeCountryID = v.destinationCountry; } inscan.ConsignorCountryID = 0; if (v.origincountry != null) { inscan.ConsignorCountryID = v.origincountry; } if (v.originlocation != null) { inscan.ConsignorLocation = v.originlocation; } if (v.destinationLocation != null) { inscan.ConsigneeLocation = v.destinationLocation; } inscan.AcTaxJournalID = 0; inscan.BalanceAmt = 0; if (v.TotalCharges != null) { inscan.BalanceAmt = v.TotalCharges; } inscan.TypeOfGoodID = 0; if (v.InvoiceValue != null) { inscan.InvoiceValue = v.InvoiceValue; } inscan.MaterialCost = 0; if (v.MaterialCost != null) { inscan.MaterialCost = v.MaterialCost; } inscan.ReferenceAWBNo = v.ReferenceNumber; inscan.MaterialDescription = v.MaterialDescription; if (v.RevisedRate != null) { inscan.RevisedRate = v.RevisedRate; } if (v.SpecialInstructions != null) { inscan.SpecialInstructions = v.SpecialInstructions; } inscan.ConsigneeAddress1 = ""; inscan.ConsigneeAddress2 = ""; inscan.ConsignorAddress1 = ""; inscan.ConsignorAddress2 = ""; inscan.ConsigneeContact = v.consigneecontact; inscan.ConsignorContact = v.consigneecontact; inscan.CargoDescription = v.CargoDescription; inscan.HandlingInstruction = v.HandlingInstructions; inscan.CustomsCollectedBy = 0; if (v.ReceivedBy != null) { inscan.CustomsCollectedBy = v.ReceivedBy; } db.InScans.Add(inscan); db.SaveChanges(); InScanInternationalDeatil isid = new InScanInternationalDeatil(); isid.InScanID = 0; ////InScanInternationalDeatilID = Common.GetMaxNumber("InScanInternationalDeatilID", "InScanInternationalDeatils"), isid.InScanID = inscan.InScanID; ////InscanInternationalID = isi.InScanInternationalID, isid.VerifiedWeight = 0; if (v.VerifiedWeight != null) { isid.VerifiedWeight = Convert.ToDecimal(v.VerifiedWeight); } //if (txtForwardingCharge.Text != string.Empty) //{ // isid.ForwardingCharge = Convert.ToDecimal(txtForwardingCharge.Value); //} ////context.InScanInternationalDeatils.InsertOnSubmit(isid); InScanInternational isi = new InScanInternational(); ////InScanInternationalID = Common.GetMaxNumber("InScanInternationalID", "InScanInternational"), ////FAgentID = -1, isi.FAgentID = 0; if (v.ForwardingAgentID != null) { isi.FAgentID = v.ForwardingAgentID; } else { isi.FAgentID = 0; } if (v.ForwardingDate != null) { isi.ForwardingDate = v.ForwardingDate.Value; } isi.VerifiedWeight = 0; if (v.VerifiedWeight != null) { isi.VerifiedWeight = v.VerifiedWeight; } //if (txtForwardingCharge.Text != string.Empty) //{ // isi.ForwardingCharge = Convert.ToDecimal(txtForwardingCharge.Value); //} isi.StatusAssignment = false; isi.ForwardingAWBNo = v.ForwardingAWB; isid.InscanInternationalID = isi.InScanInternationalID; isi.InScanID = inscan.InScanID; if (v.ForwardingAgentID != null) { isi.FAgentID = v.ForwardingAgentID; } if (v.ForwardingDate != null) { isi.ForwardingDate = v.ForwardingDate.Value; } db.InScanInternationals.Add(isi); db.SaveChanges(); db.InScanInternationalDeatils.Add(isid); db.SaveChanges(); int max = (from c in db.AWBStatus orderby c.AWBStatusID descending select c.AWBStatusID).FirstOrDefault(); if (max == null) { max = 1; } else { max = max + 1; } AWBStatu astat = new AWBStatu() { AWBStatusID = max, StatusDescriptionID = inscan.InScanID, AWBNO = AWBNo, Date = inscan.InScanDate, Status = "DetailsUpdated", FormID = "IN", }; db.AWBStatus.Add(astat); db.SaveChanges(); } catch (Exception e) { } } catch (Exception ex) { } return(RedirectToAction("Index")); }
public ActionResult Create(CreditNoteVM v) { AcJournalMaster ajm = new AcJournalMaster(); int acjm = 0; acjm = (from c in db.AcJournalMasters orderby c.AcJournalID descending select c.AcJournalID).FirstOrDefault(); ajm.AcJournalID = acjm + 1; ajm.AcCompanyID = Convert.ToInt32(Session["AcCompanyID"].ToString()); ajm.AcFinancialYearID = Convert.ToInt32(Session["fyearid"].ToString()); ajm.PaymentType = 1; ajm.Remarks = "Credit Note"; ajm.StatusDelete = false; ajm.TransDate = v.Date; ajm.VoucherNo = "C-" + ajm.AcJournalID; ajm.TransType = 2; ajm.VoucherType = ""; db.AcJournalMasters.Add(ajm); db.SaveChanges(); AcJournalDetail b = new AcJournalDetail(); int maxacj = 0; maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); b.AcJournalDetailID = maxacj + 1; b.AcJournalID = ajm.AcJournalID; b.AcHeadID = v.AcHeadID; b.Amount = -v.Amount; b.BranchID = Convert.ToInt32(Session["AcCompanyID"].ToString()); b.Remarks = ""; db.AcJournalDetails.Add(b); db.SaveChanges(); AcJournalDetail a = new AcJournalDetail(); maxacj = (from c in db.AcJournalDetails orderby c.AcJournalDetailID descending select c.AcJournalDetailID).FirstOrDefault(); a.AcJournalDetailID = maxacj + 1; a.AcJournalID = ajm.AcJournalID; a.AcHeadID = v.AcHeadID; a.Amount = v.Amount; a.BranchID = Convert.ToInt32(Session["AcCompanyID"].ToString()); a.Remarks = ""; db.AcJournalDetails.Add(a); db.SaveChanges(); var invid = 0; int?recpayid = 0; //if (v.TradingInvoice == false) //{ // int jobid = (from j in db.JobGenerations where j.JobCode == v.JobNO select j.JobID).FirstOrDefault(); // invid = (from c in db.JInvoices where c.JobID == jobid select c.InvoiceID).FirstOrDefault(); // var recpay = (from c in db.RecPayDetails where c.InvoiceID == invid select c).FirstOrDefault(); // if (recpay != null) // { // recpayid = recpay.RecPayID; // } //} //else //{ // invid =Convert.ToInt32(v.JobNO); // var recpay = (from c in db.RecPayDetails where c.InvoiceID == invid select c).FirstOrDefault(); // if(recpay != null) // { // recpayid = recpay.RecPayID; // } //} invid = Convert.ToInt32(v.JobNO); var ids = (from x in db.SalesInvoiceDetails where x.SalesInvoiceID == invid select(int?) x.SalesInvoiceDetailID).ToList(); recpayid = (from c in db.RecPayDetails where ids.Contains(c.InvoiceID) select c.RecPayID).FirstOrDefault().Value; CreditNote d = new CreditNote(); //int max = (from c in db.CreditNotes orderby c.CreditNoteNo descending select c.CreditNoteNo).FirstOrDefault().Value; int maxid = 0; var data = (from c in db.CreditNotes orderby c.CreditNoteID descending select c).FirstOrDefault(); if (data == null) { maxid = 1; } else { maxid = data.CreditNoteID + 1; } d.CreditNoteID = maxid; d.CreditNoteNo = maxid; d.InvoiceID = invid; d.CreditNoteDate = v.Date; d.Amount = v.Amount; d.AcJournalID = ajm.AcJournalID; d.FYearID = Convert.ToInt32(Session["fyearid"].ToString()); d.AcCompanyID = Convert.ToInt32(Session["AcCompanyID"].ToString()); d.RecPayID = recpayid; d.AcHeadID = v.AcHeadID; d.CustomerID = v.CustomerID; d.statusclose = false; d.InvoiceType = "C"; d.IsShipping = true; db.CreditNotes.Add(d); db.SaveChanges(); TempData["SuccessMsg"] = "Successfully Added Credit Note"; return(RedirectToAction("Index", "CreditNote")); }
public LargeJsonResult GetGridData(CustomerJournalVM cust) { AcJournalMaster objACJournalMaster = new AcJournalMaster(); objACJournalMaster.TransDate = DateTime.Now; objACJournalMaster.AcCompanyID = Convert.ToInt32(Session["AcCompanyID"]); objACJournalMaster.AcFinancialYearID =Convert.ToInt32( Session["fyearid"]); objACJournalMaster.AcJournalID = objectSourceModel.GetMaxNumberAcJournalMasters(); ; objACJournalMaster.VoucherNo = "12345"; objACJournalMaster.StatusDelete = false; objACJournalMaster.VoucherType = ""; objACJournalMaster.Remarks = cust.Remark; if (cust.CustomerHeadId > 0) { objACJournalMaster.TransType = 1; } if (cust.SupplierHeadId > 0) { objACJournalMaster.TransType = 2; } objACJournalMaster.VoucherNo = ""; entity.AcJournalMasters.Add(objACJournalMaster); entity.SaveChanges(); if (objACJournalMaster.AcJournalID > 0) { var achead = objectSourceModel.GetAcHeadAssign(); if (achead != null) { AcJournalDetail acJournalDetailsDR = new AcJournalDetail(); acJournalDetailsDR.Amount = Convert.ToDecimal(cust.amount); acJournalDetailsDR.Remarks = cust.Remark; acJournalDetailsDR.AcJournalID = objACJournalMaster.AcJournalID; acJournalDetailsDR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); if (cust.CustomerHeadId != 0) { acJournalDetailsDR.AcHeadID = achead.CustomerControlAcID; } else { acJournalDetailsDR.AcHeadID = achead.SupplierControlAcID; } entity.AcJournalDetails.Add(acJournalDetailsDR); entity.SaveChanges(); AcJournalDetail acJournalDetailsCR = new AcJournalDetail(); acJournalDetailsCR.Amount = (-1) * Convert.ToDecimal(cust.amount); acJournalDetailsCR.Remarks = cust.Remark; acJournalDetailsCR.AcJournalID = objACJournalMaster.AcJournalID; acJournalDetailsCR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails(); if (cust.CustomerHeadId != 0) { acJournalDetailsCR.AcHeadID = achead.CustomerControlAcID; } else { acJournalDetailsCR.AcHeadID = achead.SupplierControlAcID; } entity.AcJournalDetails.Add(acJournalDetailsCR); entity.SaveChanges(); } } return new LargeJsonResult { MaxJsonLength=Int32.MaxValue, Data = new { success = true, AcJournalID = objACJournalMaster.AcJournalID }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }