// GET: AgencySites/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AgencySite agencySite = db.AgencySites.Find(id);
string UserName = @User.Identity.Name.ToString();
var U = (from P in db.AspNetUsers
where P.UserName == UserName
select P).SingleOrDefault();
ViewBag.RoleID = U.RoleBinID;
// Check if Contract exists
var concount = edb.Contracts.Where(x => x.AgencySiteID == id).Count();
ViewBag.ConCount = concount;
if (agencySite == null)
{
return(HttpNotFound());
}
return(PartialView(agencySite));
}
public ActionResult DeleteConfirmed(int id)
{
AgencySite agencySite = db.AgencySites.Find(id);
db.AgencySites.Remove(agencySite);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "AgencySiteID,AgencySiteName,Address,SecondaryAddress,CityBinID,StateBinID,ZipCodeBinID,Phone,Fax,Email,Active,DateUpdated,UpdatedBy,DateCreated,CreatedBy")] AgencySite agencySite)
{
if (ModelState.IsValid)
{
db.Entry(agencySite).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(agencySite));
}
// GET: AgencySites/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AgencySite agencySite = db.AgencySites.Find(id);
if (agencySite == null)
{
return(HttpNotFound());
}
return(View(agencySite));
}
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));
}
