public ActionResult Modify([Bind(Prefix = "")] Models.Funder_Org model) { var db = new CodeFirst.CodeFirst(); if (ModelState.IsValid) { var myFunderOrg = db.Funder_Org.Where(v => v.FunderOrgID == model.FunderOrgID).SingleOrDefault(); if (myFunderOrg != null) { myFunderOrg.FunderOrgID = model.FunderOrgID; myFunderOrg.OrgName = model.OrgName; myFunderOrg.ContactNumber = model.ContactNumber; myFunderOrg.EmailAddress = model.EmailAddress; myFunderOrg.Bank = model.Bank; myFunderOrg.AccountNumber = model.AccountNumber; myFunderOrg.BranchCode = model.BranchCode; myFunderOrg.StreetAddress = model.StreetAddress; myFunderOrg.City = model.City; myFunderOrg.AreaCode = model.AreaCode; myFunderOrg.Thanked = model.Thanked; myFunderOrg.TypeID = model.TypeID; myFunderOrg.ProjectID = model.ProjectID; db.SaveChanges(); } TempData["js"] = "myUpdateSuccess()"; return(RedirectToAction("Index", "FunderOrg")); } return(View("Index", model)); }
// GET: ModifyFunderOrg public ActionResult Index(string funderOrgID) { CodeFirst.CodeFirst db = new CodeFirst.CodeFirst(); if (funderOrgID != null) { Models.Funder_Org myModel = new Models.Funder_Org(); var intFundOrgID = Int32.Parse(funderOrgID); var myFunderOrg = db.Funder_Org.Where(i => i.FunderOrgID == intFundOrgID).FirstOrDefault(); myModel.FunderOrgID = myFunderOrg.FunderOrgID; myModel.OrgName = myFunderOrg.OrgName; myModel.ContactNumber = myFunderOrg.ContactNumber; myModel.EmailAddress = myFunderOrg.EmailAddress; myModel.Bank = myFunderOrg.Bank; myModel.AccountNumber = myFunderOrg.AccountNumber; myModel.BranchCode = myFunderOrg.BranchCode; myModel.StreetAddress = myFunderOrg.StreetAddress; myModel.City = myFunderOrg.City; myModel.AreaCode = myFunderOrg.AreaCode; myModel.Thanked = myFunderOrg.Thanked; myModel.TypeID = myFunderOrg.TypeID; myModel.ProjectID = myFunderOrg.ProjectID; myModel.FunderTypes = db.Funder_Type.ToList(); myModel.Project = db.Projects.ToList(); return(View(myModel)); } Models.Funder_Org model = new Models.Funder_Org(); return(View(model)); }
// GET: FunderOrgTYLetter public ActionResult Index() { var db = new CodeFirst.CodeFirst(); var FunderOrg = new Models.Funder_Org(); FunderOrg.FunderOrgs = db.Funder_Org.ToList(); return(View(FunderOrg)); }
public ActionResult Create([Bind(Prefix = "")] Models.Funder_Org model) { var db = new CodeFirst.CodeFirst(); if (ModelState.IsValid) { if (db.Funder_Org.Count() > 0) { var item = db.Funder_Org.OrderByDescending(a => a.FunderOrgID).FirstOrDefault(); db.Funder_Org.Add(new CodeFirst.Funder_Org { FunderOrgID = item.FunderOrgID + 1, OrgName = model.OrgName, ContactNumber = model.ContactNumber, EmailAddress = model.EmailAddress, Bank = model.Bank, AccountNumber = model.AccountNumber, BranchCode = model.BranchCode, StreetAddress = model.StreetAddress, City = model.City, AreaCode = model.AreaCode, Thanked = false, TypeID = model.TypeID, ProjectID = model.ProjectID, }); } else { db.Funder_Org.Add(new CodeFirst.Funder_Org { FunderOrgID = 1, OrgName = model.OrgName, ContactNumber = model.ContactNumber, EmailAddress = model.EmailAddress, Bank = model.Bank, AccountNumber = model.AccountNumber, BranchCode = model.BranchCode, StreetAddress = model.StreetAddress, City = model.City, AreaCode = model.AreaCode, Thanked = false, TypeID = model.TypeID, ProjectID = model.ProjectID, }); } db.SaveChanges(); model.JavaScriptToRun = "mySuccess()"; TempData["model"] = model; return(RedirectToAction("Index", "FunderOrg")); } model.FunderTypes = db.Funder_Type.ToList(); model.Project = db.Projects.ToList(); return(View("Index", model)); }
// GET: FunderOrg public ActionResult Index() { Models.Funder_Org myModel = new Models.Funder_Org(); if (TempData["model"] != null) { myModel = (Models.Funder_Org)TempData["model"]; TempData.Remove("model"); } return(View(myModel)); }
public ActionResult FunderOrgTYLetter([Bind(Prefix = "")] Models.Funder_Org model) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/FunderThankYouLetter.rpt"))); rd.SetParameterValue("@OrgID", model.FunderOrgID); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/doc", "FunderThankYouLetterTemplate.doc")); } catch { throw; } }