private void GetBulkUploadOrderedItems()
{
try
{
DataSet dsResult = UploadMultipleOrdersBAL.GetBulkUploadOrderItems(Session[enumSessions.User_Name.ToString()].ToString());
if (dsResult.Tables.Count > 1)
{
if (dsResult.Tables[0].Rows.Count > 0)
{
rptBasketItems.DataSource = dsResult.Tables[0];
rptBasketItems.DataBind();
divBasketItems.Visible = true;
btnProceed.Visible = true;
}
else
{
divBasketItems.Visible = false;
}
}
}
catch (Exception objException)
{
using (LinqToSqlDataContext db = new LinqToSqlDataContext())
{
db.USP_SaveErrorDetails(Request.Url.ToString(), "GetBulkUploadOrderedItems", 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)
{
try
{
if (rptUploadedProducts.Items.Count > 0 && rptBasketItems.Items.Count > 0)
{
int resultVal = 0;
int ARC_Id = Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString());
string UserId = Convert.ToString(Session[enumSessions.User_Id.ToString()].ToString());
resultVal = UploadMultipleOrdersBAL.CreateUplaodedMultipleOrders(ARC_Id, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), UserId, chkDuplicatesAllowed.Checked);
Response.Redirect("UploadMultipleOrdersCheckout.aspx");
}
else if (rptUploadedProducts.Items.Count > 0)
{
LinqToSqlDataContext db = new LinqToSqlDataContext();
var data = db.BulkUploadMultipleOrders.Where(items => items.IsAnyDuplicate == false && items.Result == "Success");
if (!chkDuplicatesAllowed.Checked && data.ToList().Count == 0)
{
string script = "alertify.alert('" + ltrAllItemsDuplicated.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
int resultVal = 0;
int ARC_Id = Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString());
string UserId = Convert.ToString(Session[enumSessions.User_Id.ToString()].ToString());
resultVal = UploadMultipleOrdersBAL.CreateUplaodedMultipleOrders(ARC_Id, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), UserId, chkDuplicatesAllowed.Checked);
Response.Redirect("UploadMultipleOrdersCheckout.aspx", false);
}
else if (rptBasketItems.Items.Count > 0)
{
Response.Redirect("UploadMultipleOrdersCheckout.aspx", false);
}
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_Name.ToString()]));
}
}
}
private void GetBulkUploadedMultipleOrderProudcts()
{
try
{
divDuplicatesAllowed.Visible = false;
DataTable dtResult = UploadMultipleOrdersBAL.GetBulkUploadedMultipleOrderProudcts(Session[enumSessions.User_Name.ToString()].ToString());
dtResult.DefaultView.RowFilter = "Result = 'Success'";
if (dtResult.DefaultView.Count > 0)
{
divValidProducts.Visible = true;
rptUploadedProducts.DataSource = dtResult.DefaultView;
rptUploadedProducts.DataBind();
trUploadedProducts.Visible = true;
btnProceed.Visible = true;
}
dtResult.DefaultView.RowFilter = "";
dtResult.DefaultView.RowFilter = "Result <> 'Success'";
if (dtResult.DefaultView.Count > 0)
{
divNotValidProducts.Visible = true;
rptErrorProducts.DataSource = dtResult.DefaultView;
rptErrorProducts.DataBind();
trCouldNotUpload.Visible = true;
}
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);
divDuplicatesAllowed.Visible = 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 btnUpload_Click(object sender, EventArgs e)
{
try
{
//divLoader.Style.Add("display","block");
DataSet ds = new DataSet();
String fileNameToUpload = String.Empty;
if (fileUploadCon.HasFile)
{
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "showProgressBar(1);", true);
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 > 250)
{
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 > 250)
{
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());
bool IsARC_AllowReturns = Convert.ToBoolean(Session[enumSessions.IsARC_AllowReturns.ToString()].ToString());
string UserId = Convert.ToString(Session[enumSessions.User_Id.ToString()].ToString());
DataTable dtResult = UploadMultipleOrdersBAL.UplaodMultipleOrderProduct(ds, ARC_Id, Session[enumSessions.User_Name.ToString()].ToString(), Session[enumSessions.User_Email.ToString()].ToString(), UserId);
dtResult.DefaultView.RowFilter = "Result = 'Success'";
if (dtResult.DefaultView.Count > 0)
{
divValidProducts.Visible = true;
rptUploadedProducts.DataSource = dtResult.DefaultView;
rptUploadedProducts.DataBind();
trUploadedProducts.Visible = true;
btnProceed.Visible = true;
}
dtResult.DefaultView.RowFilter = "";
dtResult.DefaultView.RowFilter = "Result <> 'Success'";
if (dtResult.DefaultView.Count > 0)
{
divNotValidProducts.Visible = true;
rptErrorProducts.DataSource = dtResult.DefaultView;
rptErrorProducts.DataBind();
trCouldNotUpload.Visible = true;
}
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);
divDuplicatesAllowed.Visible = true;
}
}
}
catch (Exception objException)
{
using (LinqToSqlDataContext db = new 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()]));
}
}
}
