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 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();
}
