public ActionResult PSAndSSSalesEntry(string Lid)
{
//string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
//ParameterMode obj = Newtonsoft.Json.JsonConvert.DeserializeObject<ParameterMode>(parameters);
if (Lid == null)
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "No";
}
else
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
MVCModels.PSAndSSSalesEntry.ParameterMode dd = Newtonsoft.Json.JsonConvert.DeserializeObject <MVCModels.PSAndSSSalesEntry.ParameterMode>(parameters);
ViewBag.subDomainName = dd.SubDomain_Name;
ViewBag.CompanyCode = dd.Company_Code;
ViewBag.LoginRegionCode = dd.Region_Code;
ViewBag.LoginUserCode = dd.User_Code;
ViewBag.CompanyId = dd.Company_Id;
ViewBag.IsResponsive = "YES";
}
return(View());
}
public ActionResult DoctorsReason(string Lid)
{
if (Lid == null)
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
//ViewBag.SelectedRegionCode = _objCurrentInfo.GetSRegionCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "NO";
}
else
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
MVCModels.DoctorMissedReason.ParameterMode dd = Newtonsoft.Json.JsonConvert.DeserializeObject <MVCModels.DoctorMissedReason.ParameterMode>(parameters);
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
//ViewBag.SelectedRegionCode = _objCurrentInfo.GetSRegionCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "YES";
}
return(View());
}
public ActionResult OrderProcessing(string Lid)
{
if (Lid == null)
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.RegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.UserCode = _objCurrentInfo.GetUserCode();
ViewBag.Company_Id = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "No";
System.Web.HttpContext.Current.Session["IsResponsive"] = "No";
}
else
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
ParameterMode dd = Newtonsoft.Json.JsonConvert.DeserializeObject <ParameterMode>(parameters);
ViewBag.subDomainName = dd.SubDomain_Name;
ViewBag.CompanyCode = dd.Company_Code;
ViewBag.RegionCode = dd.Region_Code;
ViewBag.UserCode = dd.User_Code;
ViewBag.Company_Id = dd.Company_Id;
ViewBag.IsResponsive = "Yes";
System.Web.HttpContext.Current.Session["IsResponsive"] = "Yes";
}
return(View());
}
public ActionResult BatchCreation()
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
return(View());
}
public ActionResult SFCRegion(string SFCVersion)
{
ViewBag.SFCVersion = "Y";
ViewBag.FromDate = DateTime.Now.AddDays(1).ToString("dd/MM/yyyy");
ViewBag.Todate = "31/12/2099";
ViewBag.Region_Code = _objcurrentInfo.GetRegionCode();
return(View());
}
/// <summary>
/// Method to bind the data with HtmlCycleMaster Table
/// </summary>
/// <returns></returns>
public string GetCycleMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
string regionCode = _objcurrentInfo.GetRegionCode();
string strRegionCode = string.Empty;
try
{
List <CycleMasterModel> lstCycleMaster = (List <CycleMasterModel>)GetcycleMasterDetails(regionCode);
StringBuilder sb = new StringBuilder();
BLMaster objMaster = new BLMaster();
sb.Append("<table WIDTH='60%' id='tblsummary' class='table table-striped'>");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:#428bca;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Cycle Name</td>");
sb.Append("<td>Region Name</td>");
sb.Append("<td>Description</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (lstCycleMaster != null && lstCycleMaster.Count > 0)
{
int i = 0;
foreach (var lstcycle in lstCycleMaster)
{
i++;
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td style='display:none' id='Cycle_Code" + i + "'>" + lstcycle.Cycle_Code + "</td>");
sb.Append("<td id='Cycle_Name" + i + "'>" + lstcycle.Cycle_Name + "</td>");
sb.Append("<td style='display:none' id='Region_Code" + i + "'>" + lstcycle.Region_Code + "</td>");
sb.Append("<td id='Region_Name" + i + "'>" + lstcycle.Region_Name + "</td>");
sb.Append("<td style='display:none' id='Start_Date" + i + "'>" + lstcycle.Start_Date + "</td>");
sb.Append("<td style='display:none' id='End_Date" + i + "'>" + lstcycle.End_Date + "</td>");
sb.Append("<td id='Long_Description" + i + "'>" + lstcycle.Long_Description + "</td>");
sb.Append("<td id='Record_Status" + i + "'>" + lstcycle.Record_Status + "</td></tr>");
}
}
else
{
sb.Append("<span>No Records TO Display</span>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:regionCode", regionCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public ActionResult Index(string id)
{
if (!string.IsNullOrEmpty(id))
{
ViewBag.TargetCode = id;
}
ViewBag.regionCode = _objCurr.GetRegionCode();
return(View());
}
public string Index(FormCollection form)
{
string result = "";
HttpPostedFileBase file = Request.Files[0];
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
MVCModels.RCPA_Header objrcpaHeader = new MVCModels.RCPA_Header();
objrcpaHeader.Company_Id = Convert.ToInt32(_objCurInfo.GetCompanyId());
objrcpaHeader.Company_code = _objCurInfo.GetCompanyCode();
objrcpaHeader.user_code = _objCurInfo.GetUserCode();
// objrcpaHeader.Region_Code = _objCurInfo.GetRegionCode();
// objrcpaHeader.PeriodTo = DateTime.Now;
//objrcpaHeader.PeriodFrom = DateTime.Now;
try
{
DateTime dt = DateTime.ParseExact(Request.Form["txtPeriodFrom"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodFrom = Convert.ToDateTime(dt.ToString("yyyy-MM-dd"));
dt = DateTime.ParseExact(Request.Form["txtPeriodTo"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodTo = Convert.ToDateTime(dt);
objrcpaHeader.Region_Code = Request.Form["hdnRegion_Code"].ToString();
string subDomain = _objCurInfo.GetSubDomain();
result = _objBLRCPACompetator.RCPAExcelBulkAddResult(subDomain, _objCurInfo.GetCompanyCode(), _objCurInfo.GetRegionCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(), objrcpaHeader);
ViewBag.ErrorCode = result;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.RegionCode = objCurInfo.GetRegionCode();
}
catch (Exception ex)
{
result = ex.Message;
}
return(result);
}
public JsonResult CheckTPAvailableForSelectedDCRDates(string DCRDates)
{
try
{
_objSPData = new SPData();
_objcurrentInfo = new CurrentInfo();
string company_Code = _objcurrentInfo.GetCompanyCode();
string user_Code = _objcurrentInfo.GetUserCode();
string region_Code = _objcurrentInfo.GetRegionCode();
List <string> lstDCRDates = _objSPData.CheckTPAvailableForSelectedDCRDates(company_Code, user_Code, region_Code, DCRDates);
// List<string> DCR_Dates = DCRDates.Split('^').ToList();
// DCR_Dates = DCR_Dates.Where(d => d != "").ToList();
// //compare two list and return not matching items using linq
//List<string> lstDCRDatesWithoutPlan = DCR_Dates.Except(lstDCRDates).ToList();
if (lstDCRDates != null)
{
return(Json(lstDCRDates));
}
return(null);
}
catch
{
throw;
}
}
public PartialViewResult ChemistDetails()
{
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.UserCode = _objCurrentInfo.GetUserCode();
ViewBag.RegionCode = _objCurrentInfo.GetRegionCode();
return(PartialView());
}
public ActionResult NewLeaveEntry(string SSID)
{
if (!string.IsNullOrEmpty(SSID))
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(SSID));
DieticianModel obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DieticianModel>(parameters);
ViewBag.CompanyCode = obj.Company_Code;
ViewBag.RegionCode = obj.Region_Code;
ViewBag.UserCode = obj.User_Code;
ViewBag.UserTypeCode = obj.User_Type_Code;
ViewBag.UserName = obj.User_Name;
ViewBag.RegionName = obj.Region_Name;
ViewBag.latitude = obj.latitude;
ViewBag.longitude = obj.longitude;
}
else
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.Usercode = objCurInfo.GetUserCode();
ViewBag.RegionCode = objCurInfo.GetRegionCode();
ViewBag.UserTypecode = objCurInfo.GetUserTypeCode();
ViewBag.UserName = objCurInfo.GetUserName();
}
return(View());
}
public ActionResult OBOUserRegionMapping()
{
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
ViewBag.Cur_Region_Code = _objcurrentInfo.GetRegionCode();
ViewBag.Cur_User_Code = _objcurrentInfo.GetUserCode();
return(View());
}
//
// GET: /Organogram/Create
public ActionResult Create()
{
ViewBag.Cur_Region_Code = _objcurrentInfo.GetRegionCode();
ViewBag.Cur_User_Code = _objcurrentInfo.GetUserCode();
ViewBag.Lat = _objcurrentInfo.GetLattitude();
ViewBag.Long = _objcurrentInfo.GetLongitude();
return(View());
}
public ActionResult Index()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.RegionCode = objCurInfo.GetRegionCode();
ViewBag.ErrorCode = "";
return(View());
}
public JsonResult GetRegionTypes()
{
DAL_Reports_CategoryWiseDrVisitAnalysis objDAL = new DAL_Reports_CategoryWiseDrVisitAnalysis();
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
string companyCode = _objcurrentInfo.GetCompanyCode();
dsRegionType = objDAL.GetRegionTypes(companyCode);
DataRow[] rowFilter;
rowFilter = dsRegionType.Tables[0].Select("Region_Type_Code = Under_Region_Type");
if (rowFilter.Length > 0)
{
foreach (DataRow dr in rowFilter)
{
regionTypeLevelNo = 1;
dr["Level_No"] = regionTypeLevelNo.ToString();
dsRegionType.Tables[0].AcceptChanges();
}
foreach (DataRow dr in rowFilter)
{
GenerateRegionTypeLevel(dr["Region_Type_Code"].ToString());
}
}
DataSet ds = new DataSet();
string regionCode = string.Empty;
string regionTypeCode = string.Empty;
regionCode = _objcurrentInfo.GetRegionCode();
regionTypeCode = objDAL.GetRegionTypeCode(companyCode, regionCode);
ds = dsRegionType.Clone();
rowFilter = dsRegionType.Tables[0].Select("Region_Type_Code = '" + regionTypeCode + "'");
if (rowFilter.Length > 0)
{
regionTypeLevelNo = Convert.ToInt16(rowFilter[0]["Level_No"].ToString());
rowFilter = dsRegionType.Tables[0].Select("Level_No >= '" + regionTypeLevelNo + "'");
foreach (DataRow dr in rowFilter)
{
ds.Tables[0].ImportRow(dr);
ds.Tables[0].AcceptChanges();
}
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
try
{
string managerApprovalPri = string.Empty;
managerApprovalPri = GetpendingDCR();
int TPPendingApprovalUserCount = GetPendingApprovedTPUsersCount();
int SSPendingApprovalUserCount = GetPendingApprovedSSUsersCount();
string regionCode = _objcurrentInfo.GetRegionCode();
ViewBag.CurrentDate = System.DateTime.Now.ToShortDateString();
bool isPayRollIntegrated = _objcurrentInfo.GetPayRollIntegratedStatus();
ViewBag.isPayRollIntegrated = isPayRollIntegrated;
string unApprovedDCRConfigValue = GetUnapprovedDCRCheckConfigValue();
ViewBag.unApprovedDCRCheck = unApprovedDCRConfigValue;
string singleActivityPerDay = GetSingleActivityperday();
string LeaveEntryMode = GetLeaveEntryMode();
ViewBag.singleActivityPerDay = singleActivityPerDay;
ViewBag.LeaveEntryMode = LeaveEntryMode;
ViewBag.TPPendingApprovalUserCount = TPPendingApprovalUserCount;
ViewBag.SSPendingApprovalUserCount = SSPendingApprovalUserCount;
ViewBag.Region_Code = regionCode;
ViewBag.Company_Code = _objcurrentInfo.GetCompanyCode();
//if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
//{
// return View("Index.Mobile");
//}
//if (!string.IsNullOrEmpty(managerApprovalPri))
//{
// return View("PendingApprovalScreen");
//}
//else
//{
// return View();
//}
if (!string.IsNullOrEmpty(managerApprovalPri) || TPPendingApprovalUserCount > 0 || SSPendingApprovalUserCount > 0)
{
if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
{
return(View("PendingApprovalScreen.Mobile"));
}
return(View("PendingApprovalScreen"));;
}
else
{
if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
{
return(View("Index.Mobile"));
}
return(View());
}
}
catch
{
throw;
}
}
public ActionResult MasterDataDownload()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.UserCode = objCurInfo.GetUserCode();
ViewBag.RegionCode = objCurInfo.GetRegionCode();
ViewBag.Usercode = objCurInfo.GetUserCode();
return(View());
}
//
// GET: /Order/
public ActionResult OrderList()
{
BLUser objUser = new BLUser();
List <MVCModels.HiDoctor_Master.UserModel> lstUser = new List <MVCModels.HiDoctor_Master.UserModel>();
lstUser = objUser.GetChildUsersCodeAndNameOnly(_objCurrentInfo.GetCompanyCode(), _objCurrentInfo.GetUserCode());
ViewBag.Child_User_Count = lstUser.Count();
string strRegionCode = _objCurrentInfo.GetRegionCode();
strRegionCode += "^";
ViewBag.LineOfBusiness = objBLOrder.GetCheckLineOfBusiness(strRegionCode);
ViewBag.Region_Code = _objCurrentInfo.GetRegionCode();
ViewBag.Region_Name = _objCurrentInfo.GetRegionName();
ViewBag.Current_Month = System.DateTime.Now.Month + "-" + System.DateTime.Now.Year;
ViewBag.Previous_Month = System.DateTime.Now.AddMonths(-1).Month + "-" + System.DateTime.Now.AddMonths(-1).Year;
ViewBag.Next_Month = System.DateTime.Now.AddMonths(1).Month + "-" + System.DateTime.Now.AddMonths(1).Year;
return(View());
}
public JsonResult GetRegionTypes()
{
DAL_DoctorVisitAnalysis objDAL = new DAL_DoctorVisitAnalysis();
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
DataSet ds = new DataSet();
ds = objDAL.GetRegionTypes(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetRegionCode());
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
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: /Division/
public ActionResult Index()
{
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string getusertypename = GetUserType();
ViewBag.getusertypename = getusertypename;
ViewBag.CompanyCode = _objCurInfo.GetCompanyCode();
ViewBag.UserName = _objCurInfo.GetUserName();
ViewBag.User_Code = _objCurInfo.GetUserCode();
ViewBag.Region_Code = _objCurInfo.GetRegionCode();
return(View());
}
public JsonResult GetDrCoverage(MVCModels.DashboardV2Model _objData)
{
_objDashboardV2.CompanyCode = _objCurrentInfo.GetCompanyCode();
_objDashboardV2.RegionCode = _objCurrentInfo.GetRegionCode();
_objDashboardV2.DivisionCode = _objData.DivisionCode;
_objDashboardV2.CoverageInput = _objData.CoverageInput;
return(Json(_objDashboardV2.GetDrCoverage().ToList(), JsonRequestBehavior.AllowGet));
}
public ViewResult ReconSummary(bool IsEdit = false, int HeaderId = 0)
{
DataControl.CurrentInfo _objcurr = new DataControl.CurrentInfo();
ViewBag.Compnay_Code = _objcurr.GetCompanyCode();
ViewBag.loginUserCode = _objcurr.GetUserCode();
ViewBag.LoginRegionCode = _objcurr.GetRegionCode();
//purpose of recon approve functions used
ViewBag.Compnay_Id = _objcurr.GetCompanyId();
ViewBag.IsEdit = IsEdit;
ViewBag.HeaderId = HeaderId;
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());
}
}
// customer detail based on the entity
public JsonResult GetCustomerDetails(FormCollection coll)
{
List <MVCModels.HiDoctor_Master.CustomerModel> lstCust = new List <MVCModels.HiDoctor_Master.CustomerModel>();
IOTC icustDetail = new BAL_OTC();
string regionCode = string.Empty;
if (coll["customerEntity"].ToString().ToUpper() == customerEntity) // if cust entity is equals to ALL, it returns all the customer detail for the reion code.
{
string mode = coll["mode"].ToString();
lstCust = icustDetail.GetCustomerDetails(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetRegionCode(), mode);
}
else
{
regionCode = (coll["regionCode"].ToString() == IsSession) ? _objcurrentInfo.GetRegionCode() : coll["regionCode"].ToString();
lstCust = icustDetail.GetCustomerDetails(_objcurrentInfo.GetCompanyCode(), coll["match"].ToString(), regionCode, coll["customerEntity"].ToString());
}
return(Json(lstCust, JsonRequestBehavior.AllowGet));
}
public string InsertandUpdatetheDCRRequestScreen(string editRequestId, string requestcategoryId, string reguestCategoryName, string fromDate, string toDate, string mode, string remarks)
{
string result = string.Empty;
int rowsAffected = 0;
long requestId = 0;
List <DCRRestrictionModel> lstDCRRequest = new List <DCRRestrictionModel>();
BLMaster _objMaster = new BLMaster();
try
{
DALCampaignPlanner Objcampaign = new DALCampaignPlanner();
requestId = Objcampaign.GetSeqNumber("SEQ_tbl_SFA_DCR_Restriction");
string companyCode = _objcurrentInfo.GetCompanyCode();
string userCode = _objcurrentInfo.GetUserCode();
string regionCode = _objcurrentInfo.GetRegionCode();
string requestedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
if (mode.ToUpper() == "I")
{
DCRRestrictionModel objDCRRequest = new DCRRestrictionModel();
objDCRRequest.Request_Id = requestId.ToString();
objDCRRequest.Company_Code = companyCode;
objDCRRequest.User_Code = userCode;
objDCRRequest.Region_Code = regionCode;
objDCRRequest.Request_Category_Id = requestcategoryId;
objDCRRequest.Request_Category_Name = reguestCategoryName;
objDCRRequest.Date_From = fromDate;
objDCRRequest.Date_To = toDate;
objDCRRequest.Request_Status = "1";
lstDCRRequest.Add(objDCRRequest);
rowsAffected = _objMaster.InsertforDCRRequestScreen(lstDCRRequest, requestId.ToString(), remarks, requestedDate);
}
else
{
DCRRestrictionModel objDCRRequest = new DCRRestrictionModel();
objDCRRequest.Request_Id = editRequestId;
objDCRRequest.Company_Code = companyCode;
objDCRRequest.User_Code = userCode;
objDCRRequest.Region_Code = regionCode;
objDCRRequest.Request_Category_Id = requestcategoryId;
objDCRRequest.Request_Category_Name = reguestCategoryName;
objDCRRequest.Date_From = fromDate;
objDCRRequest.Date_To = toDate;
objDCRRequest.Request_Status = "1";
lstDCRRequest.Add(objDCRRequest);
rowsAffected = _objMaster.UpdateforDCRRequestScreen(lstDCRRequest, editRequestId, remarks, requestedDate);
}
if (rowsAffected > 0)
{
result = "SUCCESS: Saved Successfully.";
}
else
{
result = "ERROR:Error while Inserrting.";
}
return(result);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:editRequestId", editRequestId);
dicContext.Add("Filter:requestcategoryId", requestcategoryId);
dicContext.Add("Filter:reguestCategoryName", reguestCategoryName);
dicContext.Add("Filter:mode", mode);
dicContext.Add("Filter:fromDate", fromDate);
dicContext.Add("Filter:toDate", toDate);
dicContext.Add("Filter:remarks", remarks);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
private string GetNextTwoPossibleDays(string dcrDate)
{
try
{
string possibleDays = string.Empty;
objData.OpenConnection(objCurr.GetCompanyCode());
{
possibleDays = Convert.ToString(objData.ExecuteScalar("exec SP_hdGetNextTwoPossibleDays '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + objCurr.GetRegionCode() + "','" + dcrDate + "'"));
}
return(possibleDays);
}
finally
{
objData.CloseConnection();
}
}
public string InsertStockistPoolAllocation(FormCollection col)
{
string result = string.Empty;
BL_Customer objCust = new BL_Customer();
result = objCust.InsertStockistPoolAllocation(_objcurrentInfo.GetCompanyCode(), col["stockist"].ToString(), col["product"].ToString(), col["territory"].ToString(), col["from"].ToString(), col["to"].ToString(), Convert.ToInt16(col["status"]), col["stockID"].ToString(), col["baseRegion"].ToString(), _objcurrentInfo.GetRegionCode());
return(result);
}
public string GetMyDocumentstoDownload()
{
StringBuilder strTbl = new StringBuilder();
List <MyDocumentTypeModel> lstDocumentTypes = new List <MyDocumentTypeModel>();
int i = 0;
try
{
lstDocumentTypes = _objBlMaster.GetMyDocumentstoDownload(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetUserCode(), _objcurrentInfo.GetRegionCode()).ToList();
strTbl.Append("<table WIDTH='75%' id='tblMydoc' class='table table-striped'>");
strTbl.Append("<thead class='active'>");
strTbl.Append("<tr style='background-color:#428bca;'>");
strTbl.Append("<th>Sl.No.</th>");
strTbl.Append("<th>Type</th>");
strTbl.Append("<th>Name</th>");
strTbl.Append("<th> Actual File Name</th>");
strTbl.Append("<th>Download</th>");
strTbl.Append("</tr>");
strTbl.Append("</thead>");
strTbl.Append("<tbody>");
if (lstDocumentTypes != null && lstDocumentTypes.Count > 0)
{
foreach (var document in lstDocumentTypes)
{
i++;
strTbl.Append("<tr>");
//S.NO
strTbl.Append("<td>");
strTbl.Append(i);
strTbl.Append("</td>");
//Doc Type
strTbl.Append("<td>");
strTbl.Append(document.Doc_Type_Name);
strTbl.Append("</td>");
//Doc Name
strTbl.Append("<td>");
strTbl.Append(document.Doc_Name);
strTbl.Append("</td>");
strTbl.Append("<td>");
strTbl.Append(document.File_name);
strTbl.Append("</td>");
//Download
byte[] docidEncode = System.Text.Encoding.UTF8.GetBytes(document.Doc_Id);
String docId = Convert.ToBase64String(docidEncode);
strTbl.Append("<td>");
strTbl.Append("<a class='td-a downloadicon' data-id= id='aSubmit' style='text-decoration:underline !important;' onclick=\"fnSetDocId('" + docId + "');\"> </a>");
strTbl.Append("</td>");
strTbl.Append("</tr>");
}
}
else
{
strTbl.Append("No Document details found to download.");
}
strTbl.Append("</tbody>");
strTbl.Append("</table>");
return(strTbl.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
public int InsertDivisionEntityMapping(string divisionCode, string entityCode, string entityName)
{
try
{
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
DataControl.BLDivision _objBlDivision = new DataControl.BLDivision();
return(_objBlDivision.DivisionEntityMapping(_objCurInfo.GetCompanyCode(), _objCurInfo.GetUserCode(), _objCurInfo.GetRegionCode(), entityCode, divisionCode, entityName, _objCurInfo.GetUserName()));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("EntityCode", entityCode);
dicObj.Add("divisionCode", divisionCode);
dicObj.Add("entityName", entityName);
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
return(0);
}
}
