/*public JsonResult editSpecimen(int id, int qty)
* {
* if (Session["specimen" + id] != null)
* Session["specimen" + id]
* }*/
public JsonResult SaveSpecimenOnSession(int id, int qty, string status)
{
/*if (Session["specimen" + id] == null)
* Session.Add("specimen" + id, qty);
* else*/
Session["specimen" + id] = new temp_TRN_USER_SPECIMEN_DET(id, (status == "Active") ? true : false, qty);
//qty = 0;
return(Json(new { dt = id }));
}
public void RemoveSpecimenFromDB(int?specid, int?edit_id)
{
/*TRN_USER_SPECIMEN_DET trn_tmp = db.TRN_USER_SPECIMEN_DET.FirstOrDefault(t => t.SPECIMEN_NO == specid &&
* t.USER_SPECIMEN_NO == edit_id);
* if (trn_tmp != null)
* {
* db.TRN_USER_SPECIMEN_DET_DELETE(trn_tmp.SPECIMEN_DET_NO,
* trn_tmp.LAST_ACTION_USER_NO,
* trn_tmp.LAST_ACTION_LOGON_NO);*/
temp_TRN_USER_SPECIMEN_DET from_sess = (temp_TRN_USER_SPECIMEN_DET)Session["specimen" + specid];
from_sess.set_deleted();
Session["specimen" + specid] = from_sess;
/*return "Specimen successfully removed.";
* }
* else
* return "Data not found";*/
}
public ActionResult Create(TRN_USER_SPECIMEN trn_user_specimen)
{
//TRN_USER_SPECIMEN trn_user_specimen = new TRN_USER_SPECIMEN();
if (ModelState.IsValid)
{
//TryUpdateModel(trn_user_specimen, frm);
//trn_user_specimen.IS_ACTIVE = bool.Parse(frm["IS_ACTIVE"].ToString()) == true ? 1 : 0;
//db.TRN_USER_SPECIMEN.AddObject(trn_user_specimen);
/*db.TRN_USER_SPECIMEN.AddObject(trn_user_specimen);
* db.SaveChanges();*/
if (trn_user_specimen.edit_ID == 0)
{
trn_user_specimen.USER_SPECIMEN_NO = db.TRN_USER_SPECIMEN_INSERT(
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
trn_user_specimen.USER_NO,
trn_user_specimen.ASSIGN_DATE,
trn_user_specimen.TARGET_DATE_FROM,
trn_user_specimen.TARGET_DATE_TO,
trn_user_specimen.IS_ACTIVE).First().Value;
}
else
{
db.TRN_USER_SPECIMEN_UPDATE(trn_user_specimen.edit_ID,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
trn_user_specimen.USER_NO,
trn_user_specimen.ASSIGN_DATE,
trn_user_specimen.TARGET_DATE_FROM,
trn_user_specimen.TARGET_DATE_TO,
trn_user_specimen.IS_ACTIVE);
}
List <string> lstTmp = new List <string>();
foreach (string crntSession in Session)
{
if (crntSession.Contains("specimen"))
{
lstTmp.Add(crntSession);
decimal tmp = decimal.Parse(crntSession.Replace("specimen", ""));
temp_TRN_USER_SPECIMEN_DET temp_sess_det = (temp_TRN_USER_SPECIMEN_DET)Session[crntSession];
if (!temp_sess_det.deleted)
{
TRN_USER_SPECIMEN_DET tmp_det = db.TRN_USER_SPECIMEN_DET.FirstOrDefault(t => t.SPECIMEN_NO == tmp &&
t.USER_SPECIMEN_NO == ((trn_user_specimen.edit_ID == 0) ? trn_user_specimen.USER_SPECIMEN_NO :
trn_user_specimen.edit_ID));
TRN_USER_SPECIMEN_DET trn_user_specimen_det = (tmp_det == null) ? new TRN_USER_SPECIMEN_DET() : tmp_det;
trn_user_specimen_det.QTY = temp_sess_det.qty;
trn_user_specimen_det.IS_ACTIVE = (temp_sess_det.active) ? 1 : 0;
trn_user_specimen_det.SET_SPECIMEN = db.SET_SPECIMEN.Single(t => t.SPECIMEN_NO == tmp);
if (trn_user_specimen_det.SPECIMEN_DET_NO != 0)
{
db.TRN_USER_SPECIMEN_DET_UPDATE(trn_user_specimen_det.SPECIMEN_DET_NO,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
(trn_user_specimen.edit_ID == 0) ? trn_user_specimen.USER_SPECIMEN_NO :
trn_user_specimen.edit_ID,
trn_user_specimen_det.SPECIMEN_NO,
trn_user_specimen_det.QTY,
trn_user_specimen_det.IS_ACTIVE);
}
else
{
db.TRN_USER_SPECIMEN_DET_INSERT(decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
(trn_user_specimen.edit_ID == 0) ? trn_user_specimen.USER_SPECIMEN_NO :
trn_user_specimen.edit_ID,
trn_user_specimen_det.SPECIMEN_NO,
trn_user_specimen_det.QTY,
trn_user_specimen_det.IS_ACTIVE);
}
}
else
{
TRN_USER_SPECIMEN_DET trn_tmp = db.TRN_USER_SPECIMEN_DET.FirstOrDefault(t => t.SPECIMEN_NO == temp_sess_det.specimenid &&
t.USER_SPECIMEN_NO == trn_user_specimen.edit_ID);
if (trn_tmp != null)
{
db.TRN_USER_SPECIMEN_DET_DELETE(trn_tmp.SPECIMEN_DET_NO,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()));
}
}
}
}
foreach (string tmp in lstTmp)
{
Session.Remove(tmp);
}
//int count = db.SaveChanges();
return(RedirectToAction("Index"));
}
//else
//return View();
return(View(trn_user_specimen));
}
