コード例 #1
0
 protected void btnExport_Click(object sender, EventArgs e)
 {
     using (XMLDatabaseEntities1 db = new XMLDatabaseEntities1())
     {
         List <EmployeeMaster> emList = db.EmployeeMaster.ToList();
         if (emList.Count > 0)
         {
             var xEle = new XElement("Employees",
                                     from emp in emList
                                     select new XElement("Employee",
                                                         new XElement("EmployeeID", emp.EmployeeID),
                                                         new XElement("CompanyName", emp.CompanyName),
                                                         new XElement("ContactName", emp.ContactName),
                                                         new XElement("ContactTitle", emp.ContactTitle),
                                                         new XElement("EmployeeAddress", emp.EmployeeAddress),
                                                         new XElement("PostalCode", emp.PostalCode)
                                                         ));
             HttpContext context = HttpContext.Current;
             context.Response.Write(xEle);
             context.Response.ContentType = "aplication/xml";
             context.Response.AppendHeader("Content-disposition", "atachment; filename=EmployeeData.xml");
             context.Response.End();
         }
     }
 }
コード例 #2
0
 private void PopulateData()
 {
     using (XMLDatabaseEntities1 db = new XMLDatabaseEntities1())
     {
         gvData.DataSource = db.EmployeeMaster.ToList();
         gvData.DataBind();
     }
 }
コード例 #3
0
 protected void btnImport_Click(object sender, EventArgs e)
 {
     if (FileUpload1.PostedFile.ContentType == "aplication/xml" || FileUpload1.PostedFile.ContentType == "text/xml")
     {
         string fileName;
         IList <EmployeeMaster> emList;
         try
         {
             fileName = Path.Combine(Server.MapPath("~/UploadDocuments"), Guid.NewGuid().ToString() + ".xml");
             FileUpload1.PostedFile.SaveAs(fileName);
         }
         catch (Exception)
         {
             throw;
         }
         try {
             XDocument xDoc = XDocument.Load(fileName);
             emList = xDoc.Descendants("Employee").Select(d =>
                                                          new EmployeeMaster
             {
                 EmployeeID      = d.Element("EmployeeID").Value,
                 CompanyName     = d.Element("CompanyName").Value,
                 ContactName     = d.Element("ContactName").Value,
                 ContactTitle    = d.Element("ContactTitle").Value,
                 EmployeeAddress = d.Element("EmployeeAddress").Value,
                 PostalCode      = d.Element("PostalCode").Value
             }).ToList();
             //Update Data
         }
         catch (Exception)
         {
             throw;
         }
         try
         {
             using (XMLDatabaseEntities1 db = new XMLDatabaseEntities1())
             {
                 foreach (var i in emList)
                 {
                     var v = db.EmployeeMaster.Where(a => a.EmployeeID.Equals(i.EmployeeID)).FirstOrDefault();
                     if (v != null)
                     {
                         v.CompanyName     = i.CompanyName;
                         v.ContactName     = i.ContactName;
                         v.ContactTitle    = i.ContactTitle;
                         v.EmployeeAddress = i.EmployeeAddress;
                         v.PostalCode      = i.PostalCode;
                     }
                     else
                     {
                         db.EmployeeMaster.Add(i);
                     }
                 }
                 db.SaveChanges();
             }
         }
         catch (Exception)
         {
             throw;
         }
         try
         {
             PopulateData();
             lbMessage.Text = "Import done Successfully";
         }
         catch (Exception)
         {
             throw;
         }
     }
 }