private void Validate(Shipment model) { if (model.ContactId < 1) ModelState.AddModelError("ContactId", "Please select a valid Contact from the auto complete choices"); if (model.TitleId < 1) ModelState.AddModelError("TitleId", "Please select a valid Title from the auto complete choices"); if (!ModelState.IsValid) ModelState.AddModelError(string.Empty, "Please fix the errors below."); }
public List<Shipment> CreateShipmentCollection() { List<Shipment> shipments = new List<Shipment>(); foreach (int titleId in SelectedTitles) { foreach (int contactId in SelectedContacts) { Shipment shipment = new Shipment(); shipment.Status = Status; shipment.Type = Type; shipment.DateSent = DateSent; shipment.Quantity = Quantity; shipment.ShouldFollowUp = ShouldFollowUp; shipment.ContactId = contactId; shipment.TitleId = titleId; shipments.Add(shipment); } } return shipments; }
private void LoadLists(Shipment model) { var titleId = model.TitleId.ToString(); var titleName = string.IsNullOrEmpty(model.TitleName) ? "Search for a Title" : model.TitleName; var contactId = model.ContactId.ToString(); var contactName = string.IsNullOrEmpty(model.ContactName) ? "Search for a Contact" : model.ContactName; var contacts = new List<SelectListItem> { new SelectListItem { Text = contactName, Value = contactId } }; var titles = new List<SelectListItem> { new SelectListItem { Text = titleName, Value = titleId } }; model.Contacts = new SelectList(contacts, "Value", "Text", null); model.Titles = new SelectList(titles, "Value", "Text", null); }
private void ParseQueryString(HttpRequestBase Request, Shipment model, bool isCreate) { model.Redirect = string.Empty; if (!string.IsNullOrEmpty(Request.QueryString["title"])) { model.Redirect = "title"; if (isCreate) { model.TitleId = Convert.ToInt32(Request.QueryString["title"]); model.TitleName = reviewData.GetTitleDisplayNameById(model.TitleId); } } else if (!string.IsNullOrEmpty(Request.QueryString["contact"])) { model.Redirect = "contact"; if (isCreate) { model.ContactId = Convert.ToInt32(Request.QueryString["contact"]); model.ContactName = reviewData.GetContactDisplayNameById(model.ContactId); } } }
public ActionResult Edit(Shipment model) { LoadLists(model); Validate(model); if (ModelState.IsValid) { data.Update(model, (Session["LoggedInUser"] as user).id); TempData["SuccessMessage"] = string.Format("Shipment was updated."); if (model.Redirect == "title") return RedirectToAction("Edit", "Title", new { id = model.TitleId }); if (model.Redirect == "contact") return RedirectToAction("Edit", "Contact", new { id = model.ContactId }); return RedirectToAction("Search"); } return View(model); }
/// <summary> /// CRUD /// </summary> public Shipment GetById(int id) { var model = dbContext.shipments.FirstOrDefault(x => x.id == id); if (model == null) return null; Shipment shipment = new Shipment { Id = model.id, TitleId = model.title_id, TitleName = model.shipment_title.title1, TitlePubDate = model.shipment_title.date_published, ContactId = model.contact_id, ContactName = model.shipment_contact.firstname + " " + model.shipment_contact.lastname + " (" + (model.shipment_contact.is_primary ? model.shipment_contact.organization : model.shipment_contact.organization_alt) + ")", DateSent = model.date_sent, Quantity = model.quantity, ShouldFollowUp = model.should_followup, Status = model.status, Type = model.type, LastUpdated = string.Format("{0} at {1}", model.shipment_user.username, model.updatedat.ToShortDateString()) }; shipment.TitleName = shipment.TitleName + " (" + shipment.TitlePubDate.ToShortDateString() + ")"; return shipment; }
public void Update(Shipment model, int updatedby) { var obj = dbContext.shipments.First(x => x.id == model.Id); { obj.title_id = model.TitleId; obj.contact_id = model.ContactId; obj.date_sent = model.DateSent; obj.quantity = model.Quantity; obj.should_followup = model.ShouldFollowUp; obj.status = model.Status; obj.type = model.Type; obj.updatedat = DateTime.Now; obj.updatedby = updatedby; dbContext.SaveChanges(); } }
public void Insert(Shipment model, int createdBy) { var obj = new shipment { title_id = model.TitleId, contact_id = model.ContactId, date_sent = model.DateSent, quantity = model.Quantity, should_followup = model.ShouldFollowUp, status = model.Status, type = model.Type, createdat = DateTime.Now, createdby = createdBy, updatedat = DateTime.Now, updatedby = createdBy, }; dbContext.shipments.Add(obj); dbContext.SaveChanges(); }
public void CanMigrateTitles() { Dictionary<int, int> contactMap = new Dictionary<int, int>(); Dictionary<int, int> titleMap = new Dictionary<int, int>(); WavePoetry.DataAccess.TitleData titles = new WavePoetry.DataAccess.TitleData(); WavePoetry.DataAccess.ReviewData reviews = new WavePoetry.DataAccess.ReviewData(); WavePoetry.DataAccess.ShipmentData shipments = new WavePoetry.DataAccess.ShipmentData(); WavePoetry.DataAccess.ContactData contacts = new WavePoetry.DataAccess.ContactData(); WavePoetry.DataAccess.AdminData adminData = new WavePoetry.DataAccess.AdminData(); WavePoetry.OldDataAccess.waveoldEntities dbContext = new WavePoetry.OldDataAccess.waveoldEntities(); //////////// /// TITLES /// ////// var oldTitles = dbContext.titles.ToList(); foreach (title t in oldTitles) { var savedT = titles.Search(new TitleSearch { Title = t.title1 }).FirstOrDefault(); titleMap.Add(t.id, savedT.TitleId); } //////////// /// CONTACTS /// ////// /// var oldContacts = dbContext.contacts.ToList(); foreach (contact c in oldContacts) { var savedContact = contacts.Search(c.city, c.fname, c.lname, c.organization).FirstOrDefault(); if(savedContact != null) contactMap.Add(c.id, savedContact.Id); else contactMap.Add(c.id, 2); } var oldCompsSent = dbContext.contactfinals.ToList(); List<Shipment> ships = new List<Shipment>(); foreach (var ship in oldCompsSent) { int outValue; int quant = int.TryParse(ship.number, out outValue) ? outValue : 0; string status = "Pending"; if (ship.contactfinal1.Trim().ToLower() == "shipped") status = "Sent"; int contactId = 2; int titleId = 268; if (contactMap.ContainsKey(ship.contact_id)) contactId = contactMap[ship.contact_id]; if (titleMap.ContainsKey(ship.title_id)) titleId = titleMap[ship.title_id]; Shipment shipment = new Shipment { ContactId = contactId, TitleId = titleId, Status = status, Quantity = quant, DateSent = ship.modified_on, Type = "Comp" }; ships.Add(shipment); } shipments.Insert(ships, 1); }