//[HttpPost]
//public ActionResult Create(TPO.Model.RawMaterials.RawMaterialQCModel model)
//{
// TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
// model = qcBL.InsertRawMaterialQCModel(model);
// return RedirectToAction("Edit", new { id = model.ID, unlocked = false });
//}
public ActionResult Edit(int id = 0, bool isNew = false, bool success = false)
{
TPO.BL.Security.User userBL = new TPO.BL.Security.User();
ViewBag.QCTech = new SelectList(userBL.GetQCTechUsers(), "ID", "FullName");
TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
TPO.Model.RawMaterials.RawMaterialQCModel model = qcBL.GetRawMaterialQCModelByRawMaterialQCID(id);
//model.IsEditMode = !isNew;
//hack
if (success)
{
TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageSuccessSave);
TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeSuccess);
}
if (model == null)
{
TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord);
//string.Format("Raw Material QC with ID {0} not found.", id);
TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError);
return(RedirectToAction("Index"));
//return HttpNotFound(string.Format("Raw Material QC with ID {0} not found.", id));
}
return(View(model));
}
//// GET: /RawMaterialQC/LotID
//public ActionResult GetTestIDs(int ID)
//{
// List<SelectListItem> testItems = new List<SelectListItem>();
// TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
// var testRecords =
// db.RawMaterialQCs.Where(x => x.RawMaterialReceivedID == ID)
// .OrderByDescending(x => x.DateEntered)
// .ToList();
// if (testRecords.Count > 0)
// {
// testItems.Add(new SelectListItem {Value = "", Text = "-- Select Test --"});
// }
// else
// {
// testItems.Add(new SelectListItem {Value = "", Text = "-- No Tests for Lot: " + ID + " --"});
// }
// foreach (var item in testRecords)
// {
// testItems.Add(new SelectListItem
// {
// Value = item.ID.ToString(),
// Text = item.DateEntered.ToString("MM/dd/yy hh:mm") + " | " + item.BoxCarTested
// });
// }
// return Json(testItems);
//}
public ActionResult Create(string rm = "", string lot = "")
{
TPO.BL.Security.User userBL = new TPO.BL.Security.User();
ViewBag.QCTech = new SelectList(userBL.GetQCTechUsers(), "ID", "FullName");
TPO.Model.RawMaterials.RawMaterialQCModel model = new TPO.Model.RawMaterials.RawMaterialQCModel();
int tmpRawMaterialReceivedId = 0;
if (!int.TryParse(lot, out tmpRawMaterialReceivedId))
{
tmpRawMaterialReceivedId = 0;
}
model.RawMaterialReceivedID = tmpRawMaterialReceivedId;
TPO.DL.Models.RawMaterialReceived rawMaterialLookup =
new TPOMVCApplicationEntities().RawMaterialQCs.Where(
w => w.RawMaterialReceivedID == tmpRawMaterialReceivedId).First().RawMaterialReceived;
if (rawMaterialLookup == null)
{
TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord);
//string.Format("Raw Material Test configuration not found for raw material {0}.", rm);
TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError);
return(RedirectToAction("Index"));
//return HttpNotFound(string.Format("Raw Material Test configuration not found for raw material {0}.", rm));
}
model.RawMaterialCode = rawMaterialLookup.RawMaterial.Code;
model.LotCode = rawMaterialLookup.LotNumber;
model.QCTechID = CurrentUserID;
TPO.BL.RawMaterials.RawMaterialTest rmtBL = new TPO.BL.RawMaterials.RawMaterialTest();
model.QCConfiguration = rmtBL.GetQCConfigurationByRawMaterial(tmpRawMaterialReceivedId);
if (model.QCConfiguration == null)
{
TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord);
//string.Format("Raw Material Test configuration not found for raw material {0}.", rm);
TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError);
return(RedirectToAction("Index"));
//return HttpNotFound(string.Format("Raw Material Test configuration not found for raw material {0}.", rm));
}
TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
model = qcBL.InsertRawMaterialQCModel(model);
model.LastModified = DateTime.Now;
// return View(model);
return(RedirectToAction("Edit", new { id = model.ID }));
}
public ActionResult Edit_Post(TPO.Model.RawMaterials.RawMaterialQCModel qc, int id = 0)
//TPO.Model.RawMaterials.RawMaterialQCModel model
{
//TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
//qcBL.UpdateRawMaterialQCModel(model);
//return View(model);
bool success = false;
if (ModelState.IsValid)
{
TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
ViewBag.RawMaterial = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID");
qc.DateEntered = Convert.ToDateTime(System.DateTime.Now);
qc.EnteredBy = CurrentUser;
qc.LastModified = Convert.ToDateTime(System.DateTime.Now);
qc.ModifiedBy = CurrentUser;
TPO.BL.RawMaterials.RawMaterialQC layeredit = new TPO.BL.RawMaterials.RawMaterialQC();
layeredit.UpdateRawMaterialQCModel(qc);
success = true;
}
return(RedirectToAction("Edit", new { id = id, success = success }));
}
public ActionResult Index_Post(string Action, FormCollection formCollection, string RawMaterial, string LotID)
{
if (Action == "Lot Not In List")
{
return(RedirectToAction("Create", "RawMaterial"));
}
if (ModelState.IsValid)
{
TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
ViewBag.RawMaterial = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID");
if (Action == "New Test")
{
TPO.DL.Models.RawMaterialQC rawmaterialqc = new TPO.DL.Models.RawMaterialQC();
//rawmaterialqc.RawMaterialID = RawMaterial;
rawmaterialqc.PlantID = CurrentPlantId;
string string1 = formCollection["RawMaterialQC"];
string string2 = formCollection["RawMaterialLotQC"];
/*
* if (!(string.IsNullOrEmpty(string1)))
* {
* try
* {
* rawmaterialqc.RawMaterialReceived.RawMaterialID = int.Parse(string1);
* }
* catch
* {
*
* }
* }
*/
if (!(string.IsNullOrEmpty(string2)))
{
try
{
rawmaterialqc.RawMaterialReceivedID = int.Parse(string2);
}
catch
{
}
}
rawmaterialqc.DateEntered = Convert.ToDateTime(System.DateTime.Now);
rawmaterialqc.EnteredBy = "";
rawmaterialqc.LastModified = Convert.ToDateTime(System.DateTime.Now);
rawmaterialqc.ModifiedBy = "";
TryUpdateModel(rawmaterialqc);
TPO.BL.RawMaterials.RawMaterialQC layer1 = new TPO.BL.RawMaterials.RawMaterialQC();
string ID;
TryUpdateModel(rawmaterialqc);
if (ModelState.IsValid)
{
ID = layer1.AddRawMaterialTest(rawmaterialqc);
return(RedirectToAction("Edit", new { id = ID, isNew = true }));
}
else
{
return(RedirectToAction("index"));
}
}
else
{
return(RedirectToAction("Index"));
}
}
return(View());
}
//
// GET: /RawMaterialQC/
public ActionResult Index(int?id, bool unlocked = false)
{
TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
//
var RawMat = db.RawMaterialQCs.Where(s => s.RawMaterialReceivedID != null).ToList();
TPO.BL.RawMaterials.RawMaterial RawMatList = new TPO.BL.RawMaterials.RawMaterial();
ViewBag.RawMaterialQCList = RawMatList.GetRawMaterials();
//TODO: Refactor after RawMaterialModel is completed to use intID
List <RawMaterialModel> rawMatListFromBL = RawMatList.GetRawMaterials();
var QCList = db.Users.Where(s => s.ID != null).ToList();
IEnumerable <SelectListItem> rawMaterialSelectList = from s in rawMatListFromBL
select new SelectListItem
{
Value = s.RawMaterialCode,
Text = (s.RawMaterialCode + " | " + s.RawMaterialName)
};
//IEnumerable<SelectListItem> selectList = from s in RawMat
// select new SelectListItem
// {
// Value = s.RawMaterialID,
// Text = s.RawMaterialID + " | " + s.RawMaterialLotID.ToString()
// };
IEnumerable <SelectListItem> lotSelectList = from s in RawMaterialReceivedRepo.GetAll()
select new SelectListItem
{
Value = s.LotNumber,
Text = s.LotNumber + " | " + s.LastModified.ToShortDateString()
};
//IEnumerable<SelectListItem> lotSelectList = from s in RawMat
// select new SelectListItem
// {
// Value = s.RawMaterialLotID,
// Text = (s.RawMaterialLotID.Length != 11 ? s.RawMaterialLotID : s.RawMaterialLotID) + " | " +
// s.DateEntered.ToShortDateString() +
// " | " + s.LastModified.ToShortDateString()
// };
IEnumerable <SelectListItem> lotTestList = from s in RawMat
select new SelectListItem
{
Value = s.ID.ToString(),
Text = s.DateEntered.ToShortDateString() + " | " + s.BoxCarTested
};
//new SelectList()
ViewBag.RawMaterialQC = new SelectList(rawMaterialSelectList, "Value", "Text");
ViewBag.RawMaterialLotQC = new SelectList(lotSelectList, "Value", "Text");
ViewBag.RawMaterialQCLotTest = new SelectList(lotTestList, "Value", "Text");
ViewBag.RawMaterialQCLastModified = new SelectList(RawMat, "ID", "LastModified");
ViewBag.RawMaterialEnteredBy = new SelectList(QCList, "ID", "FullName");
TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
//if (id != null)
//{
// RawMaterialQCModel model = qcBL.GetRawMaterialQCModelByRawMaterialQCID(id ?? Convert.ToInt32(id));
//}
//else
//{
// RawMaterialQCModel model = new RawMaterialQCModel();
//}
RawMaterialQCModel model = qcBL.GetRawMaterialQCModelByRawMaterialQCID(id ?? Convert.ToInt32(id));
if (model == null)
{
model = new RawMaterialQCModel();
}
var tests = (from t in db.RawMaterialQCs
where t.RawMaterialReceived.ID == t.RawMaterialReceivedID
select t).ToList();
ViewBag.QCItems = tests;
return(View(model));
}
