public string GetFormManagementURL() { CurrentInfo _objcurrentinfo = new CurrentInfo(); string formManagementURL = string.Empty; try { string formmanagementstring = _objcurrentinfo.GetFormManagementURL(); string subDomainName = _objcurrentinfo.GetSubDomain(); string userName = _objcurrentinfo.GetUserName(); byte[] companyEncode = System.Text.Encoding.UTF8.GetBytes(_objcurrentinfo.GetCompanyCode()); String EncodeCompanyCodeString = Convert.ToBase64String(companyEncode); byte[] Userencode = System.Text.Encoding.UTF8.GetBytes(_objcurrentinfo.GetUserCode()); String EncodeUserCodeString = Convert.ToBase64String(Userencode); if (!string.IsNullOrEmpty(formmanagementstring)) { formManagementURL = "" + formmanagementstring + "?C=" + EncodeCompanyCodeString + "&U=" + EncodeUserCodeString + ""; } return(formManagementURL); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(ex.Message.ToString()); } }
private void CreateFileName(string product_type_name, string division_name) { #region File Name Generated _fileNameString.Append(_objCurrentInfo.GetSubDomain() + "_"); _fileNameString.Append(_objCurrentInfo.GetUserName() + "_"); _fileNameString.Append("Inward_Bulk_upload_"); _fileNameString.Append(division_name == null ? "NoDivision" : division_name); _fileNameString.Append("_"); _fileNameString.Append(product_type_name); _fileNameString.Append("_"); _fileNameString.Append(DateTime.Now.ToString("dd-MM-yyyy")); _fileNameString.Append("_"); _fileNameString.Append((DateTime.Now.ToString("HH-mm-ss-ffffff"))); _fileNameString.Append(".xls"); #endregion File Name Generated }
public string UploadHolidayExcelFile() { DataControl.BLRegion objBlRegion = new BLRegion(); DataControl.CurrentInfo objCurInfo = new CurrentInfo(); string subDomain = objCurInfo.GetSubDomain(); string result = string.Empty; result = objBlRegion.InsertHolidayExcelBulkUpload(objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), Request.Files, objCurInfo.GetUserCode(), subDomain); return(result); }
//[HttpPost] public ActionResult SFCExcelUploadResult(HttpPostedFileBase file) { DataControl.BLRegion objBlRegion = new BLRegion(); DataControl.CurrentInfo objCurInfo = new CurrentInfo(); string subDomain = objCurInfo.GetSubDomain(); string result = string.Empty; result = objBlRegion.InsertSFCExcelBulkUpload(objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, objCurInfo.GetUserCode(), subDomain, GetIP(), System.Net.Dns.GetHostName().ToString()); ViewBag.ErrorCode = result; return(View("SFCExcelUploadResult")); }
public ActionResult InwardUploadExcelFile(HttpPostedFileBase fileUpload, string InwardDate) { DataControl.BLRegion objBlRegion = new BLRegion(); DataControl.CurrentInfo objCurInfo = new CurrentInfo(); IConfig_Settings = new Config_Settings(); string subDomain = objCurInfo.GetSubDomain(); String Inward_ACK_Needeed = string.Empty; Inward_ACK_Needeed = IConfig_Settings.GetConfigDefaultValue(_objCurrentInfo.GetCompanyCode(), CONFIG_TYPE.INWARD, CONFIG_KEY.INWARD_ACKNOWLEDGEMENT_NEEDED); string result = string.Empty; result = objBlRegion.InsertInwardExcelBulkUpload(objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), fileUpload, objCurInfo.GetUserCode(), subDomain, System.Net.Dns.GetHostName().ToString(), Convert.ToDateTime(InwardDate), Inward_ACK_Needeed); ViewBag.ErrorCode = result; return(View("InwardUploadExcelFile")); }
public string E_DetailingURL() { CurrentInfo _objCurrInfo = new CurrentInfo(); string E_DetailingURL = string.Empty; string LoginParams = string.Empty; try { //byte[] UserEncode=System.Text.Encoding.UTF8.GetBytes(_objCurrInfo.GetUserName()); //string UserName = Convert.ToBase64String(UserEncode); //byte[] SubDomainEncode = System.Text.Encoding.UTF8.GetBytes(_objCurrInfo.GetSubDomain()); //String SubDomain = Convert.ToBase64String(SubDomainEncode); string EDetailingRedirectUrl = _objCurrInfo.GetEDetailing(); CompanyDetails lstcompdetails = new CompanyDetails(); lstcompdetails.SubDomainName = _objCurrInfo.GetSubDomain(); lstcompdetails.UserName = _objCurrInfo.GetUserName(); LoginParams = JsonConvert.SerializeObject(lstcompdetails); byte[] LoginParamsEncode = System.Text.Encoding.UTF8.GetBytes(LoginParams); LoginParams = Convert.ToBase64String(LoginParamsEncode); if (!string.IsNullOrEmpty(EDetailingRedirectUrl)) { E_DetailingURL = "" + EDetailingRedirectUrl + "?SSID=" + LoginParams; } //if (!string.IsNullOrEmpty(EDetailingRedirectUrl)) //{ // E_DetailingURL = "" + EDetailingRedirectUrl + "?U=" + UserName + "&S=" + SubDomain; //} return(E_DetailingURL); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(string.Empty); } }
public ActionResult ExcellPayslipDataUpload(HttpPostedFileBase file, FormCollection collection) { DataControl.BLUser objBlUser = new BLUser(); DataControl.CurrentInfo objCurInfo = new CurrentInfo(); string subDomain = objCurInfo.GetSubDomain(); string result = string.Empty; string payslipMonth = collection["txtMonth"].ToString(); string payslipYear = collection["txtYear"].ToString(); string companyCode = objCurInfo.GetCompanyCode(); List <MVCModels.HiDoctor_Master.PayslipDataModel> lstdata = new List <MVCModels.HiDoctor_Master.PayslipDataModel>(); lstdata = (List <MVCModels.HiDoctor_Master.PayslipDataModel>)objBlUser.GetpayslipDetail(companyCode, payslipMonth, payslipYear); List <MVCModels.HiDoctor_Master.PayslipEmployeeDetail> lstEmpDetail = lstdata[0].lstEmpDetail; List <MVCModels.HiDoctor_Master.PayslipColunmDetail> lstColunmDetail = lstdata[0].lstpayslipColunm; List <MVCModels.HiDoctor_Master.PayslipDetails> lstDetail = lstdata[0].lstPayslipDetail; result = objBlUser.InsertPayslipDataUpload(objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, lstdata, subDomain, payslipMonth, payslipYear); ViewBag.ErrorCode = result; return(View("PayslipDataResult")); }
public string GetKangleURL() { CurrentInfo objCurInfo = new CurrentInfo(); string kangleUrl = string.Empty; try { string kangleRedirectionUrl = objCurInfo.GetKangleUrl(); string userName = objCurInfo.GetUserName(); string subdomain = objCurInfo.GetSubDomain(); if (!string.IsNullOrEmpty(kangleRedirectionUrl)) { kangleUrl = "" + kangleRedirectionUrl + "?cl=de&userName="******"&subdomainName=" + subdomain + "&lang=en-US"; } return(kangleUrl); } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); return(string.Empty); } }
public string ExecuteAPI(FormCollection coll) { try { string error = string.Empty; Repository.APIRepository objAPIRepo = new Repository.APIRepository(); //public string ExecuteService(string companyCode, string userName, System.Web.Mvc.FormCollection coll,string subDominName, out string error) string url = objAPIRepo.ExecuteService(_objCur.GetCompanyCode(), _objCur.GetUserName(), coll, _objCur.GetSubDomain(), out error); return(url); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); return(null); } }
public JsonResult PrimarySalesUpload() { string Calendardata = Request["CalendarMonth"]; string Type = Request["UploadType"]; string Monthname = Calendardata.Substring(0, Calendardata.IndexOf("-")); int SelectedMonth = DateTime.ParseExact(Monthname, "MMM", new CultureInfo("en-US")).Month; string Yearnumber = Calendardata.Substring(Calendardata.IndexOf("-") + 1); int SelectedYear = Int32.Parse(Yearnumber); int UploadType = Int32.Parse(Type); HttpFileCollectionBase file = Request.Files; if (Request.Files.Count > 0 && Request.Files[0].FileName.EndsWith(".xls")) { try { Ds = new DataSet(); Ds = ExcelImport.ImportExcelXML(Request.Files[0], true, false); // return Json(size); //DataSet dsMaster = new DataSet(); //dsMaster = Bl.GetPrimarySalesMasterData("MASTER_VALIDATE"); // Excel to temp table //File Name Validation //if (Ds_Validate.Tables[0].Rows.Count > 0) //{ // foreach (DataRow row_val in Ds_Validate.Tables[0].Rows) // { // //validating filename // if (file.FileName.ToString() == row_val["Uploaded_file_name"].ToString()) //&& // return Json("FileExists"); // } //} //Excel Row No check //Header sheet - column name Validation var xlHDRColumnNames = Ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray <string>(); string[] HeaderColumns = new string[] { "Depot_Name", "Region_Name", "Region_Ref_Key", "Stockiest_Name", "Stockiest_Ref_Key", "Document_Type_Name", "Document_Number", "Document_Date", "Product_Name", "Product_Ref_Key", "Batch_Number", "Net_Quantity", "Free_Quantity", "Net_Value", "Excel_Row_No" }; bool ValidHdrColumns = false; //if (xlHDRColumnNames.Any()) //{ // ValidHdrColumns = xlHDRColumnNames.SequenceEqual(HeaderColumns); // if (!ValidHdrColumns) // { // return Json("HeaderInvalidColumns"); // } //} for (int i = 0; i < xlHDRColumnNames.Length; i++) { for (int j = 0; j < HeaderColumns.Length; j++) { if (xlHDRColumnNames[i] == HeaderColumns[j]) { ValidHdrColumns = true; } } } if (!ValidHdrColumns) { return(Json("DetailsInvalidColumns")); } foreach (DataRow row_xl in Ds.Tables[0].Rows) { DateTime dtFormat; if ((!DateTime.TryParseExact(row_xl["Document_Date"].ToString().Trim(), "yyyy-MM-dd", new CultureInfo("en-GB"), DateTimeStyles.None, out dtFormat))) { //DataFormatInvalid = true; return(Json("Please update Date format should be YYYY-MM-DD")); } string docdate = row_xl["Document_Date"].ToString(); int docYear = Int32.Parse(docdate.Substring(0, docdate.IndexOf("-"))); string NameofMonth = DateTime.ParseExact(row_xl["Document_Date"].ToString(), "yyyy-MM-dd", null).ToString("MMMM"); int docMonth = DateTimeFormatInfo.CurrentInfo.MonthNames.ToList().IndexOf(NameofMonth) + 1; if (docMonth != SelectedMonth || docYear != SelectedYear) { return(Json("Month and Year Of Document Date in Excel Should be Same as Selected Month and Year in dropdown")); } } //Details sheet - column name Validation //var xlDTLColumnNames = Ds.Tables[1].Columns.Cast<DataColumn>().Select(x => x.ColumnName).ToArray<string>(); //string[] DetailColumns = new string[] {"Region_Name", "Depot_Name", "Stockiest_Ref_Key1", "Document_Type", // "Document_Number","Document_Date","Transaction_Mode","Product_Name","Product_Ref_Key1", // "Batch_Number", "Sales_Quantity", "Free_Quantity", "Sales_Rate"}; //bool ValidDTLColumns = true; //if (xlDTLColumnNames.Any()) //{ // ValidDTLColumns = xlDTLColumnNames.SequenceEqual(DetailColumns); // if (!ValidDTLColumns) // { // return Json("DetailInvalidColumns"); // } //} //asynchronous method call string CompanyCode = _objCurrentInfo.GetCompanyCode(); string UserCode = _objCurrentInfo.GetUserCode(); string ConnectionString = _objCurrentInfo.GetConnectionString(); string SubDomain = _objCurrentInfo.GetSubDomain(); string strGuid = Guid.NewGuid().ToString(); Task task = Task.Factory.StartNew(() => { if (PrimarySalesTempUpload(CompanyCode, Ds.Tables[0], UserCode, ConnectionString, strGuid) == true) { // ProcessPrimarySalesUpload(Ds, Ds_Validate, dsMaster, file.FileName.ToString(), CompanyCode, UserCode, ConnectionString, SubDomain); PrimarySalesValidation(CompanyCode, UserCode, strGuid, Request.Files[0].FileName.ToString(), ConnectionString, SelectedMonth, SelectedYear, UploadType); } }); return(Json("Uploaded")); } catch (Exception ex) { return(Json("Not Uploaded")); } finally { Ds.Dispose(); //Ds_Validate.Dispose(); } } else { return(Json("Invalid File")); } //return Json("Not Uploaded"); }
public void GetDistanceFareChartExcel() { try { List <DistanceFareChartModel> lstDFC = new List <DistanceFareChartModel>(); BLMaster _objMast = new BLMaster(); StringBuilder sbTableContentExcel = new StringBuilder(); string blobUrl = string.Empty, error = string.Empty; DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); lstDFC = _objMast.GetDistanceFareChart(_objCurr.GetCompanyCode()); var lstDistUserType = lstDFC.Select(x => new { x.User_Type_Code, x.User_Type_Name }).Distinct().ToList(); if (lstDFC != null && lstDFC.Count > 0) { //excel sbTableContentExcel.Append("<div style='font-size:14px;width:100%;font-weight:bold;float:left' align='left'>Distance Fare Chart</div>"); sbTableContentExcel.Append("<table class='table table-striped' id='tblDFC' cellspacing='0' cellpadding='0' border='1'>"); sbTableContentExcel.Append("<thead>"); sbTableContentExcel.Append("<tr>"); sbTableContentExcel.Append("<th>From Km</th>"); sbTableContentExcel.Append("<th>To Km</th>"); sbTableContentExcel.Append("<th>Fare Amount</th>"); sbTableContentExcel.Append("<th>User Type</th>"); sbTableContentExcel.Append("<th>Entity</th>"); sbTableContentExcel.Append("<th>Date From</th>"); sbTableContentExcel.Append("<th>Date To</th>"); sbTableContentExcel.Append("<th>Is Amount Fixed</th>"); sbTableContentExcel.Append("<th>Status</th>"); sbTableContentExcel.Append("</tr>"); sbTableContentExcel.Append("</thead>"); sbTableContentExcel.Append("<tbody>"); // foreach (var userType in lstDistUserType) { var lstDist = lstDFC.AsEnumerable().Where(x => x.User_Type_Code == userType.User_Type_Code); if (lstDist != null && lstDist.Count() > 0) { //excel sbTableContentExcel.Append("<tr><th class='collapseHeader' colspan='9'>" + userType.User_Type_Name + "</th></tr>"); // foreach (var item in lstDist) { // excel sbTableContentExcel.Append("<tr >"); sbTableContentExcel.Append("<td >" + item.From_Km.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.To_Km.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.Fare_Amount.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.User_Type_Name.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.Entity_Name.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.Date_From.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + item.Date_To.ToString() + "</td>"); sbTableContentExcel.Append("<td >" + ((item.Is_Amount_Fixed == "1") ? "Yes" : "No") + "</td>"); sbTableContentExcel.Append("<td >" + ((item.Status == 1) ? "Enabled" : "Disabled") + "</td>"); sbTableContentExcel.Append("</tr>"); // } } } //excel sbTableContentExcel.Append("</tbody></table>"); // } 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 = "DistanceFareChart_" + "_" + subDomin + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(sbTableContentExcel.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); } }