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;
//}
}
