/// <summary> /// Delete Doctor Visit Data All to a date. including doctor, product, chemist and RCPA. /// </summary> /// <param name="dcractualDate"></param> /// <returns></returns> public string DeleteDoctorVisitDataAll(string dcractualDate) { string dcrCode = _objcurrentInfo.GetDCRCode(dcractualDate); string result = _objSPData.DeleteDoctorVisitDataAll(dcrCode); return(result); }
public object GetUserInstantReport(string dcrActualDate, string flag) { string companyCode = _objCurrentInfo.GetCompanyCode(); string userCode = _objCurrentInfo.GetUserCode(); string regionCode = _objCurrentInfo.GetRegionCode(); string dcrCode = _objCurrentInfo.GetDCRCode(dcrActualDate); DataSet dsDCRDetails = _objSPData.GetInstantReportDetails(companyCode, userCode, regionCode, dcrActualDate, dcrCode, flag); DataControl.JSONConverter jsonConvert = new DataControl.JSONConverter(); return(jsonConvert.Serialize(dsDCRDetails)); }
// GET: /DCRStockiestExpense/Create public ActionResult Create(string dcrDate, string dcrStatus, string entity, string travelkm, string isRCPA, string accRegions, string flag, string actvity, string cpCode, string tpCode) { string[] viewArray = new string[6]; viewArray[0] = dcrDate; viewArray[1] = dcrStatus; viewArray[2] = entity; viewArray[3] = travelkm; viewArray[4] = _objCurr.GetDCRCode(dcrDate); viewArray[5] = flag; ViewBag.isrcpa = isRCPA; ViewBag.userCode = _objCurr.GetUserCode(); ViewBag.accRegions = accRegions; ViewBag.activity = actvity; ViewBag.CPCode = cpCode; ViewBag.TPCode = tpCode; ViewBag.viewArray = viewArray; if (DataControl.CurrentInfo.IsMobile(Request.UserAgent)) { return(View("Create.Mobile")); } else { return(View()); } }
//private string _queueAccountKey = ConfigurationManager.AppSettings["ServiceBusConnection"].ToString(); //private string _topicName = ConfigurationManager.AppSettings["busDCRTopicName"].ToString(); //private string _subscriptionName = ConfigurationManager.AppSettings["busDCRSubscriptionName"].ToString(); #endregion Private Variables public ActionResult Index(string dcrDate, string dcrStatus, string entity, string travelkm, string isRCPA, string flag, string actvity, string cpCode, string tpCode, string isThereAnyOneDoctorSavedA) { string[] viewArray = new string[6]; string cvforPrefill = string.Empty; viewArray[0] = dcrDate; viewArray[1] = dcrStatus; viewArray[2] = entity; viewArray[3] = travelkm; viewArray[4] = _objCurr.GetDCRCode(dcrDate); viewArray[5] = flag; ViewBag.isrcpa = isRCPA; ViewBag.userCode = _objCurr.GetUserCode(); ViewBag.activity = actvity; ViewBag.CPCode = cpCode; ViewBag.TPCode = tpCode; ViewBag.viewArray = viewArray; cvforPrefill = GetConfigvalues(); ViewBag.PrefillCV = cvforPrefill; ViewBag.CompanyCode = _objCurr.GetCompanyCode(); ViewBag.User_Code = _objCurr.GetUserCode(); ViewBag.Region_Code = _objCurr.GetRegionCode(); ViewBag.isThereAnyOneDoctorSavedA = isThereAnyOneDoctorSavedA; if (DataControl.CurrentInfo.IsMobile(Request.UserAgent)) { return(View("Index.Mobile")); } else { return(View()); } }
public JsonResult GetHeaderDetails(string dcrStatus, string dcrDate, string source, string flag) { DataSet dsPreFill = new DataSet(); DataSet dsSFC = new DataSet(); List <Models.DCRHeaderModel> lstPreFillData = new List <Models.DCRHeaderModel>(); List <Models.DCRHeaderModel> lstIntermediate = new List <Models.DCRHeaderModel>(); List <Models.DCRAttendance> lstAttendance = new List <Models.DCRAttendance>(); try { _objData.OpenConnection(_objCurr.GetCompanyCode()); { dsPreFill = _objData.ExecuteDataSet("exec SP_hdGetHeaderPrefillData '" + _objCurr.GetCompanyCode() + "','" + _objCurr.GetUserCode() + "','" + dcrStatus + "','" + dcrDate + "','" + _objCurr.GetDCRCode(dcrDate) + "','" + source + "','" + flag + "'"); } } finally { _objData.CloseConnection(); } #region Generate Prefill Json if (dsPreFill.Tables.Count > 0) { if (dsPreFill.Tables[0].Rows.Count > 0) { #region drafted string accName = ""; string accRegion = ""; // For unapproved or drafted DCR, it will select the saved data from dcr master. if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB") { if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString()))) { accName = dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString()))) { accName += dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString()))) { accName += dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString()))) { accName += dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString() + "^"; } //accompanist region if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString()))) { accRegion = dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString()))) { accRegion += dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString()))) { accRegion += dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString() + "^"; } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString()))) { accRegion += dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString() + "^"; } } _objData.OpenConnection(_objCurr.GetCompanyCode()); { // dsSFC = _objData.ExecuteDataSet("exec SP_hdGetAccompanistCodeAndSFCData '" + _objCurr.GetCompanyCode() + "','" + accName + "','" + _objCurr.GetRegionCode() + "','" + _objCurr.GetUserTypeCode() + "'"); dsSFC = _objData.ExecuteDataSet("exec SP_hdGetAccompanistCodeAndSFCData '" + _objCurr.GetCompanyCode() + "','" + accName + "','" + accRegion + "','" + _objCurr.GetRegionCode() + "','" + _objCurr.GetUserTypeCode() + "'"); } _objData.CloseConnection(); #endregion drafted } if (flag.ToUpper() == "A") { if (dsPreFill.Tables[2].Rows.Count > 0) { DataTable dt = new DataTable(); dt = dsPreFill.Tables[2]; if (dcrStatus == "1" && source != "TAB") { lstAttendance = (from item in dt.AsEnumerable() select new Models.DCRAttendance() { Activity_Name = item["Activity_Name"].ToString(), Activity_Code = item["Activity_Code"].ToString(), Project_Code = item["Project_Code"].ToString(), Start_Time = "", End_Time = "", Remarks = "", Category = item["Expense_Entity_Code"].ToString() }).ToList <Models.DCRAttendance>(); } else if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB") { lstAttendance = (from item in dt.AsEnumerable() select new Models.DCRAttendance() { Activity_Name = item["Activity_Name"].ToString(), Activity_Code = item["Activity_Code"].ToString(), Project_Code = item["Project_Code"].ToString(), Start_Time = item["Start_Time"].ToString(), End_Time = item["End_Time"].ToString(), Remarks = item["Remarks"].ToString() }).ToList <Models.DCRAttendance>(); } } } } #region drafted // For unapproved or drafted DCR, it will select the saved data from dcr master. if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB") { DataRow[] dr; dsPreFill.Tables[0].Columns.Add("Acc1_Code", typeof(string)); dsPreFill.Tables[0].Columns.Add("Acc2_Code", typeof(string)); dsPreFill.Tables[0].Columns.Add("Acc3_Code", typeof(string)); dsPreFill.Tables[0].Columns.Add("Acc4_Code", typeof(string)); if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString()))) { dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc1_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc1_Code"] = dr[0]["Region_Code"].ToString(); } } else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString()))) { dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc1_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc1_Code"] = dr[0]["Region_Code"].ToString(); } } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString()))) { dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc2_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc2_Code"] = dr[0]["Region_Code"].ToString(); } } else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString()))) { dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc2_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc2_Code"] = dr[0]["Region_Code"].ToString(); } } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString()))) { dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc3_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc3_Code"] = dr[0]["Region_Code"].ToString(); } } else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString()))) { dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc3_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc3_Code"] = dr[0]["Region_Code"].ToString(); } } if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString()))) { dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc4_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc4_Code"] = dr[0]["Region_Code"].ToString(); } } else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString()))) { dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString() + "'"); if (dr.Length > 0) { dsPreFill.Tables[0].Rows[0]["Acc4_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")"; dsPreFill.Tables[0].Rows[0]["Acc4_Code"] = dr[0]["Region_Code"].ToString(); } } DataTable dt = new DataTable(); dt = dsPreFill.Tables[0]; lstPreFillData = (from item in dt.AsEnumerable() select new Models.DCRHeaderModel() { Work_Place = item["Place_Worked"].ToString().ToUpper(), Category_Name = item["Category"].ToString(), From_Place = item["From_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""), To_Place = item["To_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""), Travel_Mode = item["Travel_Mode"].ToString(), Distance = item["Travelled_Kms"].ToString(), CP_No = item["CP_Name"].ToString(), CP_Code = item["CPM_No"].ToString(), Start_Time = item["User_Start_Time"].ToString(), End_Time = item["User_End_Time"].ToString(), Acc1_Only_For_Doctor = item["Acc1_Only_For_Doctor"].ToString(), Acc1_Name = item["Acc1_Name"].ToString(), Acc1_Code = item["Acc1_Code"].ToString(), Acc1_Start_Time = item["Accomp_Start_Time"].ToString(), Acc1_End_Time = item["Accomp_End_Time"].ToString(), Acc2_Name = item["Acc2_Name"].ToString(), Acc2_Code = item["Acc2_Code"].ToString(), Acc2_Start_Time = item["Acc2_Start_Time"].ToString(), Acc2_End_Time = item["Acc2_End_Time"].ToString(), Acc2_Only_For_Doctor = item["Acc2_Only_For_Doctor"].ToString(), Acc3_Name = item["Acc3_Person"].ToString(), Acc3_Code = item["Acc3_Code"].ToString(), Acc3_Start_Time = item["Acc3_Time"].ToString(), Acc3_Only_For_Doctor = item["Acc3_Only_For_Doctor"].ToString(), Acc4_Name = item["Acc4_Person"].ToString(), Acc4_Code = item["Acc4_Code"].ToString(), Acc4_Start_Time = item["Acc4_Time"].ToString(), Acc4_Only_For_Doctor = item["Acc4_Only_For_Doctor"].ToString(), Category = item["Entity_Code"].ToString(), Distance_Fare_Code = item["Distance_Fare_code"].ToString(), Route_Way = item["Route_Way"].ToString(), UnApprovalReason = item["Unapproval_Reason"].ToString(), UnApproveBy = item["Approved_By"].ToString(), TPDeviation = item["TP_Deviation"].ToString(), CPDeviation = item["CP_Deviation"].ToString(), Tp_Code = item["TP_Code"].ToString() }).ToList <Models.DCRHeaderModel>(); // Intermediate place if (dsPreFill.Tables[1].Rows.Count > 0) { DataTable dt1 = new DataTable(); dt1 = dsPreFill.Tables[1]; lstIntermediate = (from item in dt1.AsEnumerable() select new Models.DCRHeaderModel() { From_Place = item["From_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""), To_Place = item["To_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""), Distance = item["Distance"].ToString(), Travel_Mode = item["Travel_Mode"].ToString(), Distance_Fare_Code = item["Distance_Fare_Code"].ToString(), Route_Way = item["Route_Way"].ToString() }).ToList <Models.DCRHeaderModel>(); } } #endregion drafted List <JsonResult> lstPreFill; if (flag == "A") { lstPreFill = new List <JsonResult> { Json(lstPreFillData, JsonRequestBehavior.AllowGet), Json(lstIntermediate, JsonRequestBehavior.AllowGet), Json(lstAttendance, JsonRequestBehavior.AllowGet) }; } else { lstPreFill = new List <JsonResult> { Json(lstPreFillData, JsonRequestBehavior.AllowGet), Json(lstIntermediate, JsonRequestBehavior.AllowGet) }; } return(Json(lstPreFill, JsonRequestBehavior.AllowGet)); #endregion Generate Prefill Json }
// GET: /DCRLeaveEntry/Create public ActionResult Create(string dcrDate, string dcrStatus) { ViewBag.leaveType = GetLeaveType(dcrDate); ViewBag.Company_Code = _objCurr.GetCompanyCode(); ViewBag.Region_Code = _objCurr.GetRegionCode(); ViewBag.User_Name = _objCurr.GetUserName(); string[] viewArray = new string[3]; viewArray[0] = dcrDate; viewArray[1] = dcrStatus; viewArray[2] = _objCurr.GetDCRCode(dcrDate); ViewBag.viewArray = viewArray; DataSet ds = new DataSet(); if (dcrStatus == "1") { //SP_hdGetTPLeaveForDCR try { _objData.OpenConnection(_objCurr.GetCompanyCode()); { ds = _objData.ExecuteDataSet("exec SP_hdGetTPLeaveForDCR '" + _objCurr.GetCompanyCode() + "','" + dcrDate + "','" + _objCurr.GetUserCode() + "'"); } } finally { _objData.CloseConnection(); } } if (dcrStatus == "0") { //SP_hdGetTPLeaveForDCR try { _objData.OpenConnection(_objCurr.GetCompanyCode()); { ds = _objData.ExecuteDataSet("exec SP_hdGetUnapprovedDCRLeave '" + _objCurr.GetCompanyCode() + "','" + dcrDate + "','" + _objCurr.GetUserCode() + "'"); } } finally { _objData.CloseConnection(); } } string remarks = string.Empty, typeCode = string.Empty; if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { remarks = ds.Tables[0].Rows[0]["Remarks"].ToString(); typeCode = ds.Tables[0].Rows[0]["Activity_Code"].ToString(); } ViewBag.remarks = remarks; ViewBag.typeCode = typeCode; if (DataControl.CurrentInfo.IsMobile(Request.UserAgent)) { return(View("Create.Mobile")); } return(View()); }