public ActionResult Edit(TRN_DCR trn_dcr)
{
if (ModelState.IsValid)
{
db.TRN_DCR.Attach(trn_dcr);
db.ObjectStateManager.ChangeObjectState(trn_dcr, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.APPROVE_TYPE_NO = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE", trn_dcr.APPROVE_TYPE_NO);
ViewBag.DCR_TYPE_NO = new SelectList(db.GEN_DCR_TYPE, "DCR_TYPE_NO", "DCR_TYPE", trn_dcr.DCR_TYPE_NO);
ViewBag.USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.USER_NO);
ViewBag.AGENT_USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.AGENT_USER_NO);
ViewBag.REF_ZM_USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.REF_ZM_USER_NO);
ViewBag.DIVISION_NO = new SelectList(db.SET_DIVISION, "DIVISION_NO", "LAST_ACTION", trn_dcr.DIVISION_NO);
ViewBag.FY_NO = new SelectList(db.SET_FISCAL_YEAR, "FY_NO", "LAST_ACTION", trn_dcr.FY_NO);
ViewBag.INSTITUTE_NO = new SelectList(db.SET_INSTITUTE, "INSTITUTE_NO", "LAST_ACTION", trn_dcr.INSTITUTE_NO);
ViewBag.THANA_NO = new SelectList(db.SET_THANA, "THANA_NO", "LAST_ACTION", trn_dcr.THANA_NO);
ViewBag.WORK_PUR_NO = new SelectList(db.SET_WORK_PURPOSE, "WORK_PUR_NO", "LAST_ACTION", trn_dcr.WORK_PUR_NO);
ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA, "ZILLA_NO", "LAST_ACTION", trn_dcr.ZILLA_NO);
ViewBag.ZONE_NO = new SelectList(db.SET_ZONE, "ZONE_NO", "LAST_ACTION", trn_dcr.ZONE_NO);
ViewBag.TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "LAST_ACTION", trn_dcr.TRANS_TYPE_NO);
ViewBag.APPROVE_TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "LAST_ACTION", trn_dcr.APPROVE_TRANS_TYPE_NO);
return(View(trn_dcr));
}
public JsonResult getDetailsWithoutButtons(decimal typeID)
{
string ret = "";
TRN_DCR dcr = db.TRN_DCR.Where(s => s.DCR_NO == typeID).First();
ret += (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "MP") ?
"<thead id=\"theadsdmp\"><tr><td>Item</td><td>Qty</td><td>Whom?</td><td>Contact</td><td>On Behalf?</td><td>Mobile</td></tr></thead>" :
"<thead id=\"theadsdmp\"><tr><td>Contact No</td><td>Type</td></tr></thead>";
IList <TRN_DCR_DET> dets = db.TRN_DCR_DET.Where(s => s.DCR_NO == typeID).ToList();
foreach (TRN_DCR_DET dt in dets)
{
if (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "TC" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "LC")
{
string tmCell = ((dt.IS_FOR_TEACHER == 1) ? dt.TEACHER_MOBILE : dt.CLIENT_MOBILE);
ret += "<tr id='" + dcr.GEN_DCR_TYPE.DCR_TYPE_CODE.ToLower() + "-" + tmCell
+ "'><td>" + tmCell + "</td><td>" + ((dt.IS_FOR_TEACHER == 1) ? "Teacher" : "Client") + "</td>"
+ "<td></td></tr>";
}
else if (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "MP")
{
decimal?tpID = ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? dt.SPECIMEN_NO : dt.PROMO_ITEM_NO);
string forWhom = (dt.IS_FOR_TEACHER == 1) ? "Teacher" : "Client";
string tmName = (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ?
((tpID != null) ? db.SET_SPECIMEN.Where(s => s.SPECIMEN_NO == tpID).Single().SPECIMEN_CODE : "") :
((tpID != null) ? db.SET_PROMO_ITEM.Where(s => s.PROMO_ITEM_NO == tpID).Single().PROMO_ITEM_CODE : "");
decimal?Qty = ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? dt.SPECIMEN_QTY : dt.PROMO_ITEM_QTY);
string WhomCell = ((forWhom == "Teacher") ? dt.TEACHER_MOBILE : dt.CLIENT_MOBILE);
ret += "<tr id='" + ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? "specimen" : "promotion") + "-" + tpID +
"'><td>" + tmName + "</td><td>" + Qty + "<td></td>" + forWhom + "</td><td>" + WhomCell + "</td><td>" +
((dt.IS_ON_BEHALF == 1) ? "Yes" : "No") + "</td><td>" + ((dt.IS_ON_BEHALF == 1) ? dt.BEHALF_MOBILE : "") + "</td><td></td></tr>";
}
}
return(Json(new { html = ret }, JsonRequestBehavior.AllowGet));
}
/**
* WServices starting
**/
public JsonResult getOnePrevData(int?id)
{
TRN_DCR trndcr = db.TRN_DCR.Single(t => t.DCR_NO == id);
/*JavaScriptSerializer TheSerializer = new JavaScriptSerializer();
* return TheSerializer.Serialize(trn_user_specimen);*/
return(Json(new
{
dcrNO = trndcr.DCR_NO,
typeNo = trndcr.GEN_DCR_TYPE.DCR_TYPE_NO,
userName = trndcr.SEC_USERS.USER_NAME,
userNo = trndcr.SEC_USERS.USER_NO,
ref_zm_mobile = trndcr.REF_ZM_MOBILE,
is_ref = trndcr.IS_REF_ZM,
date = trndcr.TRN_DCR_DATE.ToString("yyyy-MM-dd"),
startLoc = trndcr.WORK_AREA_FROM_NAME,
endLoc = trndcr.WORK_AREA_TO_NAME,
startTime = Convert.ToDateTime(trndcr.TIME_FROM).ToString("HH:mm"),
endTime = Convert.ToDateTime(trndcr.TIME_TO).ToString("HH:mm"),
transport = trndcr.TRANS_TYPE_NO,
cost = trndcr.FARE_AMT,
instituteNo = (trndcr.INSTITUTE_NO != null)?trndcr.INSTITUTE_NO:0,
institute = (trndcr.INSTITUTE_NO != null)? trndcr.SET_INSTITUTE.INSTITUTE_NAME:""
}, JsonRequestBehavior.AllowGet));
}
//
// GET: /DCR/Create
/*public ActionResult Create()
* {
* 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();
* }*/
public ActionResult Create(decimal?id)
{
TRN_DCR trnDcr = (id != null)? db.TRN_DCR.Where(s => s.DCR_NO == id).First():new TRN_DCR();
/*ViewBag.jsmsg = (id != null) ? "<script type='text/javascript' language='javascript'>setEdit(" + id + "," + trnDcr.GEN_DCR_TYPE.DCR_TYPE_NO + "," +
* trnDcr.SEC_USERS.USER_NAME + "," + trnDcr.USER_NO + ","
+ trnDcr.IS_REF_ZM + "," + ((trnDcr.REF_ZM_MOBILE == null) ? "0" : trnDcr.REF_ZM_MOBILE) + "," + trnDcr.TRN_DCR_DATE.ToString("yyyy-MM-dd") +
+ "," + trnDcr.WORK_AREA_FROM_NAME + "," + trnDcr.WORK_AREA_TO_NAME + "," + Convert.ToDateTime(trnDcr.TIME_FROM).ToString("HH-mm") +
+ "," + Convert.ToDateTime(trnDcr.TIME_TO).ToString("HH-mm") + "," + trnDcr.TRANS_TYPE_NO + "," + trnDcr.FARE_AMT + "," + trnDcr.SET_INSTITUTE.INSTITUTE_NAME +
+ "," + trnDcr.INSTITUTE_NO + "); </script>" : "";*/
List <string> lstTmp = new List <string>();
foreach (string crntSession in Session)
{
if (crntSession.Contains("DCREntry"))
{
lstTmp.Add(crntSession);
}
}
foreach (string tmp in lstTmp)
{
Session.Remove(tmp);
}
ViewBag.jsmsg = (id != null) ? "<script type='text/javascript' language='javascript'>setEdit(" + id + "); </script>"
: "";
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());
}
public JsonResult DcrEdit(TRN_DCR trn_dcr)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
db.TRN_DCR_DO_APPROVE(trn_dcr.DCR_NO, 1, USER_NO, LOGON_NO, null, null,
trn_dcr.TRANS_TYPE_NO, trn_dcr.APPROVE_FARE_AMT);
return(Json(new { msg = "success" }));
}
//
// GET: /DCR/Details/5
public ActionResult Details(decimal id = 0)
{
TRN_DCR trn_dcr = db.TRN_DCR.Single(t => t.DCR_NO == id);
if (trn_dcr == null)
{
return(HttpNotFound());
}
ViewBag.jsmsg = "<script type='text/javascript'>$(document).ready(function () {setEdit(" + id + ");}); </script>";
return(View(trn_dcr));
}
//
// GET: /DCR/Delete/5
public ActionResult Delete(decimal id = 0)
{
TRN_DCR trn_dcr = db.TRN_DCR.Single(t => t.DCR_NO == id);
if (trn_dcr == null)
{
return(HttpNotFound());
}
ViewBag.jsmsg = (id != null) ? "<script type='text/javascript' language='javascript'>setEdit(" + id + "); </script>"
: "";
return(View(trn_dcr));
}
public ActionResult DeleteConfirmed(decimal id)
{
TRN_DCR trn_dcr = db.TRN_DCR.Single(t => t.DCR_NO == id);
IList <TRN_DCR_DET> dcr_dets = db.TRN_DCR_DET.Where(x => x.DCR_NO == trn_dcr.DCR_NO).ToList();
foreach (TRN_DCR_DET dt in dcr_dets)
{
db.TRN_DCR_DET_DELETE(dt.DCR_DET_NO, decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()));
}
db.TRN_DCR_DELETE(trn_dcr.DCR_NO, decimal.Parse(Session["sess_USER_NO"].ToString()),
decimal.Parse(Session["sess_LOGON_NO"].ToString()));
return(RedirectToAction("Index"));
}
public JsonResult getDetails(decimal typeID)
{
string ret = "";
TRN_DCR dcr = db.TRN_DCR.Where(s => s.DCR_NO == typeID).First();
ret += (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "MP") ?
"<thead id=\"theadsdmp\"><tr><td>Item</td><td>Qty</td><td>Whom?</td><td>Contact</td><td>On Behalf?</td><td>Mobile</td></tr></thead>" :
"<thead id=\"theadsdmp\"><tr><td>Contact No</td><td>Type</td></tr></thead>";
IList <TRN_DCR_DET> dets = db.TRN_DCR_DET.Where(s => s.DCR_NO == typeID).ToList();
foreach (TRN_DCR_DET dt in dets)
{
if (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "TC" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "LC")
{
string tmCell = ((dt.IS_FOR_TEACHER == 1) ? dt.TEACHER_MOBILE : dt.CLIENT_MOBILE);
ret += "<tr id='" + dcr.GEN_DCR_TYPE.DCR_TYPE_CODE.ToLower() + "-" + tmCell
+ "'><td>" + tmCell + "</td><td>" + ((dt.IS_FOR_TEACHER == 1) ? "Teacher" : "Client") + "</td>"
+ "<td><input value=\"Remove\" id=\"btnRemove\" class=\"btn btn-danger\" onclick=\"removeDCRDet($(this).closest('tr').attr('id'));$(this).closest('tr').remove();\" type=\"button\"></td></tr>";
SaveDCROthersOnSession(dcr.GEN_DCR_TYPE.DCR_TYPE_CODE.ToLower(), (dt.IS_FOR_TEACHER == 1) ? dt.TEACHER_NO : dt.CLIENT_NO,
tmCell, (dt.IS_FOR_TEACHER == 1)?"teacher":"client", dt.DCR_DET_NO);
}
else if (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD" || dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "MP")
{
decimal?tpID = ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? dt.SPECIMEN_NO : dt.PROMO_ITEM_NO);
string forWhom = (dt.IS_FOR_TEACHER == 1)?"Teacher":"Client";
string tmName = (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ?
((tpID != null) ? db.SET_SPECIMEN.Where(s => s.SPECIMEN_NO == tpID).Single().SPECIMEN_CODE : "") :
((tpID != null) ? db.SET_PROMO_ITEM.Where(s => s.PROMO_ITEM_NO == tpID).Single().PROMO_ITEM_CODE : "");
decimal?Qty = ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? dt.SPECIMEN_QTY : dt.PROMO_ITEM_QTY);
string WhomCell = ((forWhom == "Teacher")?dt.TEACHER_MOBILE:dt.CLIENT_MOBILE);
ret += "<tr id='" + ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? "specimen" : "promotion") + "-" + tpID +
"'><td>" + tmName + "</td><td>" + Qty + "<td></td>" + forWhom + "</td><td>" + WhomCell + "</td><td>" +
((dt.IS_ON_BEHALF == 1)?"Yes":"No") + "</td><td>" + ((dt.IS_ON_BEHALF == 1)?dt.BEHALF_MOBILE:"") + "</td><td>" +
"<input value=\"Edit\" id=\"btnEdit\" class=\"btn btn-warning\" onclick=\"editDCRDET($(this).closest('tr').attr('id'));\" type=\"button\">" +
"<input value=\"Remove\" id=\"btnRemove\" class=\"btn btn-danger\" onclick=\"removeDCRDet($(this).closest('tr').attr('id'));\" type=\"button\"></td></tr>";
SaveDCROnSession(tpID, Qty, ((dcr.GEN_DCR_TYPE.DCR_TYPE_CODE == "SD") ? "specimen" : "promotion"), dt.TEACHER_NO, dt.IS_ON_BEHALF, WhomCell, dt.BEHALF_MOBILE, forWhom, dt.DCR_DET_NO);
}
}
return(Json(new { html = ret }, JsonRequestBehavior.AllowGet));
}
//
// GET: /DCR/Edit/5
public ActionResult Edit(decimal id = 0)
{
TRN_DCR trn_dcr = db.TRN_DCR.Single(t => t.DCR_NO == id);
if (trn_dcr == null)
{
return(HttpNotFound());
}
ViewBag.APPROVE_TYPE_NO = new SelectList(db.GEN_APPROVE_TYPE, "APPROVE_TYPE_NO", "APPROVE_TYPE", trn_dcr.APPROVE_TYPE_NO);
ViewBag.DCR_TYPE_NO = new SelectList(db.GEN_DCR_TYPE, "DCR_TYPE_NO", "DCR_TYPE", trn_dcr.DCR_TYPE_NO);
ViewBag.USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.USER_NO);
ViewBag.AGENT_USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.AGENT_USER_NO);
ViewBag.REF_ZM_USER_NO = new SelectList(db.SEC_USERS, "USER_NO", "LAST_ACTION", trn_dcr.REF_ZM_USER_NO);
ViewBag.DIVISION_NO = new SelectList(db.SET_DIVISION, "DIVISION_NO", "LAST_ACTION", trn_dcr.DIVISION_NO);
ViewBag.FY_NO = new SelectList(db.SET_FISCAL_YEAR, "FY_NO", "LAST_ACTION", trn_dcr.FY_NO);
ViewBag.INSTITUTE_NO = new SelectList(db.SET_INSTITUTE, "INSTITUTE_NO", "LAST_ACTION", trn_dcr.INSTITUTE_NO);
ViewBag.THANA_NO = new SelectList(db.SET_THANA, "THANA_NO", "LAST_ACTION", trn_dcr.THANA_NO);
ViewBag.WORK_PUR_NO = new SelectList(db.SET_WORK_PURPOSE, "WORK_PUR_NO", "LAST_ACTION", trn_dcr.WORK_PUR_NO);
ViewBag.ZILLA_NO = new SelectList(db.SET_ZILLA, "ZILLA_NO", "LAST_ACTION", trn_dcr.ZILLA_NO);
ViewBag.ZONE_NO = new SelectList(db.SET_ZONE, "ZONE_NO", "LAST_ACTION", trn_dcr.ZONE_NO);
ViewBag.TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "LAST_ACTION", trn_dcr.TRANS_TYPE_NO);
ViewBag.APPROVE_TRANS_TYPE_NO = new SelectList(db.SET_TRANSPORT_TYPE, "TRANS_TYPE_NO", "LAST_ACTION", trn_dcr.APPROVE_TRANS_TYPE_NO);
return(View(trn_dcr));
}
public JsonResult getDCRDetails(decimal dcrNo)
{
TRN_DCR dcr = db.TRN_DCR.Where(x => x.DCR_NO == dcrNo).First();
string tmp = "";
if (dcr.IS_REF_ZM.HasValue)
{
if (dcr.IS_REF_ZM == 1)
{
tmp += "<b>Ref</b></td><td>" + dcr.REF_ZM_MOBILE;
}
}
string ret = @"<table class='table table-responsive' style='width:95%;margin-left:auto;'><tbody>
<tr><td><b>Work Type</b></td><td>" + dcr.GEN_DCR_TYPE.DCR_TYPE + "</td><td></td></tr>" +
"<tr><td><b>ZM</b></td><td>" + dcr.SEC_USERS.USER_FULL_NAME + "(" + dcr.SEC_USERS.USER_MOBILE + ")" + "</td><td>" + tmp + "</td><td></td></tr>" +
"<tr><td><b>Date</b></td><td>" + dcr.TRN_DCR_DATE.ToString("yyyy-MM-dd") + "</td><td></td></tr>" +
"<tr><td><b>Start Location</b></td><td>" + dcr.WORK_AREA_FROM_NAME + "</td><td><b>End Location</b></td><td>" + dcr.WORK_AREA_TO_NAME + "</td></tr>" +
"<tr><td><b>Start Time</b></td><td>" + DateTime.Parse(dcr.TIME_FROM.ToString()).ToShortTimeString() + "</td><td><b>End Location</b></td><td>" + DateTime.Parse(dcr.TIME_TO.ToString()).ToShortTimeString() + "</td></tr>" +
"<tr><td><b>Transport</b></b></td><td>" + dcr.SET_TRANSPORT_TYPE.TRANS_TYPE_NAME + "</td><td><b>Cost/Fare</b></td><td>" + dcr.FARE_AMT.ToString() + "</td></tr>" +
"<tr><td><b>Institute</b></td><td>" + ((dcr.SET_INSTITUTE != null) ? dcr.SET_INSTITUTE.INSTITUTE_NAME : "") +
"</td><td></td></tr></tbody></table><br/>";
ret += "<table class=\"table table-responsive\" style=\"width:95%;margin-left:auto;\">";
IList <TRN_DCR_DET> dcr_dets = db.TRN_DCR_DET.Where(x => x.DCR_NO == dcrNo).ToList();
if (dcr_dets.Count != 0)
{
switch (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE)
{
case "TC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
ret += "<tr><td>" + dts.TEACHER_MOBILE + "</td><td>" + "Teacher" + "</td></tr>";
}
break;
case "LC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_teacher = true;
if (dts.IS_FOR_CLIENT != null)
{
if (dts.IS_FOR_CLIENT == 1)
{
is_teacher = false;
}
}
ret += "<tr><td>" + ((!is_teacher) ? dts.CLIENT_MOBILE : dts.TEACHER_MOBILE) + "</td><td>" + ((!is_teacher) ? "Client" : "Teacher") + "</td></tr>";
}
break;
case "SD":
case "CSR":
ret += "<tr><th>Item</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_SPECIMEN.SPECIMEN_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_SPECIMEN.SPECIMEN_NAME + "</td><td>" + dts.SPECIMEN_QTY + "</td>" +
"<td>" + dts.TEACHER_MOBILE + "</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "-") + "</td></tr>";
}
break;
case "MP":
ret += "<tr><th>Item</th><th>Whom</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_PROMO_ITEM.PROMO_ITEM_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_PROMO_ITEM.PROMO_ITEM_NAME + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? "Teacher" : "Client") + "</td><td>" +
dts.PROMO_ITEM_QTY + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? dts.TEACHER_MOBILE : dts.CLIENT_MOBILE) +
"</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "") + "</td></tr>";
}
break;
default:
ret += "";
break;
}
}
ret += "</table>";
return(Json(new { html = ret }, JsonRequestBehavior.AllowGet));;
}
public JsonResult getDCRDetailsEditable(decimal dcrNo)
{
TRN_DCR dcr = db.TRN_DCR.Where(x => x.DCR_NO == dcrNo).First();
string tmp = "";
if (dcr.IS_REF_ZM.HasValue)
{
if (dcr.IS_REF_ZM == 1)
{
tmp += "<b>Ref</b></td><td>" + dcr.REF_ZM_MOBILE;
}
}
string ret = @"<table class='table table-responsive' style='width:95%;margin-left:auto;'><tbody>
<tr><td><b>Work Type</b></td><td>" + dcr.GEN_DCR_TYPE.DCR_TYPE + "</td><td></td></tr>" +
"<tr><td><b>ZM</b></td><td>" + dcr.SEC_USERS.USER_FULL_NAME + "(" + dcr.SEC_USERS.USER_MOBILE + ")" + "</td><td>" + tmp + "</td><td></td></tr>" +
"<tr><td><b>Date</b></td><td>" + dcr.TRN_DCR_DATE.ToString("yyyy-MM-dd") + "</td><td></td></tr>" +
"<tr><td><b>Start Location</b></td><td>" + dcr.WORK_AREA_FROM_NAME + "</td><td><b>End Location</b></td><td>" + dcr.WORK_AREA_TO_NAME + "</td></tr>" +
"<tr><td><b>Start Time</b></td><td>" + DateTime.Parse(dcr.TIME_FROM.ToString()).ToShortTimeString() + "</td><td><b>End Location</b></td><td>" + DateTime.Parse(dcr.TIME_TO.ToString()).ToShortTimeString() + "</td></tr>" +
"<tr><td><b>Transport</b></b></td><td>" + dcr.SET_TRANSPORT_TYPE.TRANS_TYPE_NAME + "</td><td><b>Cost/Fare</b></td><td>" + dcr.FARE_AMT.ToString() + "</td></tr>" +
"<tr><td><b>Institute</b></td><td>" + ((dcr.SET_INSTITUTE != null) ? dcr.SET_INSTITUTE.INSTITUTE_NAME : "") +
"</td><td></td></tr></tbody></table><br/>";
ret += "<table class=\"table table-responsive\" style=\"width:95%;margin-left:auto;\">";
IList <TRN_DCR_DET> dcr_dets = db.TRN_DCR_DET.Where(x => x.DCR_NO == dcrNo).ToList();
if (dcr_dets.Count != 0)
{
switch (dcr.GEN_DCR_TYPE.DCR_TYPE_CODE)
{
case "TC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
ret += "<tr><td>" + dts.TEACHER_MOBILE + "</td><td>" + "Teacher" + "</td></tr>";
}
break;
case "LC":
ret += "<tr><th>Contact No</th><th>Type</th></tr>";
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_teacher = true;
if (dts.IS_FOR_CLIENT != null)
{
if (dts.IS_FOR_CLIENT == 1)
{
is_teacher = false;
}
}
ret += "<tr><td>" + ((!is_teacher) ? dts.CLIENT_MOBILE : dts.TEACHER_MOBILE) + "</td><td>" + ((!is_teacher) ? "Client" : "Teacher") + "</td></tr>";
}
break;
case "CSR":
case "SD":
SEC_USERS_LOGIN_Result1 usertp = (SEC_USERS_LOGIN_Result1)Session["sess_sec_users"];
decimal tmpdet = decimal.Parse(usertp.USER_TYPE_NO.ToString());
GEN_USER_TYPES gentype = db.GEN_USER_TYPES.Single(x => x.USER_TYPE_NO == tmpdet);
ret += "<tr><th>Item</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th><th></th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_SPECIMEN.SPECIMEN_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_SPECIMEN.SPECIMEN_NAME + "</td><td>" +
((gentype.IS_ADMIN == 1) ? "<input id='txtsdup" + dts.DCR_DET_NO + "' type='text' class='form-control input-small' value='" + dts.APPROVE_SPECIMEN_QTY + "'></input>" : dts.APPROVE_SPECIMEN_QTY.ToString()) +
"</td><td>" + dts.TEACHER_MOBILE + "</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "-") + "</td><td>" +
((gentype.IS_ADMIN == 1) ? "<button class='btn btn-warning btn-small btnupdate' attr='" + dts.DCR_DET_NO + "' onclick='changeSDonApprove($(this));'>Edit</button>" : "") + "</td></tr>";
}
break;
case "MP":
ret += "<tr><th>Item</th><th>Whom</th><th>Qty</th><th>Contact</th><th>On Behalf?</th><th>On Behalf Mobile No</th></tr>";
dcr_dets = dcr_dets.OrderByDescending(x => x.SET_PROMO_ITEM.PROMO_ITEM_NAME).Reverse().ToList();
foreach (TRN_DCR_DET dts in dcr_dets)
{
bool is_behalf = true;
if (dts.IS_ON_BEHALF != null)
{
if (dts.IS_ON_BEHALF != 1)
{
is_behalf = false;
}
}
ret += "<tr><td>" + dts.SET_PROMO_ITEM.PROMO_ITEM_NAME + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? "Teacher" : "Client") + "</td><td>" +
dts.PROMO_ITEM_QTY + "</td><td>" + ((dts.IS_FOR_TEACHER == 1) ? dts.TEACHER_MOBILE : dts.CLIENT_MOBILE) +
"</td><td>" + ((is_behalf) ? "Yes" : "No") + "</td><td>" +
((is_behalf) ? dts.BEHALF_MOBILE : "") + "</td></tr>";
}
break;
default:
ret += "";
break;
}
}
ret += "</table>";
return(Json(new { html = ret }, JsonRequestBehavior.AllowGet));
}
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));
}
