public IHttpActionResult PutAccountTransictionTable(int id, AccountTransictionTable accountTransictionTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != accountTransictionTable.TransictionId) { return(BadRequest()); } db.Entry(accountTransictionTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AccountTransictionTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public bool AddTransaction(MVCQutationModel quatationModel) { bool result = false; try { TransactionModel model = new TransactionModel(); model.CompanyId = (int)quatationModel.CompanyId; model.AccountTitle = "Accounts receivable"; int AccountId = CommonController.GetAcccountId(model); if (AccountId > 0) { AccountTransictionTable _TransactionTable = new AccountTransictionTable(); _TransactionTable.FK_AccountID = AccountId; _TransactionTable.Dr = quatationModel.SubTotal; _TransactionTable.Cr = 0; _TransactionTable.TransictionNumber = Guid.NewGuid().ToString(); _TransactionTable.TransictionRefrenceId = quatationModel.QutationID.ToString(); _TransactionTable.CreationTime = DateTime.Now.TimeOfDay; _TransactionTable.AddedBy = Convert.ToInt32(Session["LoginUserID"]); _TransactionTable.FK_CompanyId = quatationModel.CompanyId; _TransactionTable.TransictionType = "Dr"; _TransactionTable.FKPaymentTerm = null; _TransactionTable.TransictionDate = DateTime.Now; _TransactionTable.Description = "invoice Creating Time Transaction"; if (TransactionClass.PerformTransaction(_TransactionTable)) { result = true; model.AccountTitle = "Input VAT"; int AccountId1 = CommonController.GetAcccountId(model); _TransactionTable.FK_AccountID = AccountId1; _TransactionTable.Dr = quatationModel.TotalVat21 + quatationModel.TotalVat6; if (TransactionClass.PerformTransaction(_TransactionTable)) { result = true; model.AccountTitle = "Cash on hand"; int AccountId12 = CommonController.GetAcccountId(model); _TransactionTable.FK_AccountID = AccountId12; _TransactionTable.Cr = quatationModel.TotalAmount; _TransactionTable.Dr = 0; _TransactionTable.TransictionType = "Cr"; if (TransactionClass.PerformTransaction(_TransactionTable)) { result = true; } } } } } catch (Exception) { throw; } return(result); }
public IHttpActionResult GetAccountTransictionTable(int id) { AccountTransictionTable accountTransictionTable = db.AccountTransictionTables.Find(id); if (accountTransictionTable == null) { return(NotFound()); } return(Ok(accountTransictionTable)); }
public IHttpActionResult DeleteAccountTransictionTable(int id) { AccountTransictionTable accountTransictionTable = db.AccountTransictionTables.Find(id); if (accountTransictionTable == null) { return(NotFound()); } db.AccountTransictionTables.Remove(accountTransictionTable); db.SaveChanges(); return(Ok(accountTransictionTable)); }
public IHttpActionResult PostAccountTransictionTable(AccountTransictionTable accountTransictionTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.AccountTransictionTables.Add(accountTransictionTable); db.SaveChanges(); } catch (Exception ex) { var exx = ex.ToString(); } return(Ok(accountTransictionTable)); }
public IHttpActionResult PutExpense(int id, ExpenseViewModel ExpenseViewModel) { string refId = ExpenseViewModel.Id.ToString(); EXPENSE expenseTable = new EXPENSE(); ExpenseModel _ExpeseModel = new ExpenseModel(); AccountTransictionTable AccountTable = new AccountTransictionTable(); AccountTable.TransictionDate = DateTime.Now; AccountTable.TransictionNumber = base64Guid; AccountTable.TransictionType = "Expence"; AccountTable.CreationTime = DateTime.Now.TimeOfDay; AccountTable.FK_CompanyId = ExpenseViewModel.comapny_id; AccountTable.FKPaymentTerm = 1; AccountTable.TransictionRefrenceId = ExpenseViewModel.Id.ToString(); AccountTable.AddedBy = ExpenseViewModel.user_id; using (DBEntities context = new DBEntities()) { using (DbContextTransaction transaction = context.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { List <AccountTransictionTable> List = new List <AccountTransictionTable>(); List = context.AccountTransictionTables.Where(t => t.TransictionRefrenceId == refId.ToString()).ToList(); context.AccountTransictionTables.RemoveRange(context.AccountTransictionTables.Where(F => F.TransictionRefrenceId == refId.ToString())); context.SaveChanges(); EXPENSE expense = new EXPENSE(); expense.REFERENCEno = ExpenseViewModel.REFERENCEno; expense.ACCOUNT_ID = ExpenseViewModel.ACCOUNT_ID; expense.Id = ExpenseViewModel.Id; expense.VENDOR_ID = ExpenseViewModel.VENDOR_ID; expense.notes = ExpenseViewModel.notes; expense.user_id = ExpenseViewModel.user_id; expense.SUBTOTAL = ExpenseViewModel.SUBTOTAL; expense.VAT_AMOUNT = ExpenseViewModel.VAT_AMOUNT; expense.GRAND_TOTAL = ExpenseViewModel.GRAND_TOTAL; expense.AddedDate = ExpenseViewModel.AddedDate; expense.comapny_id = ExpenseViewModel.comapny_id; expense.Vat6 = ExpenseViewModel.Vat6; expense.Vat21 = ExpenseViewModel.Vat21; context.Entry(expense).State = EntityState.Modified; context.SaveChanges(); if (ExpenseViewModel.ExpensenDetailList != null) { foreach (ExpenseDetail item in ExpenseViewModel.ExpensenDetailList) { ExpenseDetail expenseDetailModel = new ExpenseDetail(); expenseDetailModel.expense_id = ExpenseViewModel.Id; expenseDetailModel.EXPENSE_ACCOUNT_ID = item.EXPENSE_ACCOUNT_ID; expenseDetailModel.DESCRIPTION = item.DESCRIPTION; expenseDetailModel.AMOUNT = item.AMOUNT; expenseDetailModel.TAX_PERCENT = item.TAX_PERCENT; expenseDetailModel.TAX_AMOUNT = item.TAX_AMOUNT; expenseDetailModel.SUBTOTAL = item.SUBTOTAL; expenseDetailModel.Id = item.Id; expenseDetailModel.user_id = ExpenseViewModel.user_id; expenseDetailModel.comapny_id = ExpenseViewModel.comapny_id; AccountTable.Cr = 0.00; AccountTable.Dr = item.AMOUNT; AccountTable.FK_AccountID = item.EXPENSE_ACCOUNT_ID; context.AccountTransictionTables.Add(AccountTable); context.SaveChanges(); if (item.Id == 0) { context.ExpenseDetails.Add(expenseDetailModel); context.SaveChanges(); } else { context.Entry(expenseDetailModel).State = EntityState.Modified; context.SaveChanges(); } } } //Accounts Petty Cash Transaction int Accountpayble = AccountIdByName("Petty Cash", (int)ExpenseViewModel.comapny_id); if (Accountpayble != 0) { AccountTable.Dr = 0.00; AccountTable.Cr = ExpenseViewModel.GRAND_TOTAL; AccountTable.FK_AccountID = Accountpayble; context.AccountTransictionTables.Add(AccountTable); context.SaveChanges(); } // Cost Of Goods Transaction int CostOfGood = AccountIdByName("Input VAT", (int)ExpenseViewModel.comapny_id); if (CostOfGood != 0) { AccountTable.Cr = 0.00; AccountTable.Dr = ExpenseViewModel.Vat21 + ExpenseViewModel.Vat6;; AccountTable.FK_AccountID = CostOfGood; context.AccountTransictionTables.Add(AccountTable); context.SaveChanges(); } _ExpeseModel.Id = expenseTable.Id; transaction.Commit(); return(Ok(_ExpeseModel)); } catch (Exception ex) { transaction.Commit(); return(BadRequest()); } } } //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} //if (id != ExpenseTable.Id) //{ // return BadRequest(); //} //db.Entry(ExpenseTable).State = EntityState.Modified; //try //{ // db.SaveChanges(); // return Ok(ExpenseTable); //} //catch (Exception ex) //{ // BadRequest(); // throw; //} }
public IHttpActionResult PostInvoice([FromBody] InvoiceViewModel invoiceViewModel) { InvoiceTable Table = new InvoiceTable(); using (DBEntities context = new DBEntities()) { using (DbContextTransaction transaction = context.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { Table.Invoice_ID = invoiceViewModel.Invoice_ID; Table.CompanyId = invoiceViewModel.CompanyId; Table.UserId = invoiceViewModel.UserId; Table.ContactId = invoiceViewModel.ContactId; Table.RefNumber = invoiceViewModel.RefNumber; Table.InvoiceDate = invoiceViewModel.InvoiceDate; Table.InvoiceDueDate = invoiceViewModel.InvoiceDueDate; Table.SubTotal = invoiceViewModel.SubTotal; Table.DiscountAmount = invoiceViewModel.DiscountAmount; Table.TotalAmount = invoiceViewModel.TotalAmount; Table.CustomerNote = invoiceViewModel.CustomerNote; Table.TotalVat21 = invoiceViewModel.TotalVat21; Table.TotalVat6 = invoiceViewModel.TotalVat6; Table.Type = StatusEnum.Goods.ToString(); Table.Status = "accepted"; Table.InvoiceDescription = invoiceViewModel.InvoiceDescription; if (Table.TotalVat6 != null) { double vat61 = Math.Round((double)Table.TotalVat6, 2, MidpointRounding.AwayFromZero); Table.TotalVat6 = vat61; } if (Table.TotalVat21 != null) { double vat21 = Math.Round((double)Table.TotalVat21, 2, MidpointRounding.AwayFromZero); Table.TotalVat21 = vat21; } Table = context.InvoiceTables.Add(Table); context.SaveChanges(); if (invoiceViewModel.InvoiceDetailsTable != null) { foreach (InvoiceDetailsTable InvoiceDetailsList in invoiceViewModel.InvoiceDetailsTable) { InvoiceDetailsTable InvoiceDetails = new InvoiceDetailsTable(); InvoiceDetails.ItemId = Convert.ToInt32(InvoiceDetailsList.ItemId); InvoiceDetails.InvoiceId = Table.InvoiceID; InvoiceDetails.Description = InvoiceDetailsList.Description; InvoiceDetails.Quantity = InvoiceDetailsList.Quantity; InvoiceDetails.Rate = Convert.ToDouble(InvoiceDetailsList.Rate); InvoiceDetails.Total = Convert.ToDouble(InvoiceDetailsList.Total); InvoiceDetails.ServiceDate = InvoiceDetailsList.ServiceDate; InvoiceDetails.RowSubTotal = InvoiceDetailsList.RowSubTotal; InvoiceDetails.Vat = Convert.ToDouble(InvoiceDetailsList.Vat); InvoiceDetails.Type = InvoiceDetailsList.Type; if (InvoiceDetails.InvoiceDetailId == 0) { InvoiceDetails = context.InvoiceDetailsTables.Add(InvoiceDetails); context.SaveChanges(); } } } AccountTransictionTable Account = new AccountTransictionTable(); Account.TransictionDate = DateTime.Now; Account.TransictionNumber = base64Guid; Account.TransictionType = "Invoice"; Account.TransictionRefrenceId = Table.InvoiceID.ToString(); Account.CreationTime = DateTime.Now.TimeOfDay; Account.AddedBy = 1; Account.FK_CompanyId = invoiceViewModel.CompanyId; Account.FKPaymentTerm = 1; //Cash Account Transaction int CashtAccountId = AccountIdByName("Cash on hand", (int)invoiceViewModel.CompanyId); if (CashtAccountId != 0) { Account.Dr = invoiceViewModel.TotalAmount; Account.Cr = 0.00; Account.FK_AccountID = CashtAccountId; context.AccountTransictionTables.Add(Account); context.SaveChanges(); } // Sale Account Transaction int SaleAccount = AccountIdByName("Seles", (int)invoiceViewModel.CompanyId); if (SaleAccount != 0) { Account.Cr = invoiceViewModel.SubTotal; Account.Dr = 0.00; Account.FK_AccountID = SaleAccount; context.AccountTransictionTables.Add(Account); context.SaveChanges(); } // vat Out Put Trnsaction int VatAccountId = AccountIdByName("VAT Payable", (int)invoiceViewModel.CompanyId); if (VatAccountId != 0) { Account.Cr = invoiceViewModel.TotalVat6 + invoiceViewModel.TotalVat21; Account.Dr = 0.00; Account.FK_AccountID = VatAccountId; context.AccountTransictionTables.Add(Account); int Id = context.SaveChanges(); } InvoiceModel inc = new InvoiceModel(); inc.InvoiceID = Table.InvoiceID; transaction.Commit(); return(Ok(inc)); } catch (Exception) { transaction.Rollback(); return(BadRequest()); } } } }
public IHttpActionResult PostPurchase([FromBody] MvcPurchaseViewModel PurchaseViewModel) { using (DBEntities entities = new DBEntities()) { using (DbContextTransaction transaction = entities.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { PurchaseOrderTable _PTable = new PurchaseOrderTable(); _PTable.CompanyId = PurchaseViewModel.CompanyId; _PTable.UserId = PurchaseViewModel.UserId; _PTable.PurchaseID = PurchaseViewModel.PurchaseId.ToString(); _PTable.VenderId = PurchaseViewModel.VenderId; _PTable.PurchaseRefNumber = PurchaseViewModel.PurchaseRefNumber; _PTable.PurchaseDate = Convert.ToDateTime(PurchaseViewModel.PurchaseDate); _PTable.PurchaseDueDate = PurchaseViewModel.PurchaseDueDate; _PTable.PurchaseSubTotal = PurchaseViewModel.PurchaseSubTotal; _PTable.PurchaseDiscountAmount = PurchaseViewModel.PurchaseDiscountAmount; _PTable.PurchaseTotoalAmount = PurchaseViewModel.PurchaseTotoalAmount; _PTable.PurchaseVenderNote = PurchaseViewModel.PurchaseVenderNote; _PTable.Vat6 = PurchaseViewModel.Vat6; _PTable.Vat21 = PurchaseViewModel.Vat21; _PTable.Status = "open"; _PTable.Type = StatusEnum.Goods.ToString(); _PTable = entities.PurchaseOrderTables.Add(_PTable); entities.SaveChanges(); if (PurchaseViewModel.PurchaseOrderList != null) { foreach (PurchaseOrderDetailsTable item in PurchaseViewModel.PurchaseOrderList) { PurchaseOrderDetailsTable purchadeDetail = new PurchaseOrderDetailsTable(); purchadeDetail.PurchaseOrderDetailsId = item.PurchaseOrderDetailsId; purchadeDetail.PurchaseItemId = item.PurchaseItemId; purchadeDetail.PurchaseDescription = item.PurchaseDescription; purchadeDetail.PurchaseQuantity = item.PurchaseQuantity; purchadeDetail.PurchaseItemRate = item.PurchaseItemRate; purchadeDetail.PurchaseTotal = item.PurchaseTotal; purchadeDetail.Type = item.Type; purchadeDetail.RowSubTotal = item.RowSubTotal; purchadeDetail.PurchaseVatPercentage = item.PurchaseVatPercentage; purchadeDetail.PurchaseId = _PTable.PurchaseOrderID; purchadeDetail.ServiceDate = item.ServiceDate; entities.PurchaseOrderDetailsTables.Add(purchadeDetail); entities.SaveChanges(); } } AccountTransictionTable Account = new AccountTransictionTable(); Account.TransictionDate = DateTime.Now; Account.TransictionNumber = base64Guid; Account.TransictionType = "Purchase"; Account.CreationTime = DateTime.Now.TimeOfDay; Account.AddedBy = 1; Account.FK_CompanyId = PurchaseViewModel.CompanyId; Account.FKPaymentTerm = 1; Account.TransictionRefrenceId = _PTable.PurchaseOrderID.ToString(); //Accounts payable Transaction int Accountpayble = AccountIdByName("Accounts payable", (int)PurchaseViewModel.CompanyId); if (Accountpayble != 0) { Account.Dr = 0.00; Account.Cr = PurchaseViewModel.PurchaseTotoalAmount; Account.FK_AccountID = Accountpayble; entities.AccountTransictionTables.Add(Account); entities.SaveChanges(); } // Cost Of Goods Transaction int CostOfGood = AccountIdByName("Cost Of Goods", (int)PurchaseViewModel.CompanyId); if (CostOfGood != 0) { Account.Cr = 0.00; Account.Dr = PurchaseViewModel.PurchaseSubTotal; Account.FK_AccountID = CostOfGood; entities.AccountTransictionTables.Add(Account); entities.SaveChanges(); } // Input VAT Trnsaction int VatAccountId = AccountIdByName("Input VAT", (int)PurchaseViewModel.CompanyId); if (VatAccountId != 0) { Account.Cr = 0.00; Account.Dr = PurchaseViewModel.Vat21 + PurchaseViewModel.Vat6; Account.FK_AccountID = VatAccountId; entities.AccountTransictionTables.Add(Account); int Id = entities.SaveChanges(); } MvcPurchaseModel pModel = new MvcPurchaseModel(); pModel.PurchaseOrderID = _PTable.PurchaseOrderID; transaction.Commit(); return(Ok(pModel)); } catch (Exception) { transaction.Rollback(); return(BadRequest()); } } } }
public IHttpActionResult PutPurchaseTable(int id, MvcPurchaseViewModel PViewModel) { string Ref = PViewModel.PurchaseOrderID.ToString(); //accountTransictionTable.CreationTime = null; PurchaseOrderTable PTable = new PurchaseOrderTable(); using (DBEntities _dbcotext = new DBEntities()) { using (DbContextTransaction transaction = _dbcotext.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { PTable.PurchaseID = PViewModel.PurchaseId.ToString(); PTable.PurchaseOrderID = Convert.ToInt32(PViewModel.PurchaseOrderID); PTable.PurchaseRefNumber = PViewModel.PurchaseRefNumber; PTable.CompanyId = PViewModel.CompanyId; PTable.VenderId = PViewModel.VenderId; PTable.UserId = PViewModel.UserId; PTable.PurchaseDate = PViewModel.PurchaseDate; PTable.PurchaseDueDate = PViewModel.PurchaseDueDate; PTable.PurchaseSubTotal = PViewModel.PurchaseSubTotal; PTable.PurchaseDiscountAmount = PViewModel.PurchaseDiscountAmount; PTable.PurchaseTotoalAmount = PViewModel.PurchaseTotoalAmount; PTable.PurchaseVenderNote = PViewModel.PurchaseVenderNote; PTable.Vat6 = PViewModel.Vat6; PTable.Vat21 = PViewModel.Vat21; PTable.Status = "open"; PTable.Type = StatusEnum.Goods.ToString(); _dbcotext.Entry(PTable).State = EntityState.Modified; _dbcotext.SaveChanges(); if (PViewModel.PurchaseOrderList != null) { foreach (PurchaseOrderDetailsTable item in PViewModel.PurchaseOrderList) { PurchaseOrderDetailsTable DTable = new PurchaseOrderDetailsTable(); DTable.PurchaseOrderDetailsId = item.PurchaseOrderDetailsId; DTable.PurchaseItemId = item.PurchaseItemId; DTable.PurchaseDescription = item.PurchaseDescription; DTable.PurchaseQuantity = item.PurchaseQuantity; DTable.PurchaseItemRate = item.PurchaseItemRate; DTable.Type = item.Type; DTable.RowSubTotal = item.RowSubTotal; DTable.PurchaseDescription = item.PurchaseDescription; PTable.VenderId = PViewModel.VenderId; DTable.ServiceDate = item.ServiceDate; PTable.CompanyId = PViewModel.CompanyId; DTable.PurchaseTotal = item.PurchaseTotal; DTable.PurchaseVatPercentage = item.PurchaseVatPercentage; DTable.PurchaseId = PViewModel.PurchaseOrderID; if (DTable.PurchaseOrderDetailsId == 0) { _dbcotext.PurchaseOrderDetailsTables.Add(DTable); _dbcotext.SaveChanges(); } else { _dbcotext.Entry(DTable).State = EntityState.Modified; _dbcotext.SaveChanges(); } } AccountTransictionTable Account = new AccountTransictionTable(); Account.TransictionDate = DateTime.Now; Account.TransictionNumber = base64Guid; Account.TransictionType = "Purchase"; Account.CreationTime = DateTime.Now.TimeOfDay; Account.AddedBy = PViewModel.UserId; Account.FK_CompanyId = PViewModel.CompanyId; Account.FKPaymentTerm = 1; Account.TransictionRefrenceId = PTable.PurchaseOrderID.ToString(); //Accounts payable Transaction List <AccountTransictionTable> List = new List <AccountTransictionTable>(); List = _dbcotext.AccountTransictionTables.Where(t => t.TransictionRefrenceId == Ref.ToString()).ToList(); _dbcotext.AccountTransictionTables.RemoveRange(_dbcotext.AccountTransictionTables.Where(F => F.TransictionRefrenceId == Ref.ToString())); _dbcotext.SaveChanges(); int Accountpayble = AccountIdByName("Accounts payable", (int)PViewModel.CompanyId); if (Accountpayble != 0) { Account.Dr = 0.00; Account.Cr = PViewModel.PurchaseTotoalAmount; Account.FK_AccountID = Accountpayble; _dbcotext.AccountTransictionTables.Add(Account); _dbcotext.SaveChanges(); } // Cost Of Goods Transaction int CostOfGood = AccountIdByName("Cost Of Goods", (int)PViewModel.CompanyId); if (CostOfGood != 0) { Account.Cr = 0.00; Account.Dr = PViewModel.PurchaseSubTotal; Account.FK_AccountID = CostOfGood; _dbcotext.AccountTransictionTables.Add(Account); _dbcotext.SaveChanges(); } // Input VAT Trnsaction int VatAccountId = AccountIdByName("Input VAT", (int)PViewModel.CompanyId); if (VatAccountId != 0) { Account.Cr = 0.00; Account.Dr = PViewModel.Vat21 + PViewModel.Vat6; Account.FK_AccountID = VatAccountId; _dbcotext.AccountTransictionTables.Add(Account); int Id = _dbcotext.SaveChanges(); } transaction.Commit(); return(Ok()); } } catch (Exception) { transaction.Rollback(); return(BadRequest()); } return(BadRequest()); } } /////db.Entry(PurchaseTable).State = EntityState.Modified; //db.SaveChanges(); // return Ok(PurchaseTable); }