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);
}
}
