protected void btnImport_Click(object sender, EventArgs e)
{
if (fuFile.HasFile)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
fuFile.SaveAs(Server.MapPath("~/assets/import/region/" + fuFile.FileName));
StreamReader sr = new StreamReader(Server.MapPath("~/assets/import/region/" + fuFile.FileName));
try
{
CsvReader csvread = new CsvReader(sr);
csvread.Configuration.Delimiter = ";";
csvread.Configuration.HasHeaderRecord = true;
List <CSV_Province> record = csvread.GetRecords <CSV_Province>().ToList();
int totalRead = 0;
int totalInsert = 0;
foreach (var item in record)
{
totalRead++;
if (db.TBCountries.Where(X => X.IDCountry == item.IDCountry).FirstOrDefault() != null)
{
if (db.TBProvinces.Where(x => x.Name.ToLower() == item.Name.ToLower()).FirstOrDefault() == null)
{
TBProvince newProvince = new TBProvince {
IDCountry = item.IDCountry, Name = item.Name, Deflag = false, DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now
};
db.TBProvinces.InsertOnSubmit(newProvince);
totalInsert++;
}
}
}
db.SubmitChanges();
sr.Close();
lblSuccess.Text = totalRead + " row(s) read, " + totalInsert + " row(s) inserted";
alertError.Style.Add(HtmlTextWriterStyle.Display, "none");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "block");
}
catch (Exception ex)
{
sr.Close();
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
private int ImportProvince(string name, int idCountry)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var existData = db.TBProvinces.Where(x => !x.Deflag && x.Name.ToLower() == name.ToLower()).FirstOrDefault();
if (existData == null)
{
TBProvince newData = new TBProvince();
newData.IDCountry = idCountry;
newData.Name = name;
newData.Deflag = false;
newData.DateInsert = DateTime.Now;
newData.DateLastUpdate = DateTime.Now;
db.TBProvinces.InsertOnSubmit(newData);
db.SubmitChanges();
existProvince = false;
return(newData.IDProvince);
}
else
{
if (existData.IDCountry == idCountry)
{
return(existData.IDProvince);
}
else
{
TBProvince newData = new TBProvince();
newData.IDCountry = idCountry;
newData.Name = name;
newData.Deflag = false;
newData.DateInsert = DateTime.Now;
newData.DateLastUpdate = DateTime.Now;
db.TBProvinces.InsertOnSubmit(newData);
db.SubmitChanges();
existProvince = false;
return(newData.IDProvince);
}
}
}
catch (Exception)
{
throw;
}
}
