public ActionResult Create([Bind(Include = "CaseID,NYPTICaseNumber,CountyCaseNumber,InitialContactDate,EmployeeID,CountyID,ContactID,ChargeID,CaseTypeID,CaseStageID," + "ThreatTypeID,ThreatBeganDate,FactsOfCase,ThreatChargeID,Plan,CaseNotes,NumAdultsMale,NumAdultsFemale,NumChildren,SpecialNeedsYN,FundsPurposeNotes,Link1,Link2,Link3")] Case @case) { if (ModelState.IsValid) { @case = AddUpdateCaseTypes(@case, false); @case = AddUpdateCaseStage(@case, false); @case = AddUpdateCharge(@case, false); @case = AddUpdateThreatType(@case, false); @case.Active = 1; @case.CreatedDate = System.DateTime.Now; db.Cases.Add(@case); db.SaveChanges(); TempData["UserMessage"] = "Your case has been created"; return(RedirectToAction("Edit", "Cases", new { id = @case.CaseID })); } ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "DisplayName", @case.ApprovalStatusID); ViewBag.CaseStageID = new MultiSelectList(db.CaseStage, "CaseStageID", "DisplayName", @case.CaseStage != null ? @case.CaseStage.Select(c => c.CaseStageID).ToList() : @case.CaseStageID); ViewBag.CaseTypeID = new MultiSelectList(db.CaseType, "CaseTypeID", "DisplayName", @case.CaseType != null ? @case.CaseType.Select(c => c.CaseTypeID).ToList() : @case.CaseTypeID); ViewBag.ChargeID = new MultiSelectList(db.Charge, "ChargeID", "DisplayName", @case.Charge != null ? @case.Charge.Select(c => c.ChargeID).ToList() : @case.ChargeID); ViewBag.CountyID = new SelectList(db.County, "CountyID", "CountyName", @case.CountyID); ViewBag.EmployeeID = new SelectList(db.Employee, "EmployeeID", "Email", @case.EmployeeID); ViewBag.ThreatChargeID = new SelectList(db.ThreatCharge, "ThreatChargeID", "DisplayName", @case.ThreatChargeID); ViewBag.ThreatTypeID = new MultiSelectList(db.ThreatType, "ThreatTypeID", "DisplayName", @case.ThreatType != null ? @case.ThreatType.Select(c => c.ThreatTypeID).ToList() : @case.ThreatTypeID); ViewBag.StatusReasonID = new SelectList(db.StatusReason, "StatusReasonID", "DisplayName", @case.StatusReasonID); return(View(@case)); }
public ActionResult Create([Bind(Include = "GrantTypeID,DisplayName")] GrantType grantType) { if (ModelState.IsValid) { db.GrantType.Add(grantType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(grantType)); }
public ActionResult Create([Bind(Include = "EmployeeID,FirstName,LastName,Email,Active")] Employee employee) { if (ModelState.IsValid) { employee.Active = 1; db.Employee.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "ContactID,FirstName,LastName,Title,CountyID,Email,PhoneNumberOffice,PhoneNumberMobile,FaxNumber,Active")] Contact contact) { if (ModelState.IsValid) { contact.Active = 1; db.Contact.Add(contact); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CountyID = new SelectList(db.County, "CountyID", "CountyName", contact.CountyID); return(View(contact)); }
public ActionResult Create([Bind(Include = "DispersalID,CaseID,DispersalRequestDate,CheckNumber,AmountRequested,DispersalApprovalStatusID,DisperalApprovalStatusReason,AmountApproved,DateSent,DateCleared,AmountReturned,DateReturned,GrantTypeID,DispersalNotes,Active")] Dispersal dispersal) { if (ModelState.IsValid) { dispersal.Active = 1; db.Dispersals.Add(dispersal); db.SaveChanges(); TempData["UserMessage"] = "Your dispersal was created"; return(RedirectToAction("Edit", "Cases", new { id = dispersal.CaseID })); } ViewBag.GrantTypeID = new SelectList(db.GrantType, "GrantTypeID", "DisplayName", dispersal.GrantTypeID); ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "DisplayName", dispersal.DispersalApprovalStatusID); return(View(dispersal)); }
public ActionResult Index(HttpPostedFileBase postedFile, int CaseID) { ViewBag.CaseID = CaseID; var attachment = new Attachment(); byte[] bytes; using (BinaryReader br = new BinaryReader(postedFile.InputStream)) { bytes = br.ReadBytes(postedFile.ContentLength); } if (ModelState.IsValid) { attachment.Name = Path.GetFileName(postedFile.FileName); attachment.ContentType = postedFile.ContentType; attachment.Data = bytes; attachment.CaseID = CaseID; attachment.UploadDate = DateTime.Now.ToShortDateString(); db.Attachments.Add(attachment); db.SaveChanges(); TempData["UserMessage"] = "Your attachment has been added"; } return(View(GetFiles(CaseID))); }
public void AddInitialValues() { var context = new WitProContext(); //add to migration //var seed = new WitProApp.Other.SeedScript(); //seed.AddInitialValues(); var counties = new List <County> { new County { CountyName = "Albany" }, new County { CountyName = "Allegany" }, new County { CountyName = "Bronx", Metro8Indicator = true }, new County { CountyName = "Broome" }, new County { CountyName = "Cattaraugus" }, new County { CountyName = "Cayuga" }, new County { CountyName = "Chautauqua" }, new County { CountyName = "Chemung" }, new County { CountyName = "Chenango" }, new County { CountyName = "Clinton" }, new County { CountyName = "Columbia" }, new County { CountyName = "Cortland" }, new County { CountyName = "Delaware" }, new County { CountyName = "Dutchess" }, new County { CountyName = "Erie" }, new County { CountyName = "Essex" }, new County { CountyName = "Franklin" }, new County { CountyName = "Fulton" }, new County { CountyName = "Genesee" }, new County { CountyName = "Greene" }, new County { CountyName = "Hamilton" }, new County { CountyName = "Herkimer" }, new County { CountyName = "Jefferson" }, new County { CountyName = "Kings", Metro8Indicator = true }, new County { CountyName = "Lewis" }, new County { CountyName = "Livingston" }, new County { CountyName = "Madison" }, new County { CountyName = "Monroe" }, new County { CountyName = "Montgomery" }, new County { CountyName = "Nassau", Metro8Indicator = true }, new County { CountyName = "New York", Metro8Indicator = true }, new County { CountyName = "Niagara" }, new County { CountyName = "Oneida" }, new County { CountyName = "Onondaga" }, new County { CountyName = "Ontario" }, new County { CountyName = "Orange" }, new County { CountyName = "Orleans" }, new County { CountyName = "Oswego" }, new County { CountyName = "Otsego" }, new County { CountyName = "Putnam" }, new County { CountyName = "Queens", Metro8Indicator = true }, new County { CountyName = "Rensselaer" }, new County { CountyName = "Richmond", Metro8Indicator = true }, new County { CountyName = "Rockland" }, new County { CountyName = "St Lawrence" }, new County { CountyName = "Saratoga" }, new County { CountyName = "Schenectady" }, new County { CountyName = "Schoharie" }, new County { CountyName = "Schuyler" }, new County { CountyName = "Seneca" }, new County { CountyName = "Steuben" }, new County { CountyName = "Suffolk", Metro8Indicator = true }, new County { CountyName = "Sullivan" }, new County { CountyName = "Tioga" }, new County { CountyName = "Tompkins" }, new County { CountyName = "Ulster" }, new County { CountyName = "Warren" }, new County { CountyName = "Washington" }, new County { CountyName = "Wayne" }, new County { CountyName = "Westchester", Metro8Indicator = true }, new County { CountyName = "Wyoming" }, new County { CountyName = "Yates" } }; counties.ForEach(c => context.County.Add(c)); context.SaveChanges(); var employees = new List <Employee> { new Employee { FirstName = "Susan", LastName = "Valle", Email = "*****@*****.**", Active = 1 }, new Employee { FirstName = "Debbie", LastName = "Peskin", Email = "*****@*****.**", Active = 1 }, new Employee { FirstName = "Bill", LastName = "Callahan", Email = "*****@*****.**", Active = 1 }, new Employee { FirstName = "Laura", LastName = "Peletier", Email = "*****@*****.**", Active = 1 }, new Employee { FirstName = "John", LastName = "O'Mara", Email = "*****@*****.**", Active = 1 } }; employees.ForEach(e => context.Employee.Add(e)); context.SaveChanges(); //contacts var contacts = new List <Contact> { new Contact { FirstName = "Amanda", LastName = "Kyle-Sprague", Title = null, CountyID = 1, Email = "*****@*****.**", PhoneNumberOffice = "518-275-4734", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Kathryn", LastName = "Merrick", Title = null, CountyID = 1, Email = "*****@*****.**", PhoneNumberOffice = "518-275-4716", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Derek", LastName = "Lynton", Title = null, CountyID = 3, Email = "", PhoneNumberOffice = "718-838-6647", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Josh", LastName = "Shapiro", Title = null, CountyID = 4, Email = "", PhoneNumberOffice = "607-778-2302", PhoneNumberMobile = "631-379-7458", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Valerie", LastName = "Rettig", Title = null, CountyID = 7, Email = "*****@*****.**", PhoneNumberOffice = "716 753-4630", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Philip", LastName = "Williams", Title = null, CountyID = 11, Email = "*****@*****.**", PhoneNumberOffice = "518-828-3414", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Sharon", LastName = "Simon", Title = null, CountyID = 15, Email = "", PhoneNumberOffice = "716-858-4625", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Paul", LastName = "Gliatta", Title = null, CountyID = 24, Email = "*****@*****.**", PhoneNumberOffice = "718 250-4844", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Jane", LastName = "Kim", Title = null, CountyID = 24, Email = "", PhoneNumberOffice = "718-250-4721", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Sam", LastName = "Soprano", Title = null, CountyID = 28, Email = "*****@*****.**", PhoneNumberOffice = "585-753=4592", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Donna", LastName = "Hansen", Title = null, CountyID = 31, Email = "", PhoneNumberOffice = "212-335-9008", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Lisa", LastName = "Barry", Title = null, CountyID = 32, Email = "", PhoneNumberOffice = "", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "John", LastName = "Granchelli", Title = null, CountyID = 32, Email = "*****@*****.**", PhoneNumberOffice = "(716) 439-7069", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Heather", LastName = "Sloma", Title = null, CountyID = 32, Email = "*****@*****.**", PhoneNumberOffice = "716-439-7094", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Todd", LastName = "Carville", Title = null, CountyID = 33, Email = "*****@*****.**", PhoneNumberOffice = "315-798-6038", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Pete", LastName = "Small", Title = null, CountyID = 34, Email = "*****@*****.**", PhoneNumberOffice = "315-435-3916 x4343", PhoneNumberMobile = "315-409-6292", FaxNumber = "", Active = 1 }, new Contact { FirstName = "John", LastName = "Heppes", Title = null, CountyID = 36, Email = "*****@*****.**", PhoneNumberOffice = "", PhoneNumberMobile = "845-291-7601", FaxNumber = "845-291-4089", Active = 1 }, new Contact { FirstName = "Mike", LastName = "Grasso", Title = null, CountyID = 36, Email = "", PhoneNumberOffice = "845-291-2585", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Mark", LastName = "Moody", Title = null, CountyID = 38, Email = "*****@*****.**", PhoneNumberOffice = "315-349-8425", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Daniel", LastName = "O'Brien", Title = null, CountyID = 41, Email = "*****@*****.**", PhoneNumberOffice = "718-286-6630", PhoneNumberMobile = "917 642-2979", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Elizabeth", LastName = "Haldeman", Title = null, CountyID = 42, Email = "", PhoneNumberOffice = "518-270-4063", PhoneNumberMobile = "518-859-5965", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Sean", LastName = "Brannigan", Title = null, CountyID = 43, Email = "*****@*****.**", PhoneNumberOffice = "718-556-7033", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Erin", LastName = "Pierone", Title = null, CountyID = 46, Email = "*****@*****.**", PhoneNumberOffice = "518-885-2263", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Mollie", LastName = "Benware", Title = null, CountyID = 46, Email = "*****@*****.**", PhoneNumberOffice = "518-885-2263", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Denise", LastName = "Haley", Title = null, CountyID = 47, Email = "", PhoneNumberOffice = "518-388-4364 x4135", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Kristen", LastName = "Plyter", Title = null, CountyID = 49, Email = "", PhoneNumberOffice = "607-535-8387", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Steve", LastName = "Vandervelden", Title = null, CountyID = 60, Email = "", PhoneNumberOffice = "914-995-3326", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Michelle", LastName = "Barber", Title = null, CountyID = 55, Email = "", PhoneNumberOffice = "607-274-5461", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Eric", LastName = "Paulding", Title = null, CountyID = 56, Email = "*****@*****.**", PhoneNumberOffice = "845-340-3981", PhoneNumberMobile = "845-784-6785", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Valerie", LastName = "Hill", Title = null, CountyID = 56, Email = "*****@*****.**", PhoneNumberOffice = "845-340-3280", PhoneNumberMobile = "", FaxNumber = "finance person", Active = 1 }, new Contact { FirstName = "Elizabeth", LastName = "Culmone-Mills", Title = null, CountyID = 56, Email = "*****@*****.**", PhoneNumberOffice = "845-340-1687", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, new Contact { FirstName = "Joey", LastName = "Drillings", Title = null, CountyID = 56, Email = "", PhoneNumberOffice = "845-334-5725", PhoneNumberMobile = "", FaxNumber = "", Active = 1 }, }; contacts.ForEach(c => context.Contact.Add(c)); context.SaveChanges(); //CaseStage var CaseStages = new List <CaseStage> { new CaseStage { DisplayName = "Pre-Arrest", Active = 1 }, new CaseStage { DisplayName = "Pre-GJ", Active = 1 }, new CaseStage { DisplayName = "GJ", Active = 1 }, new CaseStage { DisplayName = "Post-GJ", Active = 1 }, new CaseStage { DisplayName = "Pre-Trial", Active = 1 }, new CaseStage { DisplayName = "Trial", Active = 1 }, new CaseStage { DisplayName = "Post-Trial", Active = 1 } }; CaseStages.ForEach(c => context.CaseStage.Add(c)); context.SaveChanges(); //CaseType var CaseTypes = new List <CaseType> { new CaseType { DisplayName = "Homicide", Active = 1 }, new CaseType { DisplayName = "Homicide/Assault of a Law Enforcement Official", Active = 1 }, new CaseType { DisplayName = "Gang Related", Active = 1 }, new CaseType { DisplayName = "DV", Active = 1 }, new CaseType { DisplayName = "Narcotics", Active = 1 }, new CaseType { DisplayName = "Sexual Assault", Active = 1 }, new CaseType { DisplayName = "Child Abuse", Active = 1 }, new CaseType { DisplayName = "Gun", Active = 1 }, new CaseType { DisplayName = "Financial", Active = 1 }, new CaseType { DisplayName = "DWI", Active = 1 }, new CaseType { DisplayName = "Corruption/Fraud", Active = 1 }, new CaseType { DisplayName = "Assault", Active = 1 }, new CaseType { DisplayName = "Hate Crime", Active = 1 } }; CaseTypes.ForEach(c => context.CaseType.Add(c)); context.SaveChanges(); //ThreatBeganStage var ThreatBeganStages = new List <ThreatBeganStage> { new ThreatBeganStage { DisplayName = "Pre-Arrest", Active = 1 }, new ThreatBeganStage { DisplayName = "Pre-GJ", Active = 1 }, new ThreatBeganStage { DisplayName = "Indicted", Active = 1 }, new ThreatBeganStage { DisplayName = "Pre-Trial", Active = 1 }, new ThreatBeganStage { DisplayName = "Trial", Active = 1 }, new ThreatBeganStage { DisplayName = "Post-Trial", Active = 1 } }; ThreatBeganStages.ForEach(c => context.ThreatBeganStage.Add(c)); context.SaveChanges(); //ThreatCharge var ThreatCharges = new List <ThreatCharge> { new ThreatCharge { DisplayName = "Witness Intimidation - 1st degree", Active = 1 }, new ThreatCharge { DisplayName = "Witness Intimidation - 2nd degree", Active = 1 }, new ThreatCharge { DisplayName = "Witness Intimidation - 3rd degree", Active = 1 }, new ThreatCharge { DisplayName = "Witness Tampering - 1st degree ", Active = 1 }, new ThreatCharge { DisplayName = "Witness Tampering - 2nd degree", Active = 1 }, new ThreatCharge { DisplayName = "Witness Tampering - 3rd degree", Active = 1 }, new ThreatCharge { DisplayName = "Murder 1 - contract", Active = 1 }, new ThreatCharge { DisplayName = "Murder 1 - contract (attempted)", Active = 1 }, new ThreatCharge { DisplayName = "Murder 1 - witness elimination", Active = 1 }, new ThreatCharge { DisplayName = "Murder 1 - witness elimination (attempted)", Active = 1 }, new ThreatCharge { DisplayName = "Conspiracy - 1st degree", Active = 1 }, new ThreatCharge { DisplayName = "Conspiracy - 2nd degree", Active = 1 }, new ThreatCharge { DisplayName = "Conspiracy - 3rd degree", Active = 1 }, new ThreatCharge { DisplayName = "Conspiracy - 4th degree", Active = 1 }, new ThreatCharge { DisplayName = "Conspiracy - 5th degree", Active = 1 }, new ThreatCharge { DisplayName = "None", Active = 1 }, new ThreatCharge { DisplayName = "Currently Investigating", Active = 1 } }; ThreatCharges.ForEach(t => context.ThreatCharge.Add(t)); context.SaveChanges(); //ThreatType var tt = new List <ThreatType> { new ThreatType { DisplayName = "Physical Attack", Active = 1 }, new ThreatType { DisplayName = "In Person, at or near court", Active = 1 }, new ThreatType { DisplayName = "In Person, at or near home", Active = 1 }, new ThreatType { DisplayName = "On Street", Active = 1 }, new ThreatType { DisplayName = "Social Media", Active = 1 }, new ThreatType { DisplayName = "Word on the Street", Active = 1 }, new ThreatType { DisplayName = "Third Party Contacted", Active = 1 }, new ThreatType { DisplayName = "Jail Call", Active = 1 }, new ThreatType { DisplayName = "Letter", Active = 1 }, new ThreatType { DisplayName = "Phone Call", Active = 1 }, new ThreatType { DisplayName = "Text", Active = 1 }, new ThreatType { DisplayName = "Investigation Revealed", Active = 1 } }; tt.ForEach(t => context.ThreatType.Add(t)); context.SaveChanges(); //ApprovalType var ApprovalStatuses = new List <ApprovalStatus> { new ApprovalStatus { DisplayName = "Approved", Active = 1 }, new ApprovalStatus { DisplayName = "Considering", Active = 1 }, new ApprovalStatus { DisplayName = "Denied", Active = 1 } }; ApprovalStatuses.ForEach(a => context.ApprovalStatus.Add(a)); context.SaveChanges(); //Charge var Charges = new List <Charge> { new Charge { DisplayName = "Murder 1", Active = 1 }, new Charge { DisplayName = "Murder 1 (attempted)", Active = 1 }, new Charge { DisplayName = "Murder 2", Active = 1 }, new Charge { DisplayName = "Murder 2 (attempted)", Active = 1 }, new Charge { DisplayName = "Homicide (other)", Active = 1 }, new Charge { DisplayName = "Assault 1", Active = 1 }, new Charge { DisplayName = "Assault 2", Active = 1 }, new Charge { DisplayName = "Assault 3", Active = 1 }, new Charge { DisplayName = "Gang Assault B", Active = 1 }, new Charge { DisplayName = "Gang Assault C", Active = 1 }, new Charge { DisplayName = "Sexual Assault B", Active = 1 }, new Charge { DisplayName = "Sexual Assault C", Active = 1 }, new Charge { DisplayName = "Sexual Assault Other (state below)", Active = 1 }, new Charge { DisplayName = "Robbery 1", Active = 1 }, new Charge { DisplayName = "Robbery 2", Active = 1 }, new Charge { DisplayName = "Burglary 1", Active = 1 }, new Charge { DisplayName = "Burglary 2", Active = 1 }, new Charge { DisplayName = "Arson 1", Active = 1 }, new Charge { DisplayName = "Arson 2", Active = 1 }, new Charge { DisplayName = "Arson 3", Active = 1 }, new Charge { DisplayName = "Arson (other)", Active = 1 }, new Charge { DisplayName = "Criminal Possesion of a Weapon 1", Active = 1 }, new Charge { DisplayName = "Criminal Possesion of a Weapon 2", Active = 1 }, new Charge { DisplayName = "Criminal Possesion of a Weapon 3", Active = 1 }, new Charge { DisplayName = "Criminal Possesion of a Weapon Other (state below)", Active = 1 }, new Charge { DisplayName = "DWI Charge", Active = 1 }, new Charge { DisplayName = "Financial Crime", Active = 1 }, new Charge { DisplayName = "Other (state below)", Active = 1 } }; Charges.ForEach(t => context.Charge.Add(t)); context.SaveChanges(); var grants = new List <GrantType> { new GrantType { DisplayName = "C444475", Active = 1 } }; grants.ForEach(g => context.GrantType.Add(g)); context.SaveChanges(); var statusReasons = new List <StatusReason> { new StatusReason { DisplayName = "County Already Paid", Active = 1 }, new StatusReason { DisplayName = "Threats Not Verified", Active = 1 }, new StatusReason { DisplayName = "Confidential Informant", Active = 1 }, new StatusReason { DisplayName = "Other (state below)", Active = 1 } }; statusReasons.ForEach(s => context.StatusReason.Add(s)); context.SaveChanges(); }