public JsonResult changeDeleteDCRFromSession(string id)
{
temp_TRN_DCR_DET tmpdet = (temp_TRN_DCR_DET)Session["DCREntry" + id];
if (tmpdet != null)
{
tmpdet.setdeleted();
Session["DCREntry" + id + "del"] = tmpdet;
TRN_DCR_DET trn_dcr_det = db.TRN_DCR_DET.Where(t => t.DCR_DET_NO == tmpdet.editID).Single();
return(Json(new { dt = id, html = getDetailFieldsINT(trn_dcr_det.TRN_DCR.DCR_TYPE_NO, tmpdet.editID) }));
}
return(Json((new { dt = "Not Found" })));
}
/***
* Internal call to this function
* here this will generate the table
* for the edit dcr_det
*
* */
public string getDetailFieldsINT(decimal typeID, decimal editID)
{
string ret = "";
GEN_DCR_TYPE type = db.GEN_DCR_TYPE.Where(x => x.DCR_TYPE_NO == (typeID)).First();
TRN_DCR_DET dcr_det = db.TRN_DCR_DET.Where(x => x.DCR_DET_NO == editID).Single();
string cd = (dcr_det.IS_FOR_CLIENT == 1)?dcr_det.CLIENT_MOBILE:dcr_det.TEACHER_MOBILE;
switch (type.DCR_TYPE_CODE)
{
case "TC":
ret += "<tr><td>Teacher Mobile No:</td><td><input id='contactDetail' name='contactDetail' tmp='teacher' type=\"text\" class=\"form-control\" value=" + cd + " ></td><td></td>";
ret += "<td><input type=\"button\" value=\"Add\" tmp='tc' id='btnAdd' class=\"btn btn-success\" /></td></tr>";
ret += "<input type='hidden' name='FOR_WHOM' value='teacher'/>";
ret += "<input type='hidden' name='hdnContactNo' value='0'/>";
break;
case "LC":
ret += "<tr><td>Library Mobile No: </td><td><input id='contactDetail' name='contactDetail' tmp='library' value='" + cd + "' type=\"text\" class=\"form-control\"></td><td></td></tr>";
ret += "<tr><td>For Whom</td><td> <input type=\"radio\" name=\"FOR_WHOM\" value=\"teacher\">Teacher</td><td> <input type=\"radio\" name=\"FOR_WHOM\" value=\"client\">Client</td>";
ret += "<td><input type=\"button\" value=\"Add\" tmp='lc' id='btnAdd' class=\"btn btn-success\" /></td></tr>";
ret += "<input type='hidden' name='hdnContactNo' value='0'/>";
break;
case "SD":
ret += "<tr><td>Specimen No: </td><td><input id='promoID' name='promoID' type=\"text\" class=\"promotion form-control\" value='" +
((dcr_det.SET_SPECIMEN != null)?dcr_det.SET_SPECIMEN.SPECIMEN_CODE:"") +
"' tmp='specimen' /></td><td></td>";
ret += "<td>QTY</td><td><input id='QTY' name='QTY' type=\"text\" class=\"form-control\" value='" + dcr_det.SPECIMEN_QTY + "' /></td></tr>";
ret += "<tr><td>Mobile No: </td><td><input id='contactDetail' tmp='teacher' name='TEACHER_MOBILE' type=\"text\" value='" + cd + "' class=\"form-control\"></td><td></td>";
ret += "<td><label><input id='chkBehalf' type=\"checkbox\" class=\"form-control\">On Behalf</label></td>";
ret += "<td ><input id='txtBehalf' name='BEHALF_MOBILE' style='display:none' type=\"text\" class=\"form-control\" value='" + dcr_det.BEHALF_MOBILE + "'></td>";
ret += "<td><input type=\"button\" value=\"Add\" tmp='specimen' id='btnAdd' class=\"btn btn-success\" /></td>";
ret += "</tr>";
ret += "<input id=\"hdnDetCode\" name='SPECIMEN_NO' type=\"hidden\" value='" + dcr_det.SPECIMEN_NO + "' />";
ret += "<input type='hidden' name='hdnContactNo' value='0'/>";
ret += "<input type='hidden' name='FOR_WHOM' value='teacher'/>";
break;
case "MP":
ret += "<tr><td>Promotional Item No: </td><td><input id='promoID' name='promoID' type=\"text\" class=\"promotion form-control\" tmp='promotion' value='" +
((dcr_det.SET_PROMO_ITEM != null) ? dcr_det.SET_PROMO_ITEM.PROMO_ITEM_CODE : "") +
"'></td><td></td>";
ret += "<td>QTY</td><td><input id='QTY' name='QTY' type=\"text\" class=\"form-control\" value='" + dcr_det.PROMO_ITEM_QTY + "' /></td></tr>";
ret += "<tr><td>For Whom</td><td> <input type=\"radio\" name=\"FOR_WHOM\" value=\"Teacher\">Teacher</td><td> <input type=\"radio\" name=\"FOR_WHOM\" value=\"Client\">Client</td></tr>";
ret += "<tr><td>Mobile No: </td><td><input id='contactDetail' tmp='teacher' name='TEACHER_MOBILE' value='" + cd + "' type=\"text\" class=\"form-control\"></td><td></td>";
ret += "<td><label><input id='chkBehalf' type=\"checkbox\" class=\"form-control\">On Behalf</label></td>";
ret += "<td ><input style='display:none' name='BEHALF_MOBILE' id='txtBehalf' type=\"text\" class=\"form-control\" value='" + dcr_det.BEHALF_MOBILE + "'></td>";
ret += "<td><input type=\"button\" value=\"Add\" tmp='promotion' id='btnAdd' class=\"btn btn-success\" /></td>";
ret += "</tr>";
ret += "<input type='hidden' name='hdnContactNo' value='0'/>";
ret += "<input id=\"hdnDetCode\" name='PROMO_ITEM_NO' type=\"hidden\" value='" + dcr_det.PROMO_ITEM_NO + "' />";
break;
default:
ret = "";
break;
}
List <string> lstTmp = new List <string>();
foreach (string curSession in Session)
{
if (curSession.Contains("DCREntry"))
{
lstTmp.Add(curSession);
}
}
foreach (string del in lstTmp)
{
Session.Remove(del);
}
return(ret);
}
public ActionResult Create(TRN_DCR trn_dcr)
{
if (ModelState.IsValid)
{
trn_dcr.TIME_FROM = DateTime.ParseExact(trn_dcr.TRN_DCR_DATE.Year + "-" + trn_dcr.TRN_DCR_DATE.Month + "-" + trn_dcr.TRN_DCR_DATE.Day + " " + trn_dcr.FROM_TIME + ":00,000",
"yyyy-M-dd H:m:ss,fff", System.Globalization.CultureInfo.InvariantCulture);
trn_dcr.TIME_TO = DateTime.ParseExact(trn_dcr.TRN_DCR_DATE.Year + "-" + trn_dcr.TRN_DCR_DATE.Month + "-" + trn_dcr.TRN_DCR_DATE.Day + " " + trn_dcr.TO_TIME + ":00,000",
"yyyy-M-dd H:m:ss,fff", System.Globalization.CultureInfo.InvariantCulture);
TimeSpan ts = DateTime.Parse(trn_dcr.TIME_TO.ToString()).Subtract(DateTime.Parse(trn_dcr.TIME_FROM.ToString()));
if (trn_dcr.edit_ID == 0)
{
decimal trn_dcr_no = db.TRN_DCR_INSERT(decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
trn_dcr.INSERT_OFFLINE_TIME,
null, null, trn_dcr.DCR_TYPE_NO, trn_dcr.user_ID,
null, trn_dcr.IS_REF_ZM, trn_dcr.user_ID, trn_dcr.REF_ZM_MOBILE, null,
trn_dcr.WORK_AREA_FROM_LAT, trn_dcr.WORK_AREA_FROM_LON, trn_dcr.WORK_AREA_FROM_NAME,
trn_dcr.WORK_AREA_TO_LAT, trn_dcr.WORK_AREA_TO_LON, trn_dcr.WORK_AREA_TO_NAME,
trn_dcr.TIME_FROM, trn_dcr.TIME_TO, Convert.ToDecimal(ts.Hours), trn_dcr.DIVISION_NO,
trn_dcr.ZONE_NO, trn_dcr.ZILLA_NO, trn_dcr.THANA_NO, trn_dcr.INSTITUTE_NO,
trn_dcr.TRANS_TYPE_NO, trn_dcr.FARE_AMT, trn_dcr.TRN_DCR_DATE, 1,
null, trn_dcr.COMMENTS).FirstOrDefault().Value;
trn_dcr.DCR_NO = trn_dcr_no;
}
else
{
db.TRN_DCR_UPDATE(trn_dcr.edit_ID,
decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()), trn_dcr.UPDATE_OFFLINE_TIME,
trn_dcr.UPDATE_OFFLINE_SYNC, 1, trn_dcr.DCR_TYPE_NO, trn_dcr.user_ID,
null, trn_dcr.IS_REF_ZM, null, trn_dcr.REF_ZM_MOBILE,
null, trn_dcr.WORK_AREA_FROM_LAT, trn_dcr.WORK_AREA_FROM_LON, trn_dcr.WORK_AREA_FROM_NAME,
trn_dcr.WORK_AREA_TO_LAT, trn_dcr.WORK_AREA_TO_LON, trn_dcr.WORK_AREA_TO_NAME,
trn_dcr.TIME_FROM, trn_dcr.TIME_TO, Convert.ToDecimal(ts.Hours), trn_dcr.DIVISION_NO,
trn_dcr.ZONE_NO, trn_dcr.ZILLA_NO, trn_dcr.THANA_NO, trn_dcr.INSTITUTE_NO,
trn_dcr.TRANS_TYPE_NO, trn_dcr.FARE_AMT, trn_dcr.APPROVE_TRANS_TYPE_NO,
trn_dcr.APPROVE_FARE_AMT, trn_dcr.TRN_DCR_DATE, 1, null, trn_dcr.COMMENTS);
}
List <string> lstTmp = new List <string>();
foreach (string curSession in Session)
{
if (curSession.Contains("DCREntry"))
{
lstTmp.Add(curSession);
temp_TRN_DCR_DET temp_sess_det = (temp_TRN_DCR_DET)Session[curSession];
TRN_DCR_DET det = (temp_sess_det.editID != 0) ? db.TRN_DCR_DET.Where(s => s.DCR_DET_NO == temp_sess_det.editID).FirstOrDefault()
:db.TRN_DCR_DET.Where(s => s.DCR_NO == ((trn_dcr.DCR_NO == 0) ? trn_dcr.edit_ID : trn_dcr.DCR_NO) &&
(s.CLIENT_MOBILE == temp_sess_det.client_mobile || s.TEACHER_MOBILE == temp_sess_det.teacher_mobile)).FirstOrDefault();
if (!temp_sess_det.set_deleted)
{
if (det == null)
{
db.TRN_DCR_DET_INSERT(decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()),
DateTime.Now, trn_dcr.INSERT_OFFLINE_SYNC,
1, ((trn_dcr.DCR_NO == 0) ? trn_dcr.edit_ID : trn_dcr.DCR_NO), (temp_sess_det.RcvType.ToLower() == "teacher") ? 1 : 0, temp_sess_det.teacher_no,
temp_sess_det.teacher_mobile, temp_sess_det.is_behalf, temp_sess_det.BEHALF_MOBILE,
(temp_sess_det.type == "specimen") ? temp_sess_det.type_id : null, (temp_sess_det.type == "specimen") ? temp_sess_det.qty : null,
((temp_sess_det.RcvType.ToLower() == "teacher") ? 0 : 1), temp_sess_det.client_no, temp_sess_det.client_mobile,
(temp_sess_det.type == "specimen") ? temp_sess_det.type_id : null, (temp_sess_det.type == "specimen") ? temp_sess_det.qty : null,
null, null);
}
else
{
db.TRN_DCR_DET_UPDATE(det.DCR_DET_NO, decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()), DateTime.Now,
det.UPDATE_OFFLINE_SYNC, det.UPDATE_IS_OFFLINE, det.DCR_NO, ((temp_sess_det.RcvType == "client") ? 0 : 1),
temp_sess_det.teacher_no, temp_sess_det.teacher_mobile, temp_sess_det.is_behalf,
temp_sess_det.BEHALF_MOBILE, (temp_sess_det.type == "specimen") ? temp_sess_det.type_id : null,
(temp_sess_det.type == "specimen") ? temp_sess_det.qty : null,
((temp_sess_det.RcvType == "client") ? 1 : 0), det.APPROVE_CLIENT_NO, det.APPROVE_CLIENT_MOBILE,
(temp_sess_det.type == "specimen") ? temp_sess_det.type_id : null, (temp_sess_det.type == "specimen") ? temp_sess_det.qty : null, null, null);
}
}
else
{
if (det != null)
{
db.TRN_DCR_DET_DELETE(det.DCR_DET_NO, decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()));
}
}
}
}
foreach (string del in lstTmp)
{
Session.Remove(del);
}
return(RedirectToAction("Index"));
}
ViewBag.INSTITUTE_NO = new SelectList(db.SET_INSTITUTE, "INSTITUTE_NO", "INSTITUTE_NAME");
ViewBag.DCR_TYPE_NO = new SelectList(db.GEN_DCR_TYPE, "DCR_TYPE_NO", "DCR_TYPE");
ViewBag.TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "TRANS_TYPE_NAME");
return(View(trn_dcr));
}
