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 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 BatchCreation()
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
return(View());
}
public void GetHolidayExcelDownload(FormCollection coll)
{
string blobUrl = string.Empty, error = string.Empty;
DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
string holidayDate = string.Empty;
if (!string.IsNullOrEmpty(coll["hdnSearchDate"]))
{
holidayDate = Convert.ToString(coll["hdnSearchDate"]);
}
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
DataControl.CurrentInfo _objCurr = new DataControl.CurrentInfo();
string content = GetSearchHolidayDetails(holidayDate);
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = _objCurr.GetUserName();
string subDomin = _objCurr.GetSubDomain();
string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls";
blobUrl = objAzureBlob.AzureBlobUploadText(content.ToString(), accKey, fileName, "bulkdatasvc");
objFileDownload.DownloadFile(blobUrl, fileName, out error);
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
}
}
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 ActionResult UploadedRegionExcel(HttpPostedFileBase fileUpload)
{
_objBLRegion = new BLRegion();
string companyCode = _objcurrentInfo.GetCompanyCode();
string subDomain = _objcurrentInfo.GetSubDomain();
string user_Code = _objcurrentInfo.GetUserCode();
string errorCode = _objBLRegion.InsertRegionMasterBulkUpload(subDomain, companyCode, fileUpload, user_Code, _objcurrentInfo.GetUserName());
ViewBag.ErrorCode = errorCode;
return(View());
}
public ActionResult DFCExcelBulkAddResult(HttpPostedFileBase file)
{
string result = "";
DataControl.BLMaster _objMast = new DataControl.BLMaster();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string subDomain = _objCurInfo.GetSubDomain();
result = _objMast.InsertDFCExcelBulkUpload(subDomain, _objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode());
ViewBag.ErrorCode = result;
return(View("DFCExcelBulkAddResult"));
}
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 string GenerateYearWiseHolidayExcel(string regionCodes, string year, string SearchKey, int pageNumber, bool excelDownload)
{
int count = 0;
int totalPageCount = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
lstHoliday = objRegion.GetMappedHolidayDetails(objCurInfo.GetCompanyCode(), regionCodes, year, SearchKey, pageNumber, excelDownload, PAGESIZE,
ref totalPageCount);
StringBuilder strContent = new StringBuilder();
StringBuilder strExcelContent = new StringBuilder();
strExcelContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Date</td><td>Holiday Name</td>");
strExcelContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strExcelContent.Append("<tr><td>" + i + "</td>");
strExcelContent.Append("<td><span id='lblHolidayDate_" + i + "'>" + dr.Holiday_Date + "</span></td>");
strExcelContent.Append("<td><span id='lblHolidayName_" + i + "'>" + dr.Holiday_Name + "</span></td>");
strExcelContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strExcelContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strExcelContent.Append("</tr>");
}
}
strExcelContent.Append("</tbody></table>");
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = objCurInfo.GetUserName();
string subDomin = objCurInfo.GetSubDomain();
string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls";
string blobUrl = string.Empty;
blobUrl = objAzureBlob.AzureBlobUploadText(strExcelContent.ToString(), accKey, fileName, "bulkdatasvc");
return(blobUrl);
}
public ActionResult ProductExcelUploadResult(HttpPostedFileBase file)
{
try
{
string result = string.Empty;
DataControl.BLProduct _objBlProduct = new DataControl.BLProduct();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
result = _objBlProduct.ProductBulkInsert(_objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(),
_objCurInfo.GetSubDomain());
ViewBag.ErrorCode = result;
return(View("ProductExcelUploadResult"));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
ViewBag.ErrorCode = ex.Message;
return(View("ProductExcelUploadResult"));
}
}
public ActionResult RCPAExcelBulkAddResult(HttpPostedFileBase file, FormCollection form)
{
string result = "";
DataControl.BLUser _objBlUser = new DataControl.BLUser();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
MVCModels.ShieldRCPA objrcpaHeader = new MVCModels.ShieldRCPA();
objrcpaHeader.Company_Id = Convert.ToInt32(_objCurInfo.GetCompanyId());
objrcpaHeader.Company_code = _objCurInfo.GetCompanyCode();
objrcpaHeader.user_code = _objCurInfo.GetUserCode();
DateTime dt = DateTime.ParseExact(Request.Form["FromDate"].ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodFrom = Convert.ToDateTime(dt.ToString("yyyy-MM-dd"));
dt = DateTime.ParseExact(Request.Form["ToDate"].ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);
objrcpaHeader.PeriodTo = Convert.ToDateTime(dt);
string subDomain = _objCurInfo.GetSubDomain();
result = _objBLShieldRCPA.InsertRCPAExcelBulkUpload(subDomain, _objCurInfo.GetCompanyCode(), _objCurInfo.GetRegionCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(), objrcpaHeader);
ViewBag.ErrorCode = result;
return(View("RCPAExcelBulkAddResult"));
}
public ActionResult ExcellPayslipDefiner(HttpPostedFileBase file, FormCollection collection)
{
try
{
string result = string.Empty;
DataControl.BLUser objBlUser = new BLUser();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string selectedUserType = collection["userTypeCode"].ToString();
selectedUserType = selectedUserType.Replace(",,", ",");
selectedUserType = selectedUserType.TrimEnd(',');
result = objBlUser.PayslipDefinerBulkUpload(_objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(),
_objCurInfo.GetSubDomain(), selectedUserType);
ViewBag.ErrorCode = result;
return(View("PayslipColumnDefinerResult"));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
ViewBag.ErrorCode = string.Empty;
return(View("PayslipColumnDefinerResult"));
}
}
public ActionResult PrimarySalesExcelUploadResult(HttpPostedFileBase file, FormCollection collection)
{
try
{
const string TransType = "hdnTransType";
string transactionType = Convert.ToString(collection[TransType]);
string result = string.Empty;
DataControl.BLProduct _objBlProduct = new DataControl.BLProduct();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
result = _objBlProduct.PrimarySalesBulkInsert(_objCurInfo.GetCompanyCode(),
Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(),
_objCurInfo.GetSubDomain(), transactionType);
ViewBag.ErrorCode = result;
return(View("PrimarySalesExcelUploadResult"));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
ViewBag.ErrorCode = string.Empty;
return(View("PrimarySalesExcelUploadResult"));
}
}
public void ExcuteAsynReport(FormCollection collection)
{
BL_ReportRegion _objBLReport = new BL_ReportRegion();
string userCode = collection["hdnDownload"].ToString();
string startDate = collection["txtFromDate"].ToString();
//string startDate = DateTime.Parse(sd).ToString("yyyy-MM-dd");
//01/04/2016
string endDate = collection["txtToDate"].ToString();
// string endDate = DateTime.Parse(ed).ToString("yyyy-MM-dd");
// string unlistedDoctor = collection["type"].ToString();
string dateSelection = collection["reportType"].ToString();
string MissedDoc = "";
if (collection["missed"] == "MISSED")
{
MissedDoc = "1";
}
else
{
MissedDoc = "0";
}
string UnlistedDoc = "";
if (collection["Unlisted"] == "INCLUDE")
{
UnlistedDoc = "1";
}
else
{
UnlistedDoc = "0";
}
string UserSelection = string.Empty;
// string reportName = collection["title"].ToString();
//string missedDoctor = collection["missed"].ToString();
//string reportViewType = collection["reportViewType"].ToString();
if (userCode.ToUpper() == "ALL")
{
userCode = _objcurrentInfo.GetUserCode();
UserSelection = "ALL";
}
else
{
userCode = userCode.Replace(",,", ",");
}
//string userSelection = collection["type"].ToString();
string userSelection = string.Empty;
string[] stDate = startDate.Split('/');
string[] enDate = endDate.Split('/');
startDate = stDate[2] + "-" + stDate[1] + "-" + stDate[0];
endDate = enDate[2] + "-" + enDate[1] + "-" + enDate[0];
_objBLReport.ExcuteAsynLastSubmitted(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetUserCode(), userCode, startDate, endDate, userSelection, _objcurrentInfo.GetSubDomain(), MissedDoc, UnlistedDoc);
}
