public JsonResult Create(string para01, string para02, string para03) { string employee_id = para01; string expense_id = para02; string date = para03; SALARY newSalary = new SALARY(); newSalary.EXPENSE_ID = expense_id; newSalary.EMPLOYEE_ID = employee_id; newSalary.SALARY_DATE = Convert.ToDateTime(date); EMPLOYEE myEmployee = db.EMPLOYEE.Find(employee_id); EXPENSE myExpense = db.EXPENSE.Find(expense_id); myExpense.MONEY = myExpense.MONEY + myEmployee.SALARY; db.Entry(myExpense).State = EntityState.Modified; db.SALARY.Add(newSalary); db.SaveChanges(); var list = db.SALARY.Include(s => s.EMPLOYEE).Include(s => s.EXPENSE).Select(n => new { EMPLOYEE_ID = n.EMPLOYEE_ID, EMPLOYEE_NAME = n.EMPLOYEE.EMPLOYEE_NAME, SALARY_DATE = n.SALARY_DATE, SALARY = n.EMPLOYEE.SALARY, EXPENSE_ID = n.EXPENSE_ID }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public string test(string para01, string para02, string para03) { string stock_id = para01; string plan_id = para02; string expense_id = para03; STOCK sTOCK = db.STOCK.Find(stock_id); if (sTOCK != null) { return("1"); } EXPENSE eXPENSE = db.EXPENSE.Find(expense_id); if (eXPENSE == null) { return("2"); } PLAN pLAN = db.PLAN.Find(plan_id); if (pLAN == null) { return("3"); } return("4"); }
public string test(string para01, string para02, string para03) { string employee_id = para01; string expense_id = para02; SALARY mySalary = db.SALARY.Find(expense_id, employee_id); if (mySalary != null) { return("1"); } EXPENSE myExpense = db.EXPENSE.Find(expense_id); if (myExpense == null) { return("2"); } EMPLOYEE myEmployee = db.EMPLOYEE.Find(employee_id); if (myEmployee == null) { return("3"); } return("4"); }
public EXPENSE_Model(EXPENSE e) { expense_code_ID = e.expense_code_ID; expense_user_FK = e.expense_user_FK; expense_guide_FK = e.expense_guide_FK; expense_date = e.expense_date; expense_size = e.expense_size; }
public ExpenseSelect(EXPENSE expense) { id = expense.id; expense_date = expense.expense_date; expense_size = expense.expense_size; expense_type = expense.EXPENSE_GUIDE.expense_type; expense_guide_Fk = expense.expense_guide_FK; }
public ActionResult DeleteConfirmed(string id) { EXPENSE eXPENSE = db.EXPENSE.Find(id); db.EXPENSE.Remove(eXPENSE); db.SaveChanges(); return(RedirectToAction("Index")); }
public void DeleteEXPENSE(int id) { EXPENSE i = db.EXPENSE.Find(id); if (i != null) { db.EXPENSE.Remove(i); Save(); } }
public void UpdateEXPENSE(ExpenseModel exp) { EXPENSE e = db.EXPENSE.Find(exp.expense_code_ID); e.id = exp.expense_code_ID; e.expense_guide_FK = (int)exp.expense_guide_FK; e.expense_size = (decimal)exp.expense_size; e.expense_date = (DateTime)exp.expense_date; Save(); }
public ActionResult Edit([Bind(Include = "EXPENSE_ID,EXPENSE_DATE,MONEY,TYPE")] EXPENSE eXPENSE) { if (ModelState.IsValid) { db.Entry(eXPENSE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(eXPENSE)); }
public ActionResult Create([Bind(Include = "EXPENSE_ID,EXPENSE_DATE,MONEY,TYPE")] EXPENSE eXPENSE) { if (ModelState.IsValid) { db.EXPENSE.Add(eXPENSE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(eXPENSE)); }
public ActionResult DeleteInvoice(int Id, int ExpenseDetailId, int vat, float total) { try { HttpResponseMessage response = GlobalVeriables.WebApiClient.GetAsync("GetExpenseById/" + Id).Result; ExpenseViewModel ExpenseMosel = response.Content.ReadAsAsync <ExpenseViewModel>().Result; double ResultVAT = CommonController.CalculateVat(vat, total); ExpenseMosel.GRAND_TOTAL = Convert.ToDouble(ExpenseMosel.GRAND_TOTAL) - Convert.ToDouble(ResultVAT); ExpenseMosel.GRAND_TOTAL = Convert.ToDouble(ExpenseMosel.GRAND_TOTAL) - Convert.ToDouble(total); ExpenseMosel.VAT_AMOUNT = ExpenseMosel.VAT_AMOUNT - Convert.ToDouble(vat); ExpenseMosel.SUBTOTAL = ExpenseMosel.SUBTOTAL - Convert.ToDouble(total); if (vat == 6) { ExpenseMosel.Vat6 = (ExpenseMosel.Vat6) - Convert.ToDouble(ResultVAT); } if (vat == 21) { ExpenseMosel.Vat21 = (ExpenseMosel.Vat21) - Convert.ToDouble(ResultVAT); } response = GlobalVeriables.WebApiClient.PutAsJsonAsync("PutExpense/" + ExpenseMosel.Id, ExpenseMosel).Result; EXPENSE exp = response.Content.ReadAsAsync <EXPENSE>().Result; if (response.StatusCode == System.Net.HttpStatusCode.OK) { HttpResponseMessage deleteExpenseDetail = GlobalVeriables.WebApiClient.DeleteAsync("DeleteExpenseDetails/" + ExpenseDetailId).Result; if (deleteExpenseDetail.StatusCode == System.Net.HttpStatusCode.OK) { return(new JsonResult { Data = new { Status = "Success" } }); } } return(new JsonResult { Data = new { Status = "Fail" } }); } catch (Exception ex) { return(new JsonResult { Data = new { Status = "Fail" } }); } }
// GET: EXPENSEs/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EXPENSE eXPENSE = db.EXPENSE.Find(id); if (eXPENSE == null) { return(HttpNotFound()); } return(View(eXPENSE)); }
public ActionResult AddExpence(ExpenseViewModel ExpenseViewModel, HttpPostedFileWrapper[] file23) { HttpResponseMessage response = new HttpResponseMessage(); int ExpenseId = 0; EXPENSE expense = new EXPENSE(); try { if (Session["LoginUserID"] != null) { ExpenseViewModel.user_id = Convert.ToInt32(Session["LoginUserID"]); } response = GlobalVeriables.WebApiClient.PostAsJsonAsync("PostExpense", ExpenseViewModel).Result; ExpenseModel Purchasetable = response.Content.ReadAsAsync <ExpenseModel>().Result; ExpenseId = Purchasetable.Id; if (response.StatusCode == System.Net.HttpStatusCode.OK) { if (file23[0] != null) { CreatDirectoryClass.UploadFileToDirectoryCommon(ExpenseViewModel.Id, "Expense", file23, "Expense"); } } } catch (Exception ex) { return(new JsonResult { Data = new { Status = "Fail", Message = ex.Message.ToString() } }); } return(new JsonResult { Data = new { Status = "Success", Id = ExpenseId } }); }
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; //} }