protected void btnUpload_Click(object sender, EventArgs e)
{
if (FileUploadPayPak.HasFile)
{
string fileExtension = System.IO.Path.GetExtension(FileUploadPayPak.FileName);
if (fileExtension != ".csv")
{
lblStatus.Text = "Please Upload A File with CSV extension.";
trStatus.Visible = true;
}
else
{
try
{
//Uploaded File Saves on Server.
FileUploadPayPak.SaveAs(Server.MapPath("~/App_Data/" + FileUploadPayPak.FileName));
//Internal Working
//string str = "";
string fileName = "";
string filename = "";
lblStatus.Text = string.Empty;
fileName = Path.GetFileName(this.FileUploadPayPak.PostedFile.FileName);
fileName = FileUploadPayPak.FileName;
filename = base.Server.MapPath("~/App_Data") + "/" + fileName;
using (CsvFileReader reader = new CsvFileReader(filename))
{
int i = 0;
CsvRow row = new CsvRow();
try
{
int count = row.Count;
Debug.WriteLine("Total Rows:" + count);
while (reader.ReadRow(row))
{
i++;
if (i > 1)
{
int result = -1;
string FULL_NAME = Convert.ToString(row[1]);
string EMAIL = Convert.ToString(row[2]);
string PHONE = Convert.ToString(row[3]);
try
{
result = cls.InsertInvertorData(FULL_NAME, EMAIL, PHONE);
}
catch (Exception ex)
{
lblStatus.Text = "Operation Failed: " + ex.Message;
}
count++;
}
else
{
//if(row[0] == "FullName" && row[1] == "Email" && row[2] == "Phone") { }
//else { lblStatus.Text = "File Invalid Format."; lblFormat.Text = "Invalid File Format."; break; }
}
}
}
catch (Exception ex)
{
lblStatus.Text = "Error : " + ex.Message + ")";
}
finally
{
GC.Collect();
}
}
//Internal Working End
//Message Appeared when file uploads completely.
//if (lblFormat.Text == "Invalid File Format.")
//{
//}
//else
//{
lblStatus.Text = "File Uploaded Successfully.";
//}
trStatus.Visible = true;
}
catch (OutOfMemoryException ex)
{
lblStatus.Text = "Memory is not enough. Please delete old data and try again." + ex.Message;
trStatus.Visible = true;
}
catch (Exception ex)
{
lblStatus.Text = "Exception: " + ex.Message;
trStatus.Visible = true;
}
}
}
else
{
lblStatus.Text = "Please Upload A File.";
trStatus.Visible = true;
}
this.UpdatePanel1.Update();
}