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;
}
}
