public void DownloadPrimarySalesExcelTemplate(string ddlValue)
{
try
{
string Monthname = ddlValue.Substring(0, ddlValue.IndexOf("-"));
int Month = DateTime.ParseExact(Monthname, "MMM", new CultureInfo("en-US")).Month;
string Yearnumber = ddlValue.Substring(ddlValue.IndexOf("-") + 1);
int Year = Int32.Parse(Yearnumber);
Ds = new DataSet();
DataTable dtHelpContent = new DataTable();
DataRow drLines;
dtHelpContent.Columns.Add("Instructions");
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "1.Please Download the primary sales Master Data";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "2. Please Download the primary sales excel Template for upload";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "3.Do not enter above 500 characters in Excel sheet columns on upload template";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "4.Do not alter the excel file structure(i.e.adding or removing the column)";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "5.Do not rename the columns";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "6.Click the “Choose/Browse file” button to get the file";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "7.Click the upload button to upload the data";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "8.Please do not modify the Row_No column values";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "9.Please Enter document_Date in YYYY-MM-DD format";
dtHelpContent.Rows.Add(drLines);
drLines = dtHelpContent.NewRow();
drLines["Instructions"] = "10.Please do not use WRAPTEXT/ALT+ENTER while enter the values. If you use then system will consider this as a special character.";
dtHelpContent.Rows.Add(drLines);
Ds = Bl.GetPrimarySalesMasterData("TEMP", Month, Year);
Ds.Tables.Add(dtHelpContent);
Ds.Tables[0].TableName = "Primary sales Header";
// Ds.Tables[1].TableName = "Primary sales Details";
Ds.Tables[1].TableName = "Help";
HttpResponse response = System.Web.HttpContext.Current.Response;
DownloadExcel excel = new DownloadExcel();
excel.Convert(Ds, "Primary_sales_upload_template" + "_" + DateTime.Now.ToShortDateString(), response);
}
finally
{
Ds.Dispose();
}
}
/// <summary>
/// Excel Download Active Products from Product Master
/// </summary>
public void GetActiveProducts()
{
DataControl.BLRegion objBlRegion = new BLRegion();
string companyCode = _objCurrentInfo.GetCompanyCode();
DataSet Ds = new DataSet();
Ds = objBlRegion.GetActiveProducts(companyCode);
Ds.Tables[0].TableName = "Product Details";
HttpResponse response = System.Web.HttpContext.Current.Response;
DownloadExcel excel = new DownloadExcel();
excel.Convert(Ds, "Product_Master_Data" + "_" + DateTime.Now.ToShortDateString(), response);
}
public void DownloadSubList()
{
DataControl.BLUser objUser = new BLUser();
DataControl.CurrentInfo objCurInfo = new CurrentInfo();
string companyCode = objCurInfo.GetCompanyCode();
DataSet Ds = new DataSet();
Ds = objUser.DownloadSubList(companyCode);
Ds.Tables[0].TableName = "State Details";
Ds.Tables[1].TableName = "City Details";
Ds.Tables.RemoveAt(3);
Ds.Tables.RemoveAt(2);
HttpResponse response = System.Web.HttpContext.Current.Response;
DownloadExcel excel = new DownloadExcel();
excel.Convert(Ds, "State_City" + "_" + DateTime.Now.ToShortDateString(), response);
}
public void DownloadPrimarySalesMasterExcelTemplate(string ddlValue)
{
string Monthname = ddlValue.Substring(0, ddlValue.IndexOf("-"));
int Month = DateTime.ParseExact(Monthname, "MMM", new CultureInfo("en-US")).Month;
string Yearnumber = ddlValue.Substring(ddlValue.IndexOf("-") + 1);
int Year = Int32.Parse(Yearnumber);
Ds = new DataSet();
Ds = Bl.GetPrimarySalesMasterData("MASTER", Month, Year);
Ds.Tables[0].TableName = "Region Details";
Ds.Tables[1].TableName = "Customer Details";
Ds.Tables[2].TableName = "Product Details";
Ds.Tables[3].TableName = "Depot Details";
Ds.Tables[4].TableName = "Document Type Details";
HttpResponse response = System.Web.HttpContext.Current.Response;
DownloadExcel excel = new DownloadExcel();
excel.Convert(Ds, "Primary_Sales_Master_Data" + "_" + DateTime.Now.ToShortDateString(), response);
}
public void DownloadMasterList()
{
DataControl.BLUser objUser = new BLUser();
DataControl.CurrentInfo objCurInfo = new CurrentInfo();
string companyCode = objCurInfo.GetCompanyCode();
DataSet Ds = new DataSet();
Ds = objUser.DownloadMasterList(companyCode);
Ds.Tables[0].TableName = "Region Details";
Ds.Tables[1].TableName = "Region Type Details";
Ds.Tables[2].TableName = "Region Classification Details";
Ds.Tables[3].TableName = "Expense Group Details";
Ds.Tables[4].TableName = "Price Group Details";
Ds.Tables[5].TableName = "State Details";
Ds.Tables[6].TableName = "City Details";
HttpResponse response = System.Web.HttpContext.Current.Response;
DownloadExcel excel = new DownloadExcel();
excel.Convert(Ds, "Master_List" + "_" + DateTime.Now.ToShortDateString(), response);
}