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