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);
        }
Example #2
0
        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());
        }