public bool CreateFunding(FundingDetail fund)
{
try
{
_db.FundingDetails.InsertOnSubmit(fund);
_db.SubmitChanges();
return true;
}
catch
{
return false;
}
}
partial void DeleteFundingDetail(FundingDetail instance);
partial void UpdateFundingDetail(FundingDetail instance);
partial void InsertFundingDetail(FundingDetail instance);
private void detach_FundingDetails(FundingDetail entity)
{
this.SendPropertyChanging();
entity.Contact = null;
}
public ActionResult Amend(int id, int? LeadContactID, int? StagedPayment, int? ProgrammeID, int? ExtendYear,
int? ExtendMonth, int? LimitedYear, int? LimitedMonth, FormCollection collection)
{
CultureInfo enUS = new CultureInfo("en-US");
var ser = _db.GetService(id);
ser.SerName = collection["ServiceName"];
ser.SerIsActive = 1;
ser.SerShortDescription = collection["ShortDescription"];
ser.SerFullDescription = collection["FullDescription"];
ser.SerSubType = collection["SubType"];
ser.SerDeptCode = collection["DeptCode"];
ser.LeadContactID = LeadContactID;
ser.SerType = collection["SerType"];
ser.ClientDescription = collection["ClientDescription"];
ser.SerDescriptionDelivery = collection["DescriptionDelivery"];
ser.SerAttendance = collection["Attendance"];
ser.SerContractCode = collection["ContractCode"];
ser.SerStartExpected = _db.ConvertDate(collection["StartExpected"], "dd/MM/yyyy");
ser.SerContractValue = collection["ContractValue"];
ser.SerStartDate = _db.ConvertDate(collection["StartDate"], "dd/MM/yyyy");
ser.SerEndDate = _db.ConvertDate(collection["EndDate"], "dd/MM/yyyy");
ser.SerReferralProcess = collection["ReferralProcess"];
ser.SerStagedPayment = StagedPayment;
ser.SerExtendable = (collection["Extendable"] == "1" ? 1 : 0);
ser.SerTimeLimited = (collection["TimeLimited"] == "1" ? 1 : 0);
ser.SerExtendYear = ser.SerExtendable == 1 ? ExtendYear : 0;
ser.SerExtendMonth = ser.SerExtendable == 1 ? ExtendMonth : 0;
ser.SerTimeLimitedYear = ser.SerTimeLimited == 1 ? LimitedYear : 0;
ser.SerTimeLimitedMonth = ser.SerTimeLimited == 1 ? LimitedMonth : 0;
ser.ProgrammeID = ProgrammeID;
ser.OtherService = "," + collection["OtherService[]"] + ",";
ser.SerDetail3RefList = "," + collection["SerDetail3RefList[]"] + ",";
ser.SerDetail2RefList = ","+collection["ServiceDetail2[]"]+",";
if (ser.SerSubType == "Contract")
{
ser.SerContractRefList = "," + collection["ServiceContract[]"]+",";
}
if (ser.SerSubType == "Funded")
{
var fund = _db.GetFunding(id);
var isNewFunding = false;
if (fund == null)
{
fund = new FundingDetail();
isNewFunding = true;
}
fund.FundingSource = collection["fundingsource"];
fund.FundingNeeds = collection["fundingneeds"];
fund.FundingContractDetail = Convert.ToInt32(collection["FundingContactID"]);
fund.FundingContinuationNeeded = collection["fundingcontinuation"] == "1" ? 1 : 0;
if (fund.FundingContinuationNeeded == 1)
{
fund.FundingContinuationAmount = Convert.ToDecimal(collection["continuationamount"]);
fund.FundingContinuationDetail = collection["continuationdetail"];
}
fund.FundingAmount = Convert.ToDecimal(collection["fundingamount"]);
fund.FundingStart = _db.ConvertDate(collection["fundingstart"], "dd/MM/yyyy");
fund.FundingEnd = _db.ConvertDate(collection["fundingend"], "dd/MM/yyyy");
fund.FundraisingForText = collection["fundraisingtext"];
fund.FundraisingNeeds = collection["fundraisingneeds"];
fund.FundraisingRequiredBy = _db.ConvertDate(collection["fundingrequiredby"], "dd/MM/yyyy");
fund.FundraisingWhy = collection["fundingfundraisingwhy"];
fund.FundraisingComplete = collection["fundingcomplete"] == "1" ? 1 : 0;
fund.FundraisingCompletedDate = fund.FundraisingComplete == 1 ? _db.ConvertDate(collection["fundingcompletedate"], "dd/MM/yyyy") : null;
fund.FundraisingDonorAnonymous = collection["donoranonymous"] == "1" ? 1 : 0;
fund.FundraisingDonationDate = _db.ConvertDate(collection["donationdate"], "dd/MM/yyyy");
fund.FundraisingDonorAmount = collection["donoramount"]==""? new decimal?():Convert.ToDecimal(collection["donoramount"]);
fund.FundraisingDonationIncremental = collection["fundingincremental"]=="1"? 1:0;
fund.SerID = ser.SerID;
if (isNewFunding == true)
_db.CreateFunding(fund);
}
_db.Update();
//ViewBag.testCheckList = collection["ServiceContract[]"];
//ViewBag.testCheck = collection["fundingcomplete"];
//ViewBag.testDate = collection["StartExpected"];
//ViewBag.testMoney = collection["fundingamount"];
//ViewBag.RefFrom = "ServiceDetail2";
//ViewBag.RefChecked = ",44,45,47";
//ViewBag.RefFrom = "ServiceContract";
//ViewBag.RefChecked = ",31,32,40";
//RedirectToAction("Add","Service");
ViewBag.Alert = "true";
ViewBag.Message = "Action success!";
ViewBag.URL = "/Service/List";
return View("../Shared/Redirect");
//return RedirectToAction("List");
}