protected void btnimport_OnClick(object sender, EventArgs e)
{
StreamReader reader = null;
string path = HttpContext.Current.Server.MapPath(WebConfigurationManager.AppSettings["attachmentPath"] +
"/tempCSV/");
try
{
FileUpload customerCSV = new FileUpload();
customerCSV = FileUpload1;
if (customerCSV.HasFile)
{
string chkExtension = Path.GetExtension(customerCSV.FileName);
// string ppImg = ImgID + Path.GetExtension(productImg.FileName);
if (chkExtension.ToLower() == ".csv")
{
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
String userId = LumexSessionManager.Get("ActiveUserId").ToString();
path = path + @"\cr" + userId + ".csv";
customerCSV.PostedFile.SaveAs(path);
//need to implement here.
reader = new StreamReader(File.OpenRead(path));
int linecount = 0;
//int dupcount = 0;
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
if (linecount != 0)
{
var pinfos = line.Split(',');
CustomerBLL customer = new CustomerBLL();
customer.CustomerName = pinfos[0];
customer.ContactNumber = pinfos[1];
customer.Email = pinfos[2];
customer.Country = "";
customer.District = "";
customer.PostalCode = "";
customer.NationalId = "";
customer.PassportNumber = "";
customer.JoiningSalesCenterId = pinfos[3];
customer.City = pinfos[4];
customer.Address = pinfos[5];
DataTable dt = customer.SaveCustomer();
//dupcount++; }
}
linecount++;
//reader.Close();
}
linecount--;
if (linecount > 0)
{
string message =
"Customer <span class='actionTopic'></span> Successfully import " + linecount +
" Customers.<span class='actionTopic'></span>.";
MyAlertBox(
"var callbackOk = function () { MyOverlayStop(); window.location = \"/UI/Customer/List.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
}
else
{
string message = "Only CSV File is allowed";
MyAlertBox("WarningAlert(\"" + "Validation" + "\", \"" + message + "\");");
}
}
else
{
string message = " <span class='actionTopic'>" + "You are Not select any CSV file!</span>.";
MyAlertBox("WarningAlert(\"" + "Validation" + "\", \"" + message + "\");");
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
if (reader != null)
{
reader.Close();
File.Delete(path);
}
}
}
//protected void LoadSalesCenters()
//{
// SalesCenterBLL salesCenter = new SalesCenterBLL();
// try
// {
// DataTable dt = salesCenter.GetActiveSalesCenterList();
// joiningSalesCenterDropDownList.DataSource = dt;
// joiningSalesCenterDropDownList.DataValueField = "SalesCenterId";
// joiningSalesCenterDropDownList.DataTextField = "SalesCenterName";
// joiningSalesCenterDropDownList.DataBind();
// joiningSalesCenterDropDownList.Items.Insert(0, "");
// joiningSalesCenterDropDownList.SelectedIndex = 0;
// if (dt.Rows.Count < 1)
// {
// msgbox.Visible = true; msgTitleLabel.Text = "Joining Sales Center Data Not Found!!!"; msgDetailLabel.Text = "";
// msgbox.Attributes.Add("class", "alert alert-warning");
// }
// }
// catch (Exception ex)
// {
// string message = ex.Message;
// if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
// MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
// }
// finally
// {
// salesCenter = null;
// }
//}
protected void saveButton_Click(object sender, EventArgs e)
{
CustomerBLL customer = new CustomerBLL();
try
{
if (customerNameTextBox.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Customer Name field is required.";
}
else if (addressTextBox.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Address field is required.";
}
//else if (joiningSalesCenterDropDownList.Text == "")
//{
// msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Joining Sales Center field is required.";
//}
else
{
customer.CustomerName = customerNameTextBox.Text.Trim();
customer.ContactNumber = contactNumberTextBox.Text.Trim();
customer.Email = emailTextBox.Text.Trim();
customer.Country = "";
customer.City = cityTextBox.Text.Trim();
customer.District = "";
customer.PostalCode = "";
customer.Address = addressTextBox.Text.Trim();
customer.NationalId = ""; //nationalIdTextBox.Text.Trim();
customer.PassportNumber = "";//passportNumberTextBox.Text.Trim();
customer.JoiningSalesCenterId = WarehouesDropDownList.SelectedValue.Trim();
customer.Description = txtbxDescription.Text.Trim();
DataTable dt = customer.SaveCustomer();
if (dt.Rows.Count > 0)
{
string message = "Customer <span class='actionTopic'>Created</span> Successfully with Customer ID: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/Customer/crateRetail.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
CleartField();
}
else
{
string message = "<span class='actionTopic'>Failed</span> to Create Customer.";
MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");");
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
customer = null;
}
}