protected void btnImportList_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
List <Contact> listContact = new List <Contact>();
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
string FileName = txtNameFileUpload.Text;
string Extension = Path.GetExtension(FileName);
string FilePath = Server.MapPath(FolderPath + FileName);
if (FileName != "")
{
DataTable dt = ImportExcel.ImportExcel2DataTable(FilePath, Extension);
foreach (DataRow dr in dt.Rows)
{
Contact contact;
if (!ContactBusiness.checkContactIsExist(dr["Email"].ToString().Trim()))
{
contact = new Contact();
contact.Email = dr["Email"].ToString().Trim();
contact.FirstName = dr["FirstName"].ToString();
contact.LastName = dr["LastName"].ToString();
contact.FullName = dr["FullName"].ToString();
contact.Phone = dr["Phone"].ToString();
contact.Adress = dr["Address"].ToString();
if (dr["Gender"].ToString().Trim().ToUpper().Equals("NỮ"))
{
contact.Gender = 0;
}
else
{
contact.Gender = 1;
}
contact.Birthday = DateTime.Parse(dr["Birthday"].ToString());
listContact.Add(contact);
}
else
{
contact = db.Contacts.FirstOrDefault(x => x.Email == dr["Email"].ToString().Trim());
contact.Email = dr["Email"].ToString().Trim();
contact.FirstName = dr["FirstName"].ToString();
contact.LastName = dr["LastName"].ToString();
contact.FullName = dr["FullName"].ToString();
contact.Phone = dr["Phone"].ToString();
contact.Adress = dr["Address"].ToString();
if (dr["Gender"].ToString().Trim().ToUpper().Equals("NỮ"))
{
contact.Gender = 0;
}
else
{
contact.Gender = 1;
}
contact.Birthday = DateTime.Parse(dr["Birthday"].ToString());
}
}
if (listContact.Count > 0)
{
db.Contacts.AddRange(listContact);
}
db.SaveChanges();
gridView.DataBind();
}
else
{
String message = "Bạn chưa chọn file hoặc file này đang được mở!";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + message + "');", true);
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + HandleException.SqlExcforContact(v_e) + "');", true);
Debugger.Log(1, "Send Mail", "Failed: " + v_e);
}
}
