public StringBuilder GetInwardExcelDataUserBased(string users_Json, string product_Json, string product_type_name, string division_name) { try { CreateFileName(product_type_name, division_name); string company_code = _objCurrentInfo.GetCompanyCode(); string[] hiddenColumns = new string[] { }; string[] editableColumnNames = new string[] { }; string[] hiddenColumnNames = new string[] { }; _objExcelConverter = new ExcelFactory(); BLMaster objBlMaster = new BLMaster(); DataSet dsInwardExcelData = new DataSet(); dsInwardExcelData = objBlMaster.GetInwardExcelDataUserBased(company_code, users_Json, product_Json); if (dsInwardExcelData.Tables != null && dsInwardExcelData.Tables[0].Rows != null && dsInwardExcelData.Tables[0].Rows.Count > 0) { dsInwardExcelData.Tables[0].Columns.Add("Quantity", typeof(string)); DataRowCollection dr = dsInwardExcelData.Tables[0].Rows; DataColumnCollection dc = dsInwardExcelData.Tables[0].Columns; _objExcelConverter.DataSetToExcel(DOWNLOAD_PATH_KEY_NAME, _fileNameString.ToString(), dsInwardExcelData, hiddenColumnNames, hiddenColumns, false, editableColumnNames); } else { StringBuilder str = new StringBuilder("No Data Found."); return(str); } StringBuilder MasterfilenameStrings = GetInwardLookupValuesExcel(); return(_fileNameString.Append("^").Append(MasterfilenameStrings)); } catch (Exception ex) { return(_fileNameString.Append(ex.Message)); } }
private string GetProductMasterExcel(DataSet dsProdMaster) { string company_code = _objCurrentInfo.GetCompanyCode(); string[] hiddenColumns = new string[] { }; string[] editableColumnNames = new string[] { }; string[] hiddenColumnNames = new string[] { }; _objExcelConverter = new ExcelFactory(); _objExcelConverter.DataSetToExcel(DOWNLOAD_PATH_KEY_NAME, PRODUCT_MASTER_FILE_NAME, dsProdMaster, hiddenColumnNames, hiddenColumns, false, editableColumnNames); return(PRODUCT_MASTER_FILE_NAME); }
private string GetEmployeeMasterExcel(DataSet dsEmployeeMaster) { string fileNamewithPath = string.Empty; try { string company_code = _objCurrentInfo.GetCompanyCode(); string[] hiddenColumns = new string[] { }; string[] editableColumnNames = new string[] { }; string[] hiddenColumnNames = new string[] { }; _objExcelConverter = new ExcelFactory(); _objExcelConverter.DataSetToExcel(DOWNLOAD_PATH_KEY_NAME, EMPLOYEE_USER_MASTER_FILE_NAME, dsEmployeeMaster, hiddenColumnNames, hiddenColumns, false, editableColumnNames); return(EMPLOYEE_USER_MASTER_FILE_NAME); } catch (Exception ex) { return(ex.Message); } }