public ActionResult Create(ContactLink contactlink) { if (ModelState.IsValid) { db.ContactLinks.Add(contactlink); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.ContactId = new SelectList(db.Contacts, "ContactId", "Email", contactlink.ContactId); ViewBag.NPOId = new SelectList(db.NPOes, "NPOID", "Name", contactlink.NPOId); ViewBag.VolunteerId = new SelectList(db.Volunteers, "VolunteerId", "SignUpPartyId", contactlink.VolunteerId); return View(contactlink); }
public ActionResult Create(NPOContact npoContact) { if (ModelState.IsValid) { var npoResult = db.NPOes.Add(npoContact.NPO); if (ContainsValues.Contact(npoContact.Contact)) { var npoContactResult = db.Contacts.Add(npoContact.Contact); ContactLink contactLink = new ContactLink() { NPO = npoResult, Contact = npoContactResult }; var contatctLinkResult = db.ContactLinks.Add(contactLink); } db.SaveChanges(); return RedirectToAction("Index"); } return View(npoContact); }
public ActionResult Index(HttpPostedFileBase fUpload) { OleDbConnection objConn = null; OleDbCommand objCmd = null; OleDbDataAdapter objAdapter = null; DataSet ds = null; if (fUpload != null) { try { string sPath = System.IO.Path.Combine(Server.MapPath("~/Downloads"), System.IO.Path.GetFileName(fUpload.FileName)); fUpload.SaveAs(sPath); ViewBag.Message = "File upload Successful!"; // EXCEL IMPORT //string sConn = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + sPath + "; Extended Properties=Excel 8.0;"; //using (objConn = new System.Data.OleDb.OleDbConnection(sConn)) //{ // objConn.Open(); // objCmd = new OleDbCommand("Select * From [My Attendees$]", objConn); // objAdapter = new OleDbDataAdapter(objCmd); // ds = new DataSet("Attendees"); // objAdapter.Fill(ds); // objConn.Close(); //} // CSV OR PLAIN TEXT IMPORT //string sLine = string.Empty; //System.IO.StreamReader sReader = new System.IO.StreamReader(sPath); //while ((sLine = sReader.ReadLine()) != null) //{ // //Response.Write(sLine); //} //sReader.Close(); //sReader = null; //CSV IMPORT USING OLEDB FOR DATASET string sConn = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("~/Downloads") + "; Extended Properties=text;"; using (objConn = new System.Data.OleDb.OleDbConnection(sConn)) { objConn.Open(); objCmd = new OleDbCommand("Select * From [" + System.IO.Path.GetFileName(fUpload.FileName) + "]", objConn); objAdapter = new OleDbDataAdapter(objCmd); ds = new DataSet("Attendees"); objAdapter.Fill(ds); objConn.Close(); } //GCBLL.VolunteerImport objVolunteer = new GCBLL.VolunteerImport(); //objVolunteer.ImportVolunteerInformation(ds); foreach (DataRow dRow in ds.Tables[0].Rows) { Volunteer objVol = new Volunteer(); objVol.FirstName = dRow["First name"].ToString(); objVol.LastName = dRow["Last name"].ToString(); objVol.SignUpPartyId = dRow["Attendee #"].ToString(); if (dRow["Date"] != null) objVol.SignUpDate = (Convert.ToDateTime(dRow["Date"])); Contact objContact = new Contact(); objContact.Email = dRow["Email"].ToString(); objContact.PhoneNumber = dRow["Cell Phone"].ToString(); //var updateVol = db.Volunteers.Where(n => n.SignUpPartyId == objVol.SignUpPartyId); var id = (from Volunteer in db.Volunteers.Where(n => n.SignUpPartyId == objVol.SignUpPartyId) select Volunteer.VolunteerId).SingleOrDefault(); if ((id != null) && (id > 0)) { Volunteer volunteer = db.Volunteers.Find(Int32.Parse(id.ToString())); db.Volunteers.Remove(volunteer); } var volResult = db.Volunteers.Add(objVol); var contactResult = db.Contacts.Add(objContact); ContactLink obj = new ContactLink() { Volunteer = volResult, Contact = contactResult }; //bool bValid = false; //foreach (Volunteer vol in db.Volunteers) //{ // var valid = db.Volunteers.Select(n => vol.SignUpPartyId); // if (vol.SignUpPartyId != objVol.SignUpPartyId) // { // bValid = true; // break; // } //} //if (!(Helpers.VolunteerHelper.hasVolunteer(objVol, db.Volunteers.ToList()))) //{ // var volResult = db.Volunteers.Add(objVol); // var contactResult = db.Contacts.Add(objContact); // ContactLink obj = new ContactLink() // { // Volunteer = volResult, // Contact = contactResult // }; //} //else //{ // if (ModelState.IsValid) // { // db.Entry(objVol).State = EntityState.Modified; // db.Entry(objVol).CurrentValues.SetValues(objVol); // } //} } db.SaveChanges(); } catch (Exception ex) { ViewBag.Message = ex.Message; } finally { if ((objConn != null)) { objConn.Close(); } } } return View(db.Volunteers.ToList()); }