public ActionResult Delete(string Id)
{
int id = Convert.ToInt32(Id);
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Transportation objmodel = new DSRCManagementSystem.Models.Transportation();
//var value = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == id).Select(o => o.ManageExpenseId).FirstOrDefault();
//var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault();
//// var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault();
//objvalue.Isactive = false;
var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault();
// var type = objdb.Master_ExpenseType.Where(x => x.ExpenseType_Id == objvalue.ExpenseType).Select(o => o.ExpenseType).FirstOrDefault();
var values = objdb.ManageExpense_Mapping.Where(x => x.ManageExpenseId == objvalue.ManageExpenseId).Select(o => o).FirstOrDefault();
objdb.ManageExpense_Mapping.DeleteObject(values);
objvalue.Isactive = false;
objdb.SaveChanges();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddExpense(DSRCManagementSystem.Models.Transportation objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.ManageExpens objexp = new DSRCManagementSystem.ManageExpens();
DSRCManagementSystem.ManageExpense_Mapping objmap = new DSRCManagementSystem.ManageExpense_Mapping();
//var num =Convert.ToInt32(objmodel.VehicleNumber);
var vehicleid = objdb.Vehicles.Where(x => x.Vehicle_No == objmodel.VehicleNumber && x.IsActive == true).Select(o => o.VehicleId).FirstOrDefault();
var objalready = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == vehicleid).Select(o => o.ManageExpenseId).ToList();
if (objalready != null)
{
for (int i = 0; i < objalready.Count(); i++)
{
var value = Convert.ToInt32(objalready[i]);
int?already = objdb.ManageExpenses.Where(x => x.ManageExpenseId == value && x.Isactive == true).Select(o => o.ExpenseType).FirstOrDefault();
if (already == Convert.ToInt32(objmodel.ExpenseType))
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
}
objexp.Date = DateTime.Now;
objexp.Cost = objmodel.Cost;
objexp.ExpenseType = Convert.ToInt32(objmodel.ExpenseType);
objexp.Isactive = true;
objdb.AddToManageExpenses(objexp);
objdb.SaveChanges();
objmap.ManageExpenseId = objexp.ManageExpenseId;
objmap.VehicleId = vehicleid;
objdb.AddToManageExpense_Mapping(objmap);
objdb.SaveChanges();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditExpense(DSRCManagementSystem.Models.Transportation objmodel)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Transportation obj = new DSRCManagementSystem.Models.Transportation();
var vehicle_num = objmodel.VehicleNumber;
var dbvalue = objdb.Vehicles.Where(x => x.Vehicle_No == vehicle_num).Select(o => o.VehicleId).FirstOrDefault();
// var dbvalue = objdb.Vehicles.Where(x => x.Vehicle_No == vehicle_num).Select(o => o).FirstOrDefault();
var objmanageexpmap = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == dbvalue).Select(o => o.ManageExpenseId).FirstOrDefault();
if (objmodel.ExpenseId != null)
{
var manageid = objdb.ManageExpenses.Where(x => x.ManageExpenseId == objmanageexpmap && x.Isactive == true).Select(o => o).FirstOrDefault();
var listvalue = objdb.ManageExpense_Mapping.Where(x => x.VehicleId == dbvalue).Select(o => o.ManageExpenseId).ToList();
if (manageid.ExpenseType != Convert.ToInt32(objmodel.ExpenseType))
{
if (listvalue != null)
{
for (int k = 0; k < listvalue.Count(); k++)
{
var dbvalue1 = Convert.ToInt32(listvalue[k]);
var alreadyvale = objdb.ManageExpenses.Where(x => x.ManageExpenseId == dbvalue1 && x.Isactive == true).Select(o => o.ExpenseType).FirstOrDefault();
if (alreadyvale == Convert.ToInt32(objmodel.ExpenseType))
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
}
}
manageid.Date = objmodel.dateofyear;
manageid.Cost = objmodel.Cost;
manageid.ExpenseType = Convert.ToInt32(objmodel.ExpenseType);
objdb.SaveChanges();
}
else
{
DSRCManagementSystem.ManageExpens objexp = new DSRCManagementSystem.ManageExpens();
DSRCManagementSystem.ManageExpense_Mapping objmap = new DSRCManagementSystem.ManageExpense_Mapping();
objexp.Date = objmodel.dateofyear;
objexp.Cost = objmodel.Cost;
objexp.ExpenseType = Convert.ToInt32(objmodel.ExpenseType);
objexp.Isactive = true;
objdb.AddToManageExpenses(objexp);
objdb.SaveChanges();
objmap.ManageExpenseId = objexp.ManageExpenseId;
//objmap.VehicleId = Convert.ToInt32(dbvalue.VehicleId);
objmap.VehicleId = Convert.ToInt32(dbvalue);
objdb.AddToManageExpense_Mapping(objmap);
objdb.SaveChanges();
}
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditExpense(string Id, string vehicleno)
{
int id = 0;
int objvehicleno = 0;
if (Id != "" && Id != null)
{
id = Convert.ToInt32(Id);
}
else
{
id = 0;
}
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Transportation objmodel = new DSRCManagementSystem.Models.Transportation();
var vehicles = (from p in objdb.Vehicles.Where(x => x.IsActive == true || x.IsActive == null)
select new
{
VehicleId = p.VehicleId,
VehicleNo = p.Vehicle_No,
}).ToList();
var expense = (from p in objdb.Master_ExpenseType
select new
{
Id6 = p.ExpenseType_Id,
Expense = p.ExpenseType
}).ToList();
var num = objdb.ManageExpense_Mapping.Where(x => x.ManageExpenseId == id).Select(o => o.VehicleId).FirstOrDefault();
var objvalue = objdb.ManageExpenses.Where(x => x.ManageExpenseId == id && x.Isactive == true).Select(o => o).FirstOrDefault();
if (objvalue != null)
{
objmodel.Cost = objvalue.Cost;
}
else
{
objmodel.Cost = null;
}
if (objvalue != null)
{
if (objvalue.Date != null)
{
DateTime d1 = Convert.ToDateTime(objvalue.Date);
string d = d1.ToShortDateString();
objmodel.date = d;
objmodel.dateofyear = objvalue.Date;
}
else
{
DateTime d1 = Convert.ToDateTime(DateTime.Now.ToString());
string d = d1.ToShortDateString();
objmodel.date = d;
objmodel.dateofyear = objvalue.Date;
}
}
else
{
objmodel.date = null;
}
objmodel.ExpenseId = id;
if (num != null)
{
ViewBag.Vehicles = new SelectList(vehicles, "VehicleId", "VehicleNo", num);
}
else
{
if (vehicleno != "" && Id == "")
{
int vechi = Convert.ToInt32(vehicleno);
var objnum = objdb.Vehicles.Where(x => x.VehicleId == vechi).Select(o => o.VehicleId).FirstOrDefault();
ViewBag.Vehicles = new SelectList(vehicles, "VehicleId", "VehicleNo", objnum);
}
else
{
ViewBag.Vehicles = new SelectList(vehicles, "VehicleId", "VehicleNo");
}
}
int?expensetype = 0;
if (objvalue != null)
{
expensetype = objvalue.ExpenseType;
}
if (objvalue != null)
{
ViewBag.Expense = new SelectList(expense, "Id6", "Expense", expensetype);
}
else
{
ViewBag.Expense = new SelectList(expense, "Id6", "Expense");
}
return(View(objmodel));
}