public ActionResult update(int BIA_No, string Road_Name, string Miles, int Type_Id)
{
tblRoad table = new tblRoad();
using (var db = new RoadsEntities())
{
table = db.tblRoads.First(em => em.BIA_No == BIA_No);
}
if (table != null)
{
table.Road_Name = Road_Name;
table.Type_Id = Type_Id;
table.Miles = Convert.ToDouble(Miles);
}
using (var dc = new RoadsEntities())
{
dc.Entry(table).State = EntityState.Modified;
dc.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index"));
}
public ActionResult EditingInline_Update([DataSourceRequest] DataSourceRequest request, TranViewModel tran)
{
RoadsEntities db = new RoadsEntities();
var t = db.tblTransactions.Where(tr => tr.AutoNumber.Equals(tran.AutoNumber)).FirstOrDefault();
t.Hours = tran.Hours;
t.Lease_Chg = tran.Lease_Chg;
db.SaveChanges();
return(Json(new[] { tran }.ToDataSourceResult(request, ModelState)));
}
// GET: Transaction
public ActionResult Index()
{
TranViewModel tvm;
RoadsEntities dbCxt = new RoadsEntities();
tvm = new TranViewModel();
tvm.Machs = dbCxt.tblMaches.ToList();
tvm.Acts = dbCxt.tblActs.ToList();
tvm.Emps = dbCxt.tblEmps.ToList();
tvm.Roads = dbCxt.tblRoads.ToList();
tvm.Transactions = dbCxt.tblTransactions.ToList();
return(View("LoadTransaction", tvm));
}
private static IEnumerable <TranViewModel> GetTransactions()
{
RoadsEntities dbCtx = new RoadsEntities();
return(dbCtx.tblTransactions.Select(tran => new TranViewModel
{
AutoNumber = tran.AutoNumber,
Emp_Name = tran.tblEmp.Emp_Name,
Mach_Desc = tran.tblMach.Mach_Desc,
Road_Name = tran.tblRoad.Road_Name,
Activity_Desc = tran.tblAct.Activity_Desc,
Hours = tran.Hours,
Lease_Rate = tran.Lease_Chg
}));
}
public ActionResult create(RoadViewModel tbl)
{
RoadsEntities db = new RoadsEntities();
tblRoad tb = new tblRoad();
tb.BIA_No = Convert.ToInt32(tbl.BIA_No);
tb.Road_Name = tbl.Road_Name;
tb.Miles = tbl.Miles;
tb.Type_Id = tbl.Type_Id;
db.tblRoads.Add(tb);
db.SaveChanges();
ModelState.Clear();
return(Index());
}
public string GetUserPassword(string loginName)
{
using (RoadsEntities db = new RoadsEntities())
{
var user = db.tblLogins.Where(o => o.UserID.Equals(loginName));
if (user.Any())
{
return(user.FirstOrDefault().Password);
}
else
{
return(string.Empty);
}
}
}
public static IEnumerable <TranViewModel> GetTransaction()
{
RoadsEntities entity = new RoadsEntities();
return(entity.tblTransactions.Select(tl => new TranViewModel
{
AutoNumber = tl.AutoNumber,
Emp_Name = tl.tblEmp.Emp_Name,
Mach_Desc = tl.tblMach.Mach_Desc,
Road_Name = tl.tblRoad.Road_Name,
Activity_Desc = tl.tblAct.Activity_Desc,
Trans_Date = tl.Trans_Date,
Hours = tl.Hours,
Lease_Chg = tl.Lease_Chg
}));
}
// GET: Roads
public ActionResult Index()
{
RoadsEntities db = new RoadsEntities();
RoadViewModel v = new RoadViewModel();
IEnumerable <SelectListItem> item = db.tblTypes.Select(t => new SelectListItem
{
Value = t.Type_Id.ToString(),
Text = t.Type_Desc,
});
ViewBag.Result = item;
ViewBag.DropdownResult = db.tblTypes.ToList();
v.Roads = db.tblRoads.ToList();
return(View("Roads", v));
}
public ActionResult Index()
{
RoadsEntities dbCxt = new RoadsEntities();
MachViewModel mvm = new MachViewModel();
mvm.Machs = dbCxt.tblMaches.ToList();
mvm.Owners = dbCxt.tblOwners.ToList();
IEnumerable <SelectListItem> item = dbCxt.tblOwners.Select(t => new SelectListItem
{
Value = t.Owner_Num.ToString(),
Text = t.Owner_Name,
});
ViewBag.mResult = item;
ViewBag.DropdownResult = new SelectList(dbCxt.tblOwners, "Owner_Num", "Owner_Name");
return(View("Machine", mvm));
}
public ActionResult AddTransaction(TranViewModel tvm)
{
using (RoadsEntities db = new RoadsEntities())
{
tblTransaction tt = new tblTransaction();
tt.Trans_Date = tvm.Trans_Date;
tt.Emp_No = tvm.Emp_no;
tt.Mach_No = tvm.Mach_No;
tt.BIA_No = tvm.BIA_No;
tt.Activity_Code = tvm.Activity_Code;
tt.Hours = tvm.Hours;
tt.Lease_Chg = tvm.Lease_Chg;
db.tblTransactions.Add(tt);
db.SaveChanges();
ModelState.Clear();
}
return(RedirectToAction("Index"));
}
public ActionResult AddMachine(tblMach mac)
{
RoadsEntities dbCxt = new RoadsEntities();
//if (dbCxt.tblMaches.Select(m => m.Mach_No == mac.Mach_No) != null)
//{
// ModelState.AddModelError("", "Cannot add duplicate Machine Code.");
//}
//else
//{
using (RoadsEntities db = new RoadsEntities())
{
db.tblMaches.Add(mac);
db.SaveChanges();
ModelState.Clear();
}
//}
return(RedirectToAction("Index"));
}
public ActionResult Update(int Mach_No, string Mach_Desc, double Lease_Rate, int Owner_Num, bool Active)
{
tblMach tblmach;
using (db = new RoadsEntities())
{
tblmach = db.tblMaches.First(m => m.Mach_No == Mach_No);
}
if (tblmach != null)
{
tblmach.Mach_Desc = Mach_Desc;
tblmach.Lease_Rate = Lease_Rate;
tblmach.Owner_Num = Owner_Num;
tblmach.Active = Active;
}
using (var dbCtx = new RoadsEntities())
{
dbCtx.Entry(tblmach).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index"));
}
