private void GetBulkUploadedOrderProudcts() { try { DataTable dtResult = UploadOrderBAL.GetBulkUploadedOrderProudcts(Session[enumSessions.User_Name.ToString()].ToString()); dtResult.DefaultView.RowFilter = "Result = 'Success'"; dtResult.DefaultView.RowFilter = "Result = 'Success'"; rptUploadedProducts.DataSource = dtResult.DefaultView; rptUploadedProducts.DataBind(); dtResult.DefaultView.RowFilter = ""; dtResult.DefaultView.RowFilter = "Result <> 'Success'"; rptErrorProducts.DataSource = dtResult.DefaultView; rptErrorProducts.DataBind(); dtResult.DefaultView.RowFilter = ""; dtResult.DefaultView.RowFilter = "IsAnyDuplicate = true"; if (dtResult.DefaultView.Count > 0) { string script = "alertify.alert('" + ltrDuplicate.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } } catch (Exception objException) { using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { db.USP_SaveErrorDetails(Request.Url.ToString(), "GetBulkUploadedMultipleOrderProudcts", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Name.ToString()])); } } }
protected void btnProceed_Click(object sender, EventArgs e) { int resultVal = 0; try { if (rptUploadedProducts.Items.Count > 0) { int ARC_Id = Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()); int OrderId = Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()); bool IsARC_AllowReturns = Convert.ToBoolean(Session[enumSessions.IsARC_AllowReturns.ToString()].ToString()); string UserId = Convert.ToString(Session[enumSessions.User_Id.ToString()].ToString()); string userName = Session[enumSessions.User_Name.ToString()].ToString(); resultVal = UploadOrderBAL.UploadOrderItems(ARC_Id, OrderId, IsARC_AllowReturns, userName, UserId); Response.Redirect("Basket.aspx"); } else { string script = "alertify.alert('" + ltrUpload.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } } catch (Exception objException) { using (LinqToSqlDataContext db = new LinqToSqlDataContext()) { db.USP_SaveErrorDetails(Request.Url.ToString(), "btnProceed_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); } } }
protected void lnkbtnProduclist_Click(object sender, EventArgs e) { //birng products of users ARC List <string> ArcProducts = UploadOrderBAL.GetProductsByARCId(Convert.ToInt16(Session[enumSessions.ARC_Id.ToString()])); string Products = "PRODUCT NAMES"; DataTable table = new DataTable(); DataRow row; table.Columns.Add(Products); foreach (string item in ArcProducts) { row = table.NewRow(); row[Products] = item; table.Rows.Add(row); } StringBuilder csv = new StringBuilder(10 * table.Rows.Count * table.Columns.Count); for (int c = 0; c < table.Columns.Count; c++) { if (c > 0) { csv.Append(","); } DataColumn dc = table.Columns[c]; string columnTitleCleaned = CleanCSVString(dc.ColumnName); csv.Append(columnTitleCleaned); } csv.Append(Environment.NewLine); foreach (DataRow dr in table.Rows) { StringBuilder csvRow = new StringBuilder(); for (int c = 0; c < table.Columns.Count; c++) { if (c != 0) { csvRow.Append(","); } object columnValue = dr[c]; if (columnValue == null) { csvRow.Append(""); } else { string columnStringValue = columnValue.ToString(); string cleanedColumnValue = CleanCSVString(columnStringValue); if (columnValue.GetType() == typeof(string) && !columnStringValue.Contains(",")) { cleanedColumnValue = "=" + cleanedColumnValue; // Prevents a number stored in a string from being shown as 8888E+24 in Excel. Example use is the AccountNum field in CI that looks like a number but is really a string. } csvRow.Append(cleanedColumnValue); } } csv.AppendLine(csvRow.ToString()); } Response.ContentEncoding = Encoding.Default; Response.ContentType = "text/csv"; Response.AppendHeader("Content-Disposition", "attachment;filename=CSL_DualCom_ProductCodes.csv"); Response.Write(csv.ToString()); Response.End(); }
protected void btnUpload_Click(object sender, EventArgs e) { try { DataSet ds = new DataSet(); int MaxUploadProductsCount = 0; MaxUploadProductsCount = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MaxUploadProductsCount"]); String fileNameToUpload = String.Empty; if (fileUploadCon.HasFile) { string fileExt = Path.GetExtension(fileUploadCon.FileName); if (fileExt == ".xls" || fileExt == ".xlsx" || fileExt == ".txt" || fileExt == ".csv") { string fileNameWithoutExt = System.IO.Path.GetFileNameWithoutExtension(fileUploadCon.PostedFile.FileName); fileNameToUpload = fileNameWithoutExt + Session[enumSessions.User_Name.ToString()].ToString() + DateTime.Now.Ticks + fileExt; string dirfileNameWithPath = Server.MapPath("UploadedOrders") + "\\"; bool dirExisting = Directory.Exists(dirfileNameWithPath); if (!dirExisting) { Directory.CreateDirectory(dirfileNameWithPath); } string fileNameWithPath = dirfileNameWithPath + fileNameToUpload; fileUploadCon.SaveAs(fileNameWithPath); if (fileExt == ".xls" || fileExt == ".xlsx") { ds = ReadExcel(fileNameToUpload); if (ds.Tables[0].Rows.Count > MaxUploadProductsCount) { ltrUploadLimit.Text = "Not allowed to upload more then " + MaxUploadProductsCount.ToString() + " items."; string script = "alertify.alert('" + ltrUploadLimit.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); return; } } else if (fileExt == ".txt" || fileExt == ".csv") { ds = ReadCSV(fileNameToUpload); if (ds.Tables[0].Rows.Count > MaxUploadProductsCount) { ltrUploadLimit.Text = "Not allowed to upload more then " + MaxUploadProductsCount.ToString() + " items."; string script = "alertify.alert('" + ltrUploadLimit.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); return; } } if (File.Exists(fileNameWithPath)) { File.Delete(fileNameWithPath); } } else { string script = "alertify.alert('" + ltrFileType.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } } else { string script = "alertify.alert('" + ltrSelectFile.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { int ARC_Id = Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()); int OrderId = Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()); bool IsARC_AllowReturns = Convert.ToBoolean(Session[enumSessions.IsARC_AllowReturns.ToString()].ToString()); string UserId = Convert.ToString(Session[enumSessions.User_Id.ToString()].ToString()); string userName = Session[enumSessions.User_Name.ToString()].ToString(); DataTable dtResult = UploadOrderBAL.BulkUploadOrderProducts(ds, ARC_Id, OrderId, IsARC_AllowReturns, userName, UserId); dtResult.DefaultView.RowFilter = "Result = 'Success'"; rptUploadedProducts.DataSource = dtResult.DefaultView; rptUploadedProducts.DataBind(); hdnUploadedItems.Value = rptUploadedProducts.Items.Count.ToString(); dtResult.DefaultView.RowFilter = ""; dtResult.DefaultView.RowFilter = "Result <> 'Success'"; rptErrorProducts.DataSource = dtResult.DefaultView; rptErrorProducts.DataBind(); dtResult.DefaultView.RowFilter = ""; dtResult.DefaultView.RowFilter = "IsAnyDuplicate = true"; if (dtResult.DefaultView.Count > 0) { string script = "alertify.alert('" + ltrDuplicate.Text + "');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true); } } } catch (Exception objException) { CSLOrderingARCBAL.LinqToSqlDataContext db; db = new CSLOrderingARCBAL.LinqToSqlDataContext(); db.USP_SaveErrorDetails(Request.Url.ToString(), "btnUpload_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()])); } }