// GET: FunderPersonDetails
public ActionResult Index(string funderPersonID)
{
Models.Funder_Person myModel = new Models.Funder_Person();
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
if (funderPersonID != null)
{
var intFunderPersonID = Int32.Parse(funderPersonID);
var myFunderPerson = db.Funder_Person.Where(i => i.FunderPersonID == intFunderPersonID).FirstOrDefault();
var mytypeID = db.Funder_Type.Where(i => i.TypeID == myFunderPerson.TypeID).FirstOrDefault();
var myProjectID = db.Projects.Where(i => i.ProjectID == myFunderPerson.ProjectID).FirstOrDefault();
myModel.FunderPersonID = myFunderPerson.FunderPersonID;
myModel.FirstName = myFunderPerson.FirstName;
myModel.MiddleName = myFunderPerson.MiddleName;
myModel.LastName = myFunderPerson.LastName;
myModel.Initials = myFunderPerson.Initials;
myModel.CellNum = myFunderPerson.CellNum;
myModel.PersonalEmail = myFunderPerson.PersonalEmail;
myModel.Bank = myFunderPerson.Bank;
myModel.AccountNumber = myFunderPerson.AccountNumber;
myModel.BranchCode = myFunderPerson.BranchCode;
myModel.StreetAddress = myFunderPerson.StreetAddress;
myModel.City = myFunderPerson.City;
myModel.AreaCode = myFunderPerson.AreaCode;
myModel.Thanked = myFunderPerson.Thanked;
myModel.ProjectName = myProjectID != null ? myProjectID.ProjectName : "None";
myModel.Name = mytypeID.Name;
}
return(View(myModel));
}
// GET: FunderPersonTYLetter
public ActionResult Index()
{
var db = new CodeFirst.CodeFirst();
var FunderPerson = new Models.Funder_Person();
FunderPerson.FunderPersons = db.Funder_Person.ToList();
return(View(FunderPerson));
}
// GET: FunderPerson
public ActionResult Index()
{
Models.Funder_Person myModel = new Models.Funder_Person();
if (TempData["model"] != null)
{
myModel = (Models.Funder_Person)TempData["model"];
TempData.Remove("model");
}
return(View(myModel));
}
public ActionResult FunderPersonTYLetter([Bind(Prefix = "")] Models.Funder_Person model)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Report/FunderPersonThankYouLetter.rpt")));
rd.SetParameterValue("@PersonID", model.FunderPersonID);
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;
}
}
public ActionResult Modify([Bind(Prefix = "")] Models.Funder_Person model)
{
var db = new CodeFirst.CodeFirst();
if (ModelState.IsValid)
{
var myFunderPerson = db.Funder_Person.Where(v => v.FunderPersonID == model.FunderPersonID).SingleOrDefault();
if (myFunderPerson != null)
{
myFunderPerson.FunderPersonID = model.FunderPersonID;
myFunderPerson.FirstName = model.FirstName;
myFunderPerson.MiddleName = model.MiddleName;
myFunderPerson.LastName = model.LastName;
myFunderPerson.PersonalEmail = model.PersonalEmail;
myFunderPerson.CellNum = model.CellNum;
myFunderPerson.Bank = model.Bank;
myFunderPerson.AccountNumber = model.AccountNumber;
myFunderPerson.BranchCode = model.BranchCode;
myFunderPerson.StreetAddress = model.StreetAddress;
myFunderPerson.City = model.City;
myFunderPerson.AreaCode = model.AreaCode;
myFunderPerson.Thanked = model.Thanked;
myFunderPerson.TypeID = model.TypeID;
myFunderPerson.ProjectID = model.ProjectID;
db.SaveChanges();
}
TempData["js"] = "myUpdateSuccess()";
return(RedirectToAction("Index", "FunderPerson"));
}
model.FunderTypes = db.Funder_Type.ToList();
model.Project = db.Projects.ToList();
return(View("Index", model));
}
public ActionResult Create([Bind(Prefix = "")] Models.Funder_Person model)
{
var db = new CodeFirst.CodeFirst();
if (ModelState.IsValid)
{
if (db.Funder_Person.Count() > 0)
{
var item = db.Funder_Person.OrderByDescending(a => a.FunderPersonID).FirstOrDefault();
db.Funder_Person.Add(new CodeFirst.Funder_Person
{
FunderPersonID = item.FunderPersonID + 1,
FirstName = model.FirstName,
MiddleName = model.MiddleName,
LastName = model.LastName,
Initials = model.Initials,
CellNum = model.CellNum,
PersonalEmail = model.PersonalEmail,
Bank = model.Bank,
AccountNumber = model.AccountNumber,
BranchCode = model.BranchCode,
StreetAddress = model.StreetAddress,
City = model.City,
AreaCode = model.AreaCode,
Thanked = false,
ProjectID = model.ProjectID,
TypeID = model.TypeID,
});
}
else
{
db.Funder_Person.Add(new CodeFirst.Funder_Person
{
FunderPersonID = 1,
FirstName = model.FirstName,
MiddleName = model.MiddleName,
LastName = model.LastName,
Initials = model.Initials,
CellNum = model.CellNum,
PersonalEmail = model.PersonalEmail,
Bank = model.Bank,
AccountNumber = model.AccountNumber,
BranchCode = model.BranchCode,
StreetAddress = model.StreetAddress,
City = model.City,
AreaCode = model.AreaCode,
Thanked = false,
ProjectID = model.ProjectID,
TypeID = model.TypeID,
});
}
db.SaveChanges();
model.JavaScriptToRun = "mySuccess()";
TempData["model"] = model;
return(RedirectToAction("Index", "FunderPerson"));
}
model.FunderTypes = db.Funder_Type.ToList();
model.Project = db.Projects.ToList();
return(View("Index", model));
}
