public JsonResult _UpdateAgencyF(AgencySiteViewModel agencysite) { // User Info string UserName = @User.Identity.Name.ToString(); DateTime Created = DateTime.Now; if (ModelState.IsValid) { AgencySite agsite = db.AgencySites.Single(x => x.AgencySiteID == agencysite.AgencySiteID); agsite.AgencySiteName = agencysite.AgencySiteName; agsite.Active = agencysite.Active; agsite.Address = agencysite.Address; agsite.SecondaryAddress = agencysite.SecondaryAddress; agsite.CityBinID = agencysite.CityBinID; agsite.StateBinID = agencysite.StateBinID; agsite.CountyCodeBinID = agencysite.CountyCodeBinID; agsite.ZipCode = agencysite.ZipCode; agsite.Phone = agencysite.Phone; agsite.Fax = agencysite.Fax; agsite.FEIN = agencysite.FEIN; agsite.MailAddress = agencysite.MailAddress; agsite.SecondaryMailAddress = agencysite.SecondaryMailAddress; agsite.MailCityBinID = agencysite.MailCityBinID; agsite.MailStateBinID = agencysite.MailStateBinID; agsite.MailZipCode = agencysite.MailZipCode; agsite.Website = agencysite.Website; agsite.DateUpdated = Created; agsite.UpdatedBy = UserName; db.SaveChanges(); return(Json(new { Status = "Success", Modified = agencysite.AgencySiteID }, JsonRequestBehavior.AllowGet)); } return(Json(new { Status = "Success" }, JsonRequestBehavior.AllowGet)); }
public JsonResult _CreateAgencyF(AgencySiteViewModel agencysite) { // User Info string UserName = @User.Identity.Name.ToString(); DateTime Created = DateTime.Now; if (ModelState.IsValid) { // Get Current Year DateTime dtC = DateTime.Now; // Get Current Year Name string dtCY = dtC.Year.ToString(); // Get Current Month Name string dtCM = dtC.Month.ToString(); // Get Last Year //DateTime dtP = DateTime.Now; DateTime dtP = dtC; dtP = dtP.AddYears(-1); // Get Last Year Name string dtPY = dtP.Year.ToString(); // Get Last Month Name DateTime dtPMM = dtC.AddMonths(-1); string dtPM = dtPMM.Month.ToString(); // Get Next Year DateTime dtF = dtC; dtF = dtF.AddYears(1); // Get Next Year Name string dF = dtF.Year.ToString(); // Get Next Month Name DateTime dtPNM = dtC.AddMonths(1); string dtNM = dtPNM.Month.ToString(); int? cy = 0; // Set Fiscal Year Range DateTime ytdsCHECK = new DateTime(Convert.ToInt32(dtPY), 7, 01); DateTime ytdeCHECK = new DateTime(Convert.ToInt32(dtCY), 6, 30, 23, 59, 59); DateTime ytds = new DateTime(); DateTime ytde = new DateTime(); if (dtC > ytdeCHECK) { ytds = new DateTime(Convert.ToInt32(dtCY), 7, 01); ytde = new DateTime(Convert.ToInt32(dF), 6, 30); cy = Convert.ToInt32(dF); } else { ytds = new DateTime(Convert.ToInt32(dtPY), 7, 01); ytde = new DateTime(Convert.ToInt32(dtCY), 6, 30); cy = Convert.ToInt32(dtCY); } AgencySite AS = new AgencySite { AgencySiteName = agencysite.AgencySiteName, Address = agencysite.Address, SecondaryAddress = agencysite.SecondaryAddress, CityBinID = agencysite.CityBinID, StateBinID = agencysite.StateBinID, CountyCodeBinID = agencysite.CountyCodeBinID, ZipCode = agencysite.ZipCode, Phone = agencysite.Phone, Fax = agencysite.Fax, FEIN = agencysite.FEIN, MailAddress = agencysite.MailAddress, SecondaryMailAddress = agencysite.SecondaryMailAddress, MailCityBinID = agencysite.MailCityBinID, MailStateBinID = agencysite.MailStateBinID, MailZipCode = agencysite.MailZipCode, Website = agencysite.Website, Active = true, DateCreated = Created, DateUpdated = Created, UpdatedBy = UserName, CreatedBy = UserName }; db.AgencySites.Add(AS); db.SaveChanges(); int agencysiteid = AS.AgencySiteID; Site ST = new Site { SiteName = agencysite.AgencySiteName, Address = agencysite.Address, SecondaryAddress = agencysite.SecondaryAddress, CityBinID = agencysite.CityBinID, StateBinID = agencysite.StateBinID, CountyCodeBinID = agencysite.CountyCodeBinID, ZipCode = agencysite.ZipCode, Phone = agencysite.Phone, Fax = agencysite.Fax, Website = agencysite.Website, Active = true, DateCreated = Created, DateUpdated = Created, UpdatedBy = UserName, CreatedBy = UserName }; db.Sites.Add(ST); db.SaveChanges(); int siteid = ST.SiteID; if (agencysite.ProgramName != null) { var stringToSplitS = agencysite.ProgramName; var queryS = from valS in stringToSplitS.Split(',') select Convert.ToInt32(valS); foreach (int valS in queryS) { AgencySiteProgramSites ASPS = new AgencySiteProgramSites { ProgramID = valS, SiteID = siteid, AgencySiteID = agencysiteid }; db.AgencySiteProgramSites.Add(ASPS); db.SaveChanges(); if (valS == 20) { Contract Con = new Contract { AgencySiteID = agencysiteid, FiscalYear = Convert.ToInt32(cy), TypeID = 1, DateCreated = Created, DateUpdated = Created, UpdateBy = UserName, CreatedBy = UserName }; edb.Contracts.Add(Con); edb.SaveChanges(); } } } return(Json(new { Status = "Success", Modified = agencysiteid }, JsonRequestBehavior.AllowGet)); } return(Json(new { Status = "Success" }, JsonRequestBehavior.AllowGet)); }