//ajax
public decimal CountAmount(decimal?id)
{
if (id == null)
{
return(0);
}
long emp_id = Convert.ToInt64(Session["id"]);
//checking for configuration
HRMS_EMP_GRA_POL obj1 = db.HRMS_EMP_GRA_POL.Where(x => x.Emp_ID == emp_id).FirstOrDefault();
decimal val = db.HRMS_TRAVEL_MILEAGE_CONFIG.Where(x => x.Travel_Mileage_Emp_Grade.StartsWith(obj1.Gra_ID.ToString()) && x.Travel_Group == obj1.Pol_ID).Select(x => x.Travel_Mileage_Four).FirstOrDefault();
decimal Amount = val * id.Value;
return(Amount);
}
public ActionResult AddExpense(HRMS_Travel_Expense_App obj, HttpPostedFileBase files)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
obj.EMP_ID = emp_id;
//checking for configuration
HRMS_EMP_GRA_POL obj1 = db.HRMS_EMP_GRA_POL.Where(x => x.Emp_ID == obj.EMP_ID).FirstOrDefault();
decimal val = db.HRMS_TRAVEL_MILEAGE_CONFIG.Where(x => x.Travel_Mileage_Emp_Grade.StartsWith(obj1.Gra_ID.ToString()) && x.Travel_Group == obj1.Pol_ID).Select(x => x.Travel_Mileage_Four).FirstOrDefault();
if (obj.Amount > (obj.Distance * val))
{
obj.Warning = 1;
}
obj.Status = 0;
//file
if (files != null)
{
var Extension = Path.GetExtension(files.FileName);
var fileName = obj.Travel_App_ID + "_" + obj.From_Place + obj.To_Place + Extension;
string path = Path.Combine(Server.MapPath("~/ExpenseAttach"), fileName);
obj.FileUrl = Url.Content(Path.Combine("~/ExpenseAttach/", fileName));
obj.FileName = fileName;
files.SaveAs(path);
}
db.HRMS_Travel_Expense_App.Add(obj);
db.SaveChanges();
return(RedirectToAction("AddExpense", new { id = obj.Travel_App_ID }));
}
