//
// GET: /PromotionalItemDistribution/Edit/5
public ActionResult Edit(decimal id = 0)
{
TRN_USER_PROMO_ITEM trn_user_promo_item = db.TRN_USER_PROMO_ITEM.Single(t => t.USER_PROMO_NO == id);
if (trn_user_promo_item == null)
{
return(HttpNotFound());
}
ViewBag.USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_user_promo_item.USER_NO);
return(View(trn_user_promo_item));
}
//
// GET: /PromotionalItemDistribution/Details/5
public ActionResult Details(decimal id = 0)
{
TRN_USER_PROMO_ITEM trn_user_promo_item = db.TRN_USER_PROMO_ITEM.Single(t => t.USER_PROMO_NO == id);
if (trn_user_promo_item == null)
{
return(HttpNotFound());
}
ViewBag.dets = trn_user_promo_item.TRN_USER_PROMO_DET.ToList();
return(View(trn_user_promo_item));
}
public ActionResult Edit(TRN_USER_PROMO_ITEM trn_user_promo_item)
{
if (ModelState.IsValid)
{
db.TRN_USER_PROMO_ITEM.Attach(trn_user_promo_item);
db.ObjectStateManager.ChangeObjectState(trn_user_promo_item, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_user_promo_item.USER_NO);
return(View(trn_user_promo_item));
}
public ActionResult DeleteConfirmed(decimal id)
{
TRN_USER_PROMO_ITEM trn_user_promo = db.TRN_USER_PROMO_ITEM.Single(t => t.USER_PROMO_NO == id);
IQueryable <TRN_USER_PROMO_DET> dets = db.TRN_USER_PROMO_DET
.Where(x => x.USER_PROMO_NO == id).AsQueryable();
foreach (TRN_USER_PROMO_DET det in dets)
{
db.TRN_USER_PROMO_DET_DELETE(det.USER_PROMO_DET_NO, decimal.Parse(Session["sess_USER_NO"].ToString()), decimal.Parse(Session["sess_LOGON_NO"].ToString()));
}
db.TRN_USER_PROMO_ITEM_DELETE(trn_user_promo.USER_PROMO_NO, decimal.Parse(Session["sess_USER_NO"].ToString()), decimal.Parse(Session["sess_LOGON_NO"].ToString()));
return(RedirectToAction("Index"));
}
public JsonResult getOnePrevData(int?id)
{
TRN_USER_PROMO_ITEM trn_user_promotion = db.TRN_USER_PROMO_ITEM.Single(t => t.USER_PROMO_NO == id);
/*JavaScriptSerializer TheSerializer = new JavaScriptSerializer();
* return TheSerializer.Serialize(trn_user_specimen);*/
return(Json(new
{
specid = trn_user_promotion.USER_PROMO_NO,
userno = trn_user_promotion.USER_NO,
userName = db.SEC_USERS.Single(t => t.USER_NO == trn_user_promotion.USER_NO).USER_NAME,
assign_date = trn_user_promotion.ASSIGN_DATE.ToString("yyyy-MM-dd"),
target_date_from = DateTime.Parse(trn_user_promotion.TARGET_DATE_FROM.ToString()).ToString("yyyy-MM-dd"),
target_date_to = DateTime.Parse(trn_user_promotion.TARGET_DATE_TO.ToString()).ToString("yyyy-MM-dd"),
active = trn_user_promotion.IS_ACTIVE
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(decimal id = 0)
{
/* if (Session["sess_USER_NO"] != null)
* {*/
TRN_USER_PROMO_ITEM trn_user_promo_item = db.TRN_USER_PROMO_ITEM.Single(t => t.USER_PROMO_NO == id);
if (trn_user_promo_item == null)
{
return(HttpNotFound());
}
ViewBag.dets = trn_user_promo_item.TRN_USER_PROMO_DET.ToList();
return(View(trn_user_promo_item));
/*}
* else
* {
* return RedirectToAction("Login", "Login");
* }*/
}
public ActionResult Create(TRN_USER_PROMO_ITEM trn_user_promo_item)
{
//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_promo_item.edit_ID == 0)
{
trn_user_promo_item.USER_PROMO_NO = db.TRN_USER_PROMO_ITEM_INSERT(
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
trn_user_promo_item.USER_NO,
trn_user_promo_item.ASSIGN_DATE,
trn_user_promo_item.TARGET_DATE_FROM,
trn_user_promo_item.TARGET_DATE_TO,
trn_user_promo_item.IS_ACTIVE).First().Value;
}
else
{
db.TRN_USER_PROMO_ITEM_UPDATE(trn_user_promo_item.edit_ID,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
trn_user_promo_item.USER_NO,
trn_user_promo_item.ASSIGN_DATE,
trn_user_promo_item.TARGET_DATE_FROM,
trn_user_promo_item.TARGET_DATE_TO,
trn_user_promo_item.IS_ACTIVE);
}
List <string> lstTmp = new List <string>();
foreach (string crntSession in Session)
{
if (crntSession.Contains("promotion"))
{
lstTmp.Add(crntSession);
decimal tmp = decimal.Parse(crntSession.Replace("promotion", ""));
temp_TRN_USER_PROMO_ITEM_DET temp_sess_det = (temp_TRN_USER_PROMO_ITEM_DET)Session[crntSession];
if (!temp_sess_det.deleted)
{
TRN_USER_PROMO_DET tmp_det = db.TRN_USER_PROMO_DET.FirstOrDefault(t => t.PROMO_ITEM_NO == tmp &&
t.USER_PROMO_NO == ((trn_user_promo_item.edit_ID == 0) ? trn_user_promo_item.USER_PROMO_NO :
trn_user_promo_item.edit_ID));
TRN_USER_PROMO_DET trn_user_promotion_det = (tmp_det == null) ? new TRN_USER_PROMO_DET() : tmp_det;
trn_user_promotion_det.QTY = temp_sess_det.qty;
trn_user_promotion_det.IS_ACTIVE = (temp_sess_det.active) ? 1 : 0;
trn_user_promotion_det.SET_PROMO_ITEM = db.SET_PROMO_ITEM.Single(t => t.PROMO_ITEM_NO == tmp);
if (trn_user_promotion_det.USER_PROMO_DET_NO != 0)
{
db.TRN_USER_PROMO_DET_UPDATE(trn_user_promotion_det.USER_PROMO_DET_NO,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
(trn_user_promo_item.edit_ID == 0) ? trn_user_promo_item.USER_PROMO_NO :
trn_user_promo_item.edit_ID,
trn_user_promotion_det.PROMO_ITEM_NO,
trn_user_promotion_det.QTY,
trn_user_promotion_det.IS_ACTIVE);
}
else
{
db.TRN_USER_PROMO_DET_INSERT(decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
(trn_user_promo_item.edit_ID == 0) ? trn_user_promo_item.USER_PROMO_NO :
trn_user_promo_item.edit_ID,
trn_user_promotion_det.PROMO_ITEM_NO,
trn_user_promotion_det.QTY,
trn_user_promotion_det.IS_ACTIVE);
}
}
else
{
TRN_USER_PROMO_DET trn_tmp = db.TRN_USER_PROMO_DET.FirstOrDefault(t => t.PROMO_ITEM_NO == temp_sess_det.specimenid &&
t.USER_PROMO_NO == trn_user_promo_item.edit_ID);
if (trn_tmp != null)
{
db.TRN_USER_PROMO_DET_DELETE(trn_tmp.USER_PROMO_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_promo_item));
}
