//Beat Plan Creation Screen public ActionResult CreateBeatPlan() { ViewBag.Company_Code = _objCurrentInfo.GetCompanyCode(); ViewBag.Company_Id = _objCurrentInfo.GetCompanyId(); ViewBag.Region_Code = _objCurrentInfo.GetRegionCode(); ViewBag.User_Code = _objCurrentInfo.GetUserCode(); ViewBag.User_Type_Code = _objCurrentInfo.GetUserTypeCode(); return(View()); }
public ActionResult DailyReporting(string dcrActualDate) { ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); ViewBag.UserTypeCode = _objCurrentInfo.GetUserTypeCode(); ViewBag.dcrdate = dcrActualDate; ViewBag.UserName = _objCurrentInfo.GetUserName(); ViewBag.RegionName = _objCurrentInfo.GetRegionName(); return(View()); }
public ActionResult Index(string dcrActualDate, string flag, string Company_Code, string UserCode, string RegionCode, int CompanyId) { GetPrivillegeValue(); ViewBag.DCRActualDate = dcrActualDate; ViewBag.Flag = flag; ViewBag.doctor_caption = DOCTOR_CAPTION; ViewBag.chemist_caption = CHEMIST_CAPTION; ViewBag.stockist_caption = STOCKIEST_CAPTION; ViewBag.Company_Code = _objCurrentInfo.GetCompanyCode(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.CompanyId = _objCurrentInfo.GetCompanyId(); return(View()); }
// // GET: /Messaging/ public ActionResult Index() { DataControl.CurrentInfo objCurInfo = new CurrentInfo(); ViewBag.CurrentUserCode = objCurInfo.GetUserCode(); ViewBag.CurrentRegionCode = objCurInfo.GetRegionCode(); return(View()); }
public ActionResult SecondarySalesDelete() { CurrentInfo _objCunr = new CurrentInfo(); ViewBag.currentregioncode = _objCunr.GetRegionCode(); return(View()); }
public string GetHrmsURL() { CurrentInfo _objCurrInfo = new CurrentInfo(); string LoginParams = string.Empty; string HRMS_Url = string.Empty; string HRMS_RedirectingUrl = string.Empty; try { HRMS_RedirectingUrl = _objCurrInfo.GetHRMURL(); CompanyDetails lstcompdetails = new CompanyDetails(); lstcompdetails.Company_Code = _objCurrInfo.GetCompanyCode(); lstcompdetails.Region_Code = _objCurrInfo.GetRegionCode(); lstcompdetails.User_Code = _objCurrInfo.GetUserCode(); lstcompdetails.Employee_Code = _objCurrInfo.GetEmployeeCode(); lstcompdetails.Employee_Number = _objCurrInfo.GetEmployeeNumber(); lstcompdetails.UserName = _objCurrInfo.GetUserName(); lstcompdetails.User_Type_Code = _objCurrInfo.GetUserTypeCode(); LoginParams = JsonConvert.SerializeObject(lstcompdetails); byte[] LoginParamsEncode = System.Text.Encoding.UTF8.GetBytes(LoginParams); LoginParams = Convert.ToBase64String(LoginParamsEncode); if (!string.IsNullOrEmpty(HRMS_RedirectingUrl)) { HRMS_Url = "" + HRMS_RedirectingUrl + "?SSID=" + LoginParams; } return(HRMS_Url); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(string.Empty); } }
public string GetOneLibURL() { CurrentInfo objCurInfo = new CurrentInfo(); string oneLibUrl = string.Empty; try { string companyCode = objCurInfo.GetCompanyCode(); string userTypeCode = objCurInfo.GetUserTypeCode(); string userCode = objCurInfo.GetUserCode(); string oneLibRedirectionUrl = objCurInfo.GetOneLibUrl(); string sessionId = objCurInfo.GetSessionId(); string regionCode = objCurInfo.GetRegionCode(); string userName = objCurInfo.GetUserName(); if (!string.IsNullOrEmpty(oneLibRedirectionUrl)) { oneLibUrl = "" + oneLibRedirectionUrl + "?User_Code=" + userCode + "&Comp_Code=" + companyCode + "&Session_Id=" + sessionId + "&Return_URL=" + Request.Url.Authority + "&User_Type_Code=" + userTypeCode + "&Region_Code=" + regionCode + "&User_Name=" + userName + ""; } return(oneLibUrl); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(string.Empty); } }
public string GetWideAngleURL() { CurrentInfo objCurInfo = new CurrentInfo(); string wideAngleUrl = string.Empty; try { string companyCode = objCurInfo.GetCompanyCode(); string userTypeCode = objCurInfo.GetUserTypeCode(); string userCode = objCurInfo.GetUserCode(); string waUrl = objCurInfo.GetWideAngleUrl(); string sessionId = objCurInfo.GetSessionId(); string regionCode = objCurInfo.GetRegionCode(); string userName = objCurInfo.GetUserName(); if (!string.IsNullOrEmpty(waUrl)) { wideAngleUrl = "" + waUrl + "?User_Code=" + userCode + "&Comp_Code=" + companyCode + "&Session_Id=" + sessionId + "&Return_URL=" + Request.Url.Authority + "&User_Type_Code=" + userTypeCode + "&Region_Code=" + regionCode + "&User_Name=" + userName + ""; } return(wideAngleUrl); } catch (Exception ex) { ErrorLog.LogError(ex, "GetWideAngleURL()"); return(ex.Message.ToString()); } }
public JsonResult GetUserRegionholidays() { CurrentInfo _objcurrentInfo = new CurrentInfo(); BLDashBoardLanding objDash = new BLDashBoardLanding(_objcurrentInfo.GetCompanyCode()); return(Json(objDash.GetUserRegionholidays(_objcurrentInfo.GetRegionCode()), JsonRequestBehavior.AllowGet)); }
public string GetCRMURL() { CurrentInfo _objCurrInfo = new CurrentInfo(); string LoginParams = string.Empty; string CRMURL = string.Empty; try { CompanyDetails lstcompdetails = new CompanyDetails(); lstcompdetails.Company_Code = _objCurrInfo.GetCompanyCode(); lstcompdetails.Region_Code = _objCurrInfo.GetRegionCode(); lstcompdetails.User_Code = _objCurrInfo.GetUserCode(); lstcompdetails.Employee_Code = _objCurrInfo.GetEmployeeCode(); lstcompdetails.Employee_Number = _objCurrInfo.GetEmployeeNumber(); lstcompdetails.UserName = _objCurrInfo.GetUserName(); lstcompdetails.User_Type_Code = _objCurrInfo.GetUserTypeCode(); LoginParams = JsonConvert.SerializeObject(lstcompdetails); byte[] LoginParamsEncode = System.Text.Encoding.UTF8.GetBytes(LoginParams); LoginParams = Convert.ToBase64String(LoginParamsEncode); CRMURL = LoginParams; return(CRMURL); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(string.Empty); } }
public JsonResult GetBirthdayAnniversaryCount() { CurrentInfo _objcurrentInfo = new CurrentInfo(); BLDashBoardLanding objDash = new BLDashBoardLanding(_objcurrentInfo.GetCompanyCode()); return(Json(objDash.GetBirthdayAnniversaryCount(_objcurrentInfo.GetRegionCode()), JsonRequestBehavior.AllowGet)); }
public PartialViewResult HospitalDetails() { ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); return(PartialView()); }
public ActionResult TargetSettings() { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RequestRegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.RequestUserCode = _objCurrentInfo.GetUserCode(); return(View()); }
/// <summary> /// Retrieve My Expense Claim Count. /// </summary> /// <returns>int</returns> public int GetMyExpenseClaimUnapprovedCount() { // Cretaes Instance. CurrentInfo objInfo = new CurrentInfo(); BLDashBoardLanding objDash = new BLDashBoardLanding(objInfo.GetCompanyCode()); // Get My Unapproved claims. return(objDash.GetMyUnapprovedEntries(objInfo.GetUserCode(), objInfo.GetRegionCode(), DashBoardLanding.Entity.EXPNESECLAIM)); }
public ActionResult ComplaintForm() { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RequestRegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.User_Code = _objCurrentInfo.GetUserCode(); return(View()); }
/// <summary> /// Retrieve My Unapproved DCR Count. /// </summary> /// <returns>int</returns> public int GetMyDCRUnapprovedCount() { // Cretaes Instance. CurrentInfo objInfo = new CurrentInfo(); BLDashBoardLanding objDash = new BLDashBoardLanding(objInfo.GetCompanyCode()); // Get My Unapprove DCR. return(objDash.GetMyUnapprovedEntries(objInfo.GetUserCode(), objInfo.GetRegionCode(), DashBoardLanding.Entity.DCR)); }
//public void ProcessPrimarySalesUpload(DataSet Ds, DataSet Ds_Validate, DataSet dsMaster, string fileName, string CompanyCode, string CurrUserCode, string ConnectionString, string SubDomain) //{ // bool Is_error = false; // string strGuid = Guid.NewGuid().ToString(); // var hasDupHdr = Ds.Tables[0].AsEnumerable() // .GroupBy(row => new // { // Depot_Name = row.Field<string>("Depot_Name"), // Region_Name = row.Field<string>("Region_Name"), // Stockiest_Ref_Key1 = row.Field<string>("Stockiest_Ref_Key1"), // Document_number =row.Field<dynamic>("Document_number") // }) // .Where (g => g.Count() > 1) // .Select(g => g.CopyToDataTable()).ToList(); // Ds.Tables[0].Columns.Add(("Region_Ref_Key1"), typeof(string)); // Ds.Tables[0].Columns.Add(("Depot_Ref_Key1"), typeof(string)); // if (hasDupHdr.Any()) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", "", "HD_ERR_0394", "")); // Is_error = true; // } // //check correct dataformat for header sheet - null values and invalid data type // int idxEmptyRowIndex = 1; // foreach (DataRow row_xl in Ds.Tables[0].Rows) // { // DateTime dtFormat; // if (row_xl.AreAllCellsEmpty() || String.IsNullOrWhiteSpace(row_xl["Region_Name"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Depot_Name"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Document_number"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Stockiest_Ref_Key1"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Document_Type"].ToString().Trim())) // { // //MandatoryFieldsEmpty = true; // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxEmptyRowIndex.ToString(), "HD_ERR_0404", "")); // Is_error = true; // } // if (!row_xl.AreAllCellsEmpty()) // { // if ((!DateTime.TryParseExact(row_xl["Document_Date"].ToString().Trim(), "dd/MM/yyyy", new CultureInfo("en-GB"), DateTimeStyles.None, out dtFormat))) // { // //DataFormatInvalid = true; // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxEmptyRowIndex.ToString(), "HD_ERR_0405", "")); // Is_error = true; // } // else // { // DateTime myDate = DateTime.ParseExact(row_xl["Document_Date"].ToString(), "dd/MM/yyyy", // System.Globalization.CultureInfo.InvariantCulture); // row_xl["Document_Date"] = myDate.ToString("yyyy/MM/dd"); // } // if (!IsIntegerOrDecimal(row_xl["Gross_Amount"].ToString().Trim()) || (!IsIntegerOrDecimal(row_xl["Discount_Amount"].ToString().Trim()) // || (!IsIntegerOrDecimal(row_xl["Tax"].ToString().Trim())) || (!IsIntegerOrDecimal(row_xl["Net_Amount"].ToString().Trim())))) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxEmptyRowIndex.ToString(), "HD_ERR_0406", "")); // Is_error = true; // } // } // idxEmptyRowIndex++; // } //check correct dataformat for detail sheet //int idxDtlRows = 1; //foreach (DataRow row_xl in Ds.Tables[1].Rows) //{ // DateTime dtFormat; // if (row_xl.AreAllCellsEmpty() || String.IsNullOrWhiteSpace(row_xl["Region_Name"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Depot_Name"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Document_number"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Stockiest_Ref_Key1"].ToString().Trim()) || // String.IsNullOrWhiteSpace(row_xl["Document_Type"].ToString().Trim())) // { // //MandatoryFieldsEmpty = true; // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxDtlRows.ToString(), "HD_ERR_0408", "")); // Is_error = true; // } // if (!row_xl.AreAllCellsEmpty()) // { // if ((!DateTime.TryParseExact(row_xl["Document_Date"].ToString().Trim(), "dd/MM/yyyy", new CultureInfo("en-GB"), DateTimeStyles.None, out dtFormat))) // { // //DataFormatInvalid = true; // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxDtlRows.ToString(), "HD_ERR_0409", "")); // Is_error = true; // } // else // { // DateTime myDate = DateTime.ParseExact(row_xl["Document_Date"].ToString(), "dd/MM/yyyy", // System.Globalization.CultureInfo.InvariantCulture); // row_xl["Document_Date"] = myDate.ToString("yyyy/MM/dd"); // } // //if (!IsInteger(row_xl["Sales_Quantity"].ToString().Trim()) || (!IsInteger(row_xl["Free_Quantity"].ToString().Trim()))) // //{ // // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxDtlRows.ToString(), "HD_ERR_0407", "")); // // Is_error = true; // //} // if (!IsIntegerOrDecimal(row_xl["Sales_Rate"].ToString().Trim()) || !IsIntegerOrDecimal(row_xl["Sales_Quantity"].ToString().Trim()) || (!IsIntegerOrDecimal(row_xl["Free_Quantity"].ToString().Trim()))) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", idxDtlRows.ToString(), "HD_ERR_0440", "")); // Is_error = true; // } // } // idxDtlRows++; //} //if (Is_error) //{ // if (ErrorList.Count > 0) // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "ERROR", CurrUserCode, ConnectionString); // Bl.InsertPrimarySalesBatchProcessing(ErrorList, strGuid, ConnectionString); // //return Json("Not Uploaded"); // return; // } //} //Validating region with master //int iRowIndex = 1; //foreach (DataRow row_xl in Ds.Tables[0].Rows) //{ // if (!row_xl.AreAllCellsEmpty()) // { // bool prodExists = false; // foreach (DataRow row_val in dsMaster.Tables[0].Rows) // { // if (row_xl["Region_Name"].ToString().Trim() == row_val["Region_Name"].ToString().Trim()) // { // row_xl["Region_Ref_Key1"] = row_val["Region_Ref_Key1"].ToString().Trim(); // prodExists = true; // } // } // if (!prodExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", iRowIndex.ToString(), "HD_ERR_0395","")); // Is_error = true; // } // iRowIndex++; // } //} //Validating stockiest with master //int jRowIndex = 1; //foreach (DataRow row_xl in Ds.Tables[0].Rows) //{ // if (!row_xl.AreAllCellsEmpty()) // { // bool prodExists = false; // foreach (DataRow row_val in dsMaster.Tables[1].Rows) // { // if (row_xl["Stockiest_Ref_Key1"].ToString().Trim() == row_val["Stockiest_Ref_Key1"].ToString().Trim() && // row_xl["Region_Name"].ToString().Trim() == row_val["Region_Name"].ToString().Trim()) // { // prodExists = true; // } // } // if (!prodExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", jRowIndex.ToString(), "HD_ERR_0397","")); // Is_error = true; // } // jRowIndex++; // } //} //Validating depot with master //int dRowIndex = 1; //foreach (DataRow row_xl in Ds.Tables[0].Rows) //{ // if (!row_xl.AreAllCellsEmpty()) // { // bool prodExists = false; // foreach (DataRow row_val in dsMaster.Tables[3].Rows) // { // if (row_xl["Depot_Name"].ToString().Trim() == row_val["Depot_Name"].ToString().Trim() // && (row_xl["Region_Name"].ToString().Trim() == row_val["Region_Name"].ToString().Trim())) // { // row_xl["Depot_Ref_Key1"] = row_val["Depot_Ref_Key1"].ToString().Trim(); // prodExists = true; // } // } // if (!prodExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", dRowIndex.ToString(), "HD_ERR_0396","")); // Is_error = true; // } // dRowIndex++; // } //} //Validating document type with master // int dtRowIndex = 1; // foreach (DataRow row_xl in Ds.Tables[0].Rows) // { // if (!row_xl.AreAllCellsEmpty()) // { // bool prodExists = false; // foreach (DataRow row_val in dsMaster.Tables[4].Rows) // { // if (row_xl["Document_Type"].ToString().Trim() == row_val["Document_Type"].ToString().Trim()) // { // prodExists = true; // } // } // if (!prodExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", dtRowIndex.ToString(), "HD_ERR_0398","")); // Is_error = true; // } // dtRowIndex++; // } // } // if (Is_error) // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "ERROR", CurrUserCode, ConnectionString); // Bl.InsertPrimarySalesBatchProcessing(ErrorList, strGuid, ConnectionString); // } // else // { // //verify header value and detail values // var qry1 = Ds.Tables[1].AsEnumerable().Select(a => new // { // Document_Number = a["Document_Number"].ToString().Trim(), // Region_Name = a["Region_Name"].ToString().Trim(), // Depot_Name = a["Depot_Name"].ToString().Trim(), // Stockiest_Ref_Key1 = a["Stockiest_Ref_Key1"].ToString().Trim(), // Document_Type = a["Document_Type"].ToString().Trim() // }); // var qry2 = Ds.Tables[0].AsEnumerable().Select(b => new // { // Document_Number = b["Document_Number"].ToString().Trim(), // Region_Name = b["Region_Name"].ToString().Trim(), // Depot_Name = b["Depot_Name"].ToString().Trim(), // Stockiest_Ref_Key1 = b["Stockiest_Ref_Key1"].ToString().Trim(), // Document_Type = b["Document_Type"].ToString().Trim() // }); // var exceptAB = qry1.Except(qry2); // if (exceptAB.Any()) // { // foreach (var item in exceptAB.ToList()) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", "", "HD_ERR_0399","")); // Is_error = true; // } // } // if (Is_error) // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "ERROR", CurrUserCode, ConnectionString); // Bl.InsertPrimarySalesBatchProcessing(ErrorList, strGuid, ConnectionString); // return; // } // //Validate for same document number, region, depot and stockiest // int intSameRowExists = 1; // foreach (DataRow row_xl in Ds.Tables[0].Rows) // { // if (!row_xl.AreAllCellsEmpty()) // { // bool sameRowExists = false; // foreach (DataRow row_val in Ds_Validate.Tables[0].Rows) // { // if (row_xl["Region_Name"].ToString().Trim() == row_val["Region_Name"].ToString().Trim() && // row_xl["Depot_Name"].ToString().Trim() == row_val["Depot_Name"].ToString().Trim() && // row_xl["Document_number"].ToString().Trim() == row_val["Document_number"].ToString().Trim() && // row_xl["Stockiest_Ref_Key1"].ToString().Trim() == row_val["Stockiest_Ref_Key1"].ToString().Trim()) // { // sameRowExists = true; // } // } // if (sameRowExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", intSameRowExists.ToString(), "HD_ERR_0403","")); // Is_error = true; // } // intSameRowExists++; // } // } // //Validating product with master // int intProdRowIndex = 1; // foreach (DataRow row_xl in Ds.Tables[1].Rows) // { // if (!row_xl.AreAllCellsEmpty()) // { // bool prodExists = false; // foreach (DataRow row_val in Ds_Validate.Tables[1].Rows) // { // if (row_xl["Product_Ref_Key1"].ToString().Trim() == row_val["Product_Ref_Key1"].ToString().Trim()) // { // prodExists = true; // } // } // if (!prodExists) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", intProdRowIndex.ToString(), "HD_ERR_0400","")); // Is_error = true; // } // intProdRowIndex++; // } // } // //validating Return available quantity // if (Ds_Validate.Tables[2].Rows.Count > 0) // { // int intProdQntRowIndex = 1; // foreach (DataRow row_xl in Ds.Tables[1].Rows) // { // if (!row_xl.AreAllCellsEmpty()) // { // if (row_xl["Document_Type"].ToString() != "INVOICE") // { // foreach (DataRow row_val in Ds_Validate.Tables[2].Rows) // { // if (row_xl["Region_Name"].ToString().Trim() == row_val["Region_Name"].ToString().Trim() && // row_xl["Depot_Name"].ToString().Trim() == row_val["Depot_Name"].ToString().Trim() && // row_xl["Stockiest_Ref_Key1"].ToString().Trim() == row_val["Stockiest_Ref_Key1"].ToString().Trim() && // row_xl["Document_Number"].ToString().Trim() == row_val["Document_Number"].ToString().Trim() && // row_xl["Product_Ref_Key1"].ToString().Trim() == row_val["Product_Ref_key1"].ToString().Trim() && // row_xl["Batch_Number"].ToString().Trim() == row_val["Batch_Number"].ToString().Trim() && // Convert.ToDecimal(row_xl["Sales_Quantity"].ToString().Trim()) > Convert.ToDecimal(row_val["Available_Quantity"].ToString().Trim())) // { // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", intProdQntRowIndex.ToString(), "HD_ERR_0401","")); // Is_error = true; // } // } // } // intProdQntRowIndex++; // } // } // } // if (Is_error) // { // if (ErrorList.Count > 0) // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "ERROR",CurrUserCode, ConnectionString); // Bl.InsertPrimarySalesBatchProcessing(ErrorList, strGuid, ConnectionString); // //return Json("Not Uploaded"); // } // } // else // { // string error = Bl.PrimarySaleBulkInsert(SubDomain, CompanyCode, CurrUserCode, fileName, Ds, "tbl_sfa_PrimarySales_Header", "tbl_sfa_PrimarySales_details"); // if (error == "Success") // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "SUCCESS", CurrUserCode, ConnectionString); // } // else // { // Bl.InsertPrimarySalesBatchProcessingHeader(CompanyCode, strGuid, "PSU_UPLOAD", fileName, DateTime.Now.ToString(), "ERROR", CurrUserCode, ConnectionString); // ErrorList.Add(new PrimarySalesModel(CompanyCode, "", "", "HD_ERR_0402", error)); // Bl.InsertPrimarySalesBatchProcessing(ErrorList, strGuid, ConnectionString); // } // } // } // } // public bool IsIntegerOrDecimal(string sVal) // { // try // { // // must be numeric value // double d = double.Parse(sVal); // // max of two decimal places // if (sVal.IndexOf(".") >= 0) // { // if (sVal.Length > sVal.IndexOf(".") + 3) // { // return false; // } // if (d < 0) // { // return false; // } // } // else // { // if (d < 0) // { // return false; // } // } // return true; // } // catch // { // return false; // } // } // public bool IsInteger(string sVal) // { // try // { // int num = int.Parse(sVal); // if (num < 0) // { // return false; // } // return true; // } // catch // { // return false; // } // } // public ActionResult BatchProcessing() // { // return View(); // } //} //extension method for datarow // public static class DataExtensions // { // public static bool AreAllCellsEmpty(this DataRow row) // { // var itemArray = row.ItemArray; // if (itemArray == null) // return true; // return itemArray.All(x => string.IsNullOrWhiteSpace(x.ToString())); // } // //} // } //To Get Product List public JsonResult GetProducts() { string Region_Code = _objCurrentInfo.GetRegionCode(); Dt = new DataTable(); Dt = Bl.GetProducts(Region_Code); JSONConverter json = new JSONConverter(); return(Json(json.Serialize(Dt), JsonRequestBehavior.AllowGet)); }
public ActionResult InwardAllocation() { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.RegionName = _objCurrentInfo.GetRegionName(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); ViewBag.UserName = _objCurrentInfo.GetUserName(); ViewBag.UserTypeName = _objCurrentInfo.GetUserTypeName(); return(View()); }
public ActionResult STOS_Approval() { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.RegionName = _objCurrentInfo.GetRegionName(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); ViewBag.UserName = _objCurrentInfo.GetUserName(); ViewBag.UserTypeName = _objCurrentInfo.GetUserTypeName(); return(View()); }
public ActionResult Index(string dcrActualDate, string flag, string Company_Code, string UserCode, string RegionCode, int CompanyId) { string today = DateTime.Now.ToShortDateString(); ViewBag.possibleDays = _objBLDCR.GetNextTwoPossibleDays(objCurr.GetCompanyCode(), objCurr.GetUserCode(), objCurr.GetRegionCode(), today); ViewBag.flag = flag; ViewBag.dcrDate = dcrActualDate; ViewBag.Company_Code = objCurr.GetCompanyCode(); ViewBag.UserCode = objCurr.GetUserCode(); ViewBag.RegionCode = objCurr.GetRegionCode(); ViewBag.CompanyId = objCurr.GetCompanyId(); return(View()); }
public JsonResult GetExcelApiInputData(string sessionKey, string searchKey) { CurrentInfo _objcurrentInfo = new CurrentInfo(); Repository.APIRepository objAPIRepo = new Repository.APIRepository(); string companyCode = _objcurrentInfo.GetCompanyCode(); string userCode = _objcurrentInfo.GetUserCode(); string regionCode = _objcurrentInfo.GetRegionCode(); List <MVCModels.HiDoctor_Reports.ExcelApiInput> lstExcelApiList = new List <MVCModels.HiDoctor_Reports.ExcelApiInput>(); lstExcelApiList = objAPIRepo.GetExcelApiInputData(companyCode, userCode, regionCode, sessionKey, searchKey); return(Json(_objJSON.Serialize(lstExcelApiList), JsonRequestBehavior.AllowGet)); }
public ActionResult Request(string regionCode, int?stosId) { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RequestRegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.RequestRegionName = _objCurrentInfo.GetRegionName(); ViewBag.RequestUserCode = _objCurrentInfo.GetUserCode(); ViewBag.RequestUserName = _objCurrentInfo.GetUserName(); ViewBag.RequestUserTypeName = _objCurrentInfo.GetUserTypeName(); ViewBag.RequestUserTypeCode = _objCurrentInfo.GetUserTypeCode(); ViewBag.StosId = stosId; ViewBag.SelectedUser = regionCode; return(View()); }
/// <summary> /// Dashboard landing page. /// </summary> /// <returns></returns> public ActionResult Index() { // create intances. CurrentInfo objInfo = new CurrentInfo(); BLDashBoardLanding objDash = new BLDashBoardLanding(objInfo.GetCompanyCode()); ViewBag.User_Code = objInfo.GetUserCode(); int teamCount = objDash.GetImmediateChildUserCount(objInfo.GetUserCode()); ViewBag.teamCount = teamCount; ViewBag.CompanyCode = objInfo.GetCompanyCode(); ViewBag.Region_Code = objInfo.GetRegionCode(); return(View()); }
public ActionResult STOSEmailTrigger() { _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.RequestRegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.RequestRegionName = _objCurrentInfo.GetRegionName(); ViewBag.RequestUserCode = _objCurrentInfo.GetUserCode(); ViewBag.RequestUserName = _objCurrentInfo.GetUserName(); ViewBag.RequestUserTypeName = _objCurrentInfo.GetUserTypeName(); ViewBag.RequestUserTypeCode = _objCurrentInfo.GetUserTypeCode(); return(View()); }
public string urlEncodeing() { MVCModels.UserInfoModel objuser = new MVCModels.UserInfoModel(); CurrentInfo objCurInfo = new CurrentInfo(); string userParam = string.Empty; objuser.Company_Code = objCurInfo.GetCompanyCode(); objuser.User_Code = objCurInfo.GetUserCode(); objuser.User_Type_Code = objCurInfo.GetUserTypeCode(); objuser.Region_Code = objCurInfo.GetRegionCode(); objuser.Company_Id = objCurInfo.GetCompanyId(); objuser.User_Details = objCurInfo.GetUserName() + " (" + objCurInfo.GetUserTypeName() + ")"; objuser.Is_Mobile = "NO"; userParam = Newtonsoft.Json.JsonConvert.SerializeObject(objuser); byte[] LoginParamsEncode = System.Text.Encoding.UTF8.GetBytes(userParam); userParam = Convert.ToBase64String(LoginParamsEncode); return(userParam); }
//public bool SaveMapping(string Weekend_Code, string Price_group_code, string Region_Lock, string Chemist_Lock, string Region_Type_Code, string Effective_From, string Effective_To, string divisionCode, string holiday_Code, string holiday_name) //{ // bool result = false; // string companyCode = null; // string UserCode = null; // string Companyid = null; // try // { // _objCurrInfo = new CurrentInfo(); // companyCode = _objCurrInfo.GetCompanyCode(); // UserCode = _objCurrInfo.GetUserCode(); // Companyid = _objCurrInfo.GetCompanyId(); // result = _objbl.SaveMapping(companyCode, UserCode, region_Code, Companyid, Weekend_Code, Price_group_code, Region_Lock, Chemist_Lock, Region_Type_Code, Effective_From, Effective_To, divisionCode, holiday_Code, holiday_name); // } // catch (Exception ex) // { // throw; // } // return result; //} #endregion Creation #region Disable //Disable - Region Creation Wizard public JsonResult GetActiveRegions() { string companyCode = null; string region_Code = null; List <UnderRegion> lstactreg = null; try { _objCurrInfo = new CurrentInfo(); companyCode = _objCurrInfo.GetCompanyCode(); region_Code = _objCurrInfo.GetRegionCode(); lstactreg = _objbl.GetActiveRegions(companyCode, region_Code).ToList(); return(Json(lstactreg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }
public JsonResult CheckTPAvailableForSelectedLeaveDates(string leaveFromDate, string leaveToDate) { try { SPData objSPData = new SPData(); CurrentInfo objcurrentInfo = new CurrentInfo(); StringBuilder LeaveDates = new StringBuilder(); DateTime fromDate = Convert.ToDateTime(leaveFromDate); DateTime toDate = Convert.ToDateTime(leaveToDate); for (DateTime i = fromDate; i <= toDate; i = i.AddDays(1)) { LeaveDates.Append(i.ToShortDateString()); LeaveDates.Append("^"); } 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, LeaveDates.ToString()); // 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 JsonResult GetDivisionsBasedonLoggedUser() { List <MVCModels.DivisionModel> lstDivision = null; string companyCode = null; string regionCode = null; try { BLDivision _ObjDivisns = new BLDivision(); CurrentInfo _ObjCurrentInfo = new CurrentInfo(); companyCode = ViewBag.Company_Code = _ObjCurrentInfo.GetCompanyCode(); regionCode = ViewBag.Region_Code = _ObjCurrentInfo.GetRegionCode(); lstDivision = _ObjDivisns.GetDivisionsBasedonLoggedUser(companyCode, regionCode); return(Json(lstDivision, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }
public ActionResult MasterDataHandler(string SSID) { UserInfoModel _objcomp = new UserInfoModel(); if (!string.IsNullOrEmpty(SSID)) { byte[] EncodedParams = Convert.FromBase64String(SSID); string Params = System.Text.Encoding.UTF8.GetString(EncodedParams); _objcomp = Newtonsoft.Json.JsonConvert.DeserializeObject <UserInfoModel>(Params); ViewBag.CompanyCode = _objcomp.Company_Code; ViewBag.UserCode = _objcomp.User_Code; ViewBag.UTypeCode = _objcomp.User_Type_Code; ViewBag.RegionCode = _objcomp.Region_Code; ViewBag.UserDetails = _objcomp.User_Details; ViewBag.Company_Id = _objcomp.Company_Id; ViewBag.BatchProcessingId = _objcomp.BatchProcessingId; ViewBag.BP_Guid = _objcomp.BP_Guid; ViewBag.LoadType = "Mail"; ViewBag.FileProcessId = _objcomp.FileProcessId; ViewBag.ViewType = _objcomp.ViewType; } else { CurrentInfo _objCurrentInfo = new CurrentInfo(); ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode(); ViewBag.UserCode = _objCurrentInfo.GetUserCode(); ViewBag.UTypeCode = _objCurrentInfo.GetUserTypeCode(); ViewBag.RegionCode = _objCurrentInfo.GetRegionCode(); ViewBag.UserDetails = _objCurrentInfo.GetCompanyCode(); ViewBag.Company_Id = _objCurrentInfo.GetCompanyId(); ViewBag.LoadType = "Screen"; ViewBag.BatchProcessingId = 155; ViewBag.BP_Guid = "32EAA70B-89C3-42CC-9F19-F8BA55224531"; ViewBag.FileProcessId = 66; ViewBag.ViewType = "MasterData"; } return(View()); }
public JsonResult GetAllCampaignsBasedonRegion() { string companyCode = null; string currentregionCode = null; List <CampaignModel> lstCamp = null; try { companyCode = ObjCurrInfo.GetCompanyCode(); currentregionCode = ObjCurrInfo.GetRegionCode(); lstCamp = ObjPR.GetAllCampaignsBasedonRegion(companyCode, currentregionCode).ToList(); return(Json(lstCamp, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }