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 Column1 = Convert.ToString(row[0]);
string Column2 = Convert.ToString(row[1]);
string Column3 = Convert.ToString(row[2]);
string Column4 = "";
try
{
result = cls.InsertOFACSpeciallyDesignatedNationalsAndBlockedEntitiesData(Column1, Column2, Column3, Column4);
}
catch (Exception ex)
{
lblStatus.Text = "Operation Failed: " + ex.Message;
}
count++;
}
else
{
//if (row[0] == "Column1" && row[1] == "Column2" && row[2] == "Column3" && row[4] == "Column4") { }
//else { lblStatus.Text = "File Invalid Format."; break; }
}
}
}
catch (Exception ex)
{
lblStatus.Text = "Error : " + ex.Message + ")";
}
finally
{
GC.Collect();
}
}
//Internal Working End
if (lblStatus.Text == "File Invalid Format.")
{
}
else
{
//Message Appeared when file uploads completely.
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();
}
