// GET: EqpmtTypeMgmt
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_eqpmt_type_mgmt> eqpmtTypeMgmt = entities.tbl_eqpmt_type_mgmt.ToList();
return(View(eqpmtTypeMgmt.ToList()));
}
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_event_type> eventType = entities.tbl_event_type.ToList();
return(View(eventType.ToList()));
}
// GET: KitMgmt
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_kit> kitMgmt = entities.tbl_kit.ToList();
return(View(kitMgmt.ToList()));
}
// GET: CustomerMgmt
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_customer> custMgmt = entities.tbl_customer.ToList();
return(View(custMgmt.ToList()));
}
// GET: EqpmtMgmt
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_eqpmt_type> eqpmtMgmt = entities.tbl_eqpmt_type.ToList();
ViewBag.eqpmtType = new SelectList(db.tbl_eqpmt_type_mgmt.OrderBy(x => x.eqpmtType), "eqpmtType", "eqpmtType");
return(View(eqpmtMgmt.ToList()));
}
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_eqpmt_kits_avlbl> kitAvlbl = entities.tbl_eqpmt_kits_avlbl.ToList();
ViewBag.eqpmtType = new SelectList(db.tbl_eqpmt_type_mgmt.OrderBy(x => x.eqpmtType), "eqpmtType", "eqpmtType");
ViewBag.kitID = new SelectList(db.tbl_kit.OrderBy(x => x.kitID), "kitID", "kitID");
return(View(kitAvlbl.ToList()));
}
// GET: CustomerEvent
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_customer_event> custEvent = entities.tbl_customer_event.ToList();
ViewBag.customerCode = new SelectList(db.tbl_customer, "customerCode", "customerCode");
ViewBag.eventID = new SelectList(db.tbl_event_type, "eventID", "eventID");
return(View(custEvent.ToList()));
}
// GET: CurrentEqpmtKits
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_eqpmt_kits_current> eqpmtKitsCurrent = entities.tbl_eqpmt_kits_current.ToList();
ViewBag.kitID = new SelectList(db.tbl_kit, "kitID", "kitID");
return(View(eqpmtKitsCurrent.ToList()));
}
// GET: CustomerEvent
public ActionResult Index()
{
allpax_sale_minerEntities entities = new allpax_sale_minerEntities();
List <tbl_customer_eqpmt> custEqpmt = entities.tbl_customer_eqpmt.ToList();
ViewBag.customerCode = new SelectList(db.tbl_customer, "customerCode", "customerCode");
ViewBag.eqpmtType = new SelectList(db.tbl_eqpmt_type_mgmt, "eqpmtType", "eqpmtType");
return(View(custEqpmt.ToList()));
}
public ActionResult AddAvlblKit(tbl_eqpmt_kits_avlbl avlblKitAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_eqpmt_kits_avlbl.Add(new tbl_eqpmt_kits_avlbl()
{
eqpmtType = avlblKitAdd.eqpmtType,
kitID = avlblKitAdd.kitID
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult AddEvent(tbl_event_type eventAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_event_type.Add(new tbl_event_type()
{
eventID = eventAdd.eventID,
eventType = eventAdd.eventType
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateEqpmtType(tbl_eqpmt_type_mgmt eqpmtTypeUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_eqpmt_type_mgmt UpdatedEqpmtType = (from c in entities.tbl_eqpmt_type_mgmt
where c.id == eqpmtTypeUpdate.id
select c).FirstOrDefault();
UpdatedEqpmtType.eqpmtType = eqpmtTypeUpdate.eqpmtType;
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateAvlblKit(tbl_eqpmt_kits_avlbl avlblKitUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_eqpmt_kits_avlbl updatedAvlblKit = (from c in entities.tbl_eqpmt_kits_avlbl
where c.id == avlblKitUpdate.id
select c).FirstOrDefault();
updatedAvlblKit.eqpmtType = avlblKitUpdate.eqpmtType;
updatedAvlblKit.kitID = avlblKitUpdate.kitID;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateEqpmt(tbl_eqpmt_type eqpmtUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_eqpmt_type updatedEqpmt = (from c in entities.tbl_eqpmt_type
where c.id == eqpmtUpdate.id
select c).FirstOrDefault();
updatedEqpmt.eqpmtType = eqpmtUpdate.eqpmtType;
updatedEqpmt.model = eqpmtUpdate.model;
updatedEqpmt.description = eqpmtUpdate.description;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateEvent(tbl_event_type eventUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_event_type updatedEvent = (from c in entities.tbl_event_type
where c.id == eventUpdate.id
select c).FirstOrDefault();
updatedEvent.eventID = eventUpdate.eventID;
updatedEvent.eventType = eventUpdate.eventType;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult AddCustEqpmt(tbl_customer_eqpmt custEqpmtAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_customer_eqpmt.Add(new tbl_customer_eqpmt()
{
customerCode = custEqpmtAdd.customerCode,
machineID = custEqpmtAdd.machineID,
jobNum = custEqpmtAdd.jobNum,
eqpmtType = custEqpmtAdd.eqpmtType
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateCurrentEqpmt(tbl_eqpmt_kits_current currentEqpmtUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_eqpmt_kits_current UpdateCurrentEqpmt = (from c in entities.tbl_eqpmt_kits_current
where c.id == currentEqpmtUpdate.id
select c).FirstOrDefault();
UpdateCurrentEqpmt.machineID = currentEqpmtUpdate.machineID;
UpdateCurrentEqpmt.kitID = currentEqpmtUpdate.kitID;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult AddEqpmtType(tbl_eqpmt_type_mgmt eqpmtTypeAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_eqpmt_type_mgmt.Add(new tbl_eqpmt_type_mgmt
{
eqpmtType = eqpmtTypeAdd.eqpmtType
});
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult AddCurrentEqpmt(tbl_eqpmt_kits_current currentEqpmtAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_eqpmt_kits_current.Add(new tbl_eqpmt_kits_current
{
machineID = currentEqpmtAdd.machineID,
kitID = currentEqpmtAdd.kitID
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateKit(tbl_kit kitUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_kit updatedKit = (from c in entities.tbl_kit
where c.id == kitUpdate.id
select c).FirstOrDefault();
updatedKit.kitID = kitUpdate.kitID;
updatedKit.description = kitUpdate.description;
updatedKit.filePath = kitUpdate.filePath;
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult AddEvent(tbl_customer_event eventAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_customer_event.Add(new tbl_customer_event()
{
customerCode = eventAdd.customerCode,
eventID = eventAdd.eventID,
eventType = eventAdd.eventType,
startDate = eventAdd.startDate,
endDate = eventAdd.endDate
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult AddKit(tbl_kit kitAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_kit.Add(new tbl_kit
{
kitID = kitAdd.kitID,
description = kitAdd.description,
filePath = kitAdd.filePath,
});
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateCustEqpmt(tbl_customer_eqpmt custEqpmtUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_customer_eqpmt updatedCustEqpmt = (from c in entities.tbl_customer_eqpmt
where c.id == custEqpmtUpdate.id
select c).FirstOrDefault();
updatedCustEqpmt.customerCode = custEqpmtUpdate.customerCode;
updatedCustEqpmt.machineID = custEqpmtUpdate.machineID;
updatedCustEqpmt.jobNum = custEqpmtUpdate.jobNum;
updatedCustEqpmt.eqpmtType = custEqpmtUpdate.eqpmtType;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult AddEqpmt(tbl_eqpmt_type eqpmtAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_eqpmt_type.Add(new tbl_eqpmt_type
{
eqpmtType = eqpmtAdd.eqpmtType,
model = eqpmtAdd.model,
description = eqpmtAdd.description
});
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult UpdateEvent(tbl_customer_event eventUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_customer_event updatedEvent = (from c in entities.tbl_customer_event
where c.id == eventUpdate.id
select c).FirstOrDefault();
updatedEvent.customerCode = eventUpdate.customerCode;
updatedEvent.eventID = eventUpdate.eventID;
updatedEvent.eventType = eventUpdate.eventType;
updatedEvent.startDate = eventUpdate.startDate;
updatedEvent.endDate = eventUpdate.endDate;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateCustomer(tbl_customer custUpdate)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
tbl_customer updatedCustomer = (from c in entities.tbl_customer
where c.id == custUpdate.id
select c).FirstOrDefault();
updatedCustomer.customerCode = custUpdate.customerCode;
updatedCustomer.name = custUpdate.name;
updatedCustomer.address = custUpdate.address;
updatedCustomer.city = custUpdate.city;
updatedCustomer.state = custUpdate.state;
updatedCustomer.zipCode = custUpdate.zipCode;
entities.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult AddCustomer(tbl_customer customerAdd)
{
using (allpax_sale_minerEntities entities = new allpax_sale_minerEntities())
{
entities.tbl_customer.Add(new tbl_customer
{
customerCode = customerAdd.customerCode,
name = customerAdd.name,
address = customerAdd.address,
city = customerAdd.city,
state = customerAdd.state,
zipCode = customerAdd.zipCode,
});
entities.SaveChanges();
}
return(new EmptyResult());
}