public ActionResult Create(string year)
{
var fsm = new FundingSourceModel();
var model = new FundingSourceViewModel();
model.FundingSource = fsm;
model.TipYear = year;
return View("Create", model);
}
public FundingSourceModel GetFundingSource(FundingSourceModel model)
{
SqlCommand cmd = new SqlCommand("[dbo].[GetFundingSource]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FundingTypeId", model.FundingTypeId);
cmd.Parameters.AddWithValue("@TimePeriodId", model.TimePeriodId);
var dt = this.ExecuteDataTable(cmd);
var dr = dt.Rows[0];
model.FundingTypeId = (int)dr["FundingTypeID"];
model.FundingType = dr["FundingType"].ToString();
model.Code = dr["Code"].ToString();
model.FundingGroup.Id = (int)dr["FundingGroupID"];
model.FundingGroup.Name = dr["FundingGroup"].ToString();
model.SourceOrganization.OrganizationId = (int)dr["SourceAgencyID"];
model.SourceOrganization.OrganizationName = dr["SourceAgency"].ToString();
model.RecipentOrganization.OrganizationId = (int)dr["RecipientAgencyID"];
model.RecipentOrganization.OrganizationName = dr["RecipientAgency"].ToString();
model.IsDiscretionary = dr["Discretion"].ToString().SmartParseDefault<bool>(default(bool));
model.IsConformityImpact = dr["ConformityImpact"].ToString().SmartParseDefault<bool>(default(bool));
model.IsLocal = dr["Local"].ToString().SmartParseDefault<bool>(default(bool));
model.IsState = dr["State"].ToString().SmartParseDefault<bool>(default(bool));
model.IsFederal = dr["Federal"].ToString().SmartParseDefault<bool>(default(bool));
return model;
}
public void CreateFundingSource(FundingSourceModel model)
{
SqlCommand cmd = new SqlCommand("[dbo].[CreateFundingSource]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FundingGroupId", model.FundingGroup.Id);
cmd.Parameters.AddWithValue("@SourceAgencyId", model.SourceOrganization.OrganizationId);
cmd.Parameters.AddWithValue("@RecipientAgencyId", model.RecipentOrganization.OrganizationId);
cmd.Parameters.AddWithValue("@Descretion", model.IsDiscretionary);
cmd.Parameters.AddWithValue("@ConformityImpact", model.IsConformityImpact);
cmd.Parameters.AddWithValue("@ProgramId", model.ProgramId);
cmd.Parameters.AddWithValue("@TimePeriodId", model.TimePeriodId);
cmd.Parameters.AddWithValue("@FundingType", model.FundingType);
cmd.Parameters.AddWithValue("@Code", model.Code);
cmd.Parameters.AddWithValue("@IsState", model.IsState);
cmd.Parameters.AddWithValue("@IsLocal", model.IsLocal);
cmd.Parameters.AddWithValue("@IsFederal", model.IsFederal);
this.ExecuteNonQuery(cmd);
}
/// <summary>
/// Gets the model for the TipFundingSource view
/// </summary>
/// <param name="tipYear"></param>
/// <returns></returns>
public IList<FundingSourceModel> GetTipFundingSources(string tipYear)
{
var model = new FundingSourceViewModel();
SqlCommand cmd = new SqlCommand("[TIP].[GetFundingSources]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TIPYEAR", tipYear);
var list = new List<FundingSourceModel>();
using (IDataReader rdr = this.ExecuteReader(cmd))
{
while (rdr.Read())
{
var fs= new FundingSourceModel();
fs.FundingTypeId = (int)rdr["FundingTypeId"];
fs.FundingType = rdr["FundingType"].ToString();
//fs.FundingLevel = rdr["FundingLevel"] != DBNull.Value ? rdr["FundingLevel"].ToString() : "NULL IN DB";
fs.Code= rdr["Code"].ToString();
fs.RecipentOrganization = new Organization() { OrganizationName = rdr["Recipient"].ToString() };
fs.SourceOrganization= new Organization() { OrganizationName = rdr["Source"].ToString() };
fs.TimePeriod = tipYear;
fs.Selector = "Not in DB";
fs.IsDiscretionary = (bool)rdr["Discretion"];
list.Add(fs);
}
}
return list;
}
/// <summary>
/// Get a FundingSourceModel
/// </summary>
/// <param name="tipYear"></param>
/// <param name="fundingTypeId"></param>
/// <returns></returns>
public FundingSourceModel GetFundingSourceModel(string tipYear, int fundingTypeId)
{
var model = new FundingSourceModel();
SqlCommand cmd = new SqlCommand("[TIP].[GetFundingSource]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TIPYEAR", tipYear);
cmd.Parameters.AddWithValue("@FUNDINGTYPEID", fundingTypeId);
using (IDataReader rdr = this.ExecuteReader(cmd))
{
if(rdr.Read())
{
model.FundingTypeId = (int)rdr["FundingTypeId"];
model.FundingType = rdr["FundingType"] != DBNull.Value ? rdr["FundingType"].ToString() : "NULL IN DB";
model.Code = rdr["Code"] != DBNull.Value ? rdr["Code"].ToString() : "NULL IN DB";
model.RecipentOrganization = rdr["Recipient"] != DBNull.Value ? GetOrganization((int)rdr["Recipient"]) : null;
model.SourceOrganization = rdr["Source"] != DBNull.Value ? GetOrganization((int)rdr["Source"]) : null;
model.TimePeriod = rdr["TimePeriod"] != DBNull.Value ? rdr["TimePeriod"].ToString() : "NULL IN DB";
//model.FundingLevel = rdr["FundingLevel"] != DBNull.Value ? GetFundingLevel((int)rdr["FundingLevel"]) : null;
model.IsDiscretionary = (bool)rdr["Discretion"];
model.FundingGroup = rdr["FundingGroupId"] != DBNull.Value ? GetFundingGroup((int)rdr["FundingGroupId"]) : null;
}
}
//Now load the resources
model.Resources = GetFundingResources(tipYear, fundingTypeId);
return model;
}
public JsonResult GetFundingSource(FundingSourceModel model)
{
//FundingSourceModel model = new FundingSourceModel() { FundingTypeId = guid, TimePeriodId = timePeriodId };
FundingSourceModel result;
try
{
result = _tipRepository.GetFundingSource(model);
}
catch (Exception ex)
{
return Json(new
{
message = "Funding Source not found. An error has been logged."
,
error = "true"
,
exceptionMessage = ex.Message
});
}
return Json(new
{
data = result
,
message = "Funding successfully retrieved."
,
error = "false"
});
}
public JsonResult CreateFundingSource(FundingSourceModel model)
{
model.ProgramId = (int)Enums.ApplicationState.TIP;
model.TimePeriodId = _tipRepository.GetYearId(model.TimePeriod, Enums.TimePeriodType.TimePeriod);
bool result = false;
try
{
_tipRepository.CreateFundingSource(model);
}
catch (Exception ex)
{
return Json(new
{
message = "Changes could not be stored. An error has been logged."
,
error = "true"
,
exceptionMessage = ex.Message
});
}
return Json(new
{
data = result
,
message = "Funding successfully created."
,
error = "false"
});
}