/// <summary>
/// Parse the Muni Shares from the Form Parameter collection
/// </summary>
/// <param name="formParams"></param>
/// <returns></returns>
public Dictionary<int, MunicipalityShareModel> ExtractMuniShares(NameValueCollection formParams)
{
Dictionary<int, MunicipalityShareModel> shares = new Dictionary<int, MunicipalityShareModel>();
//Get the projectId, as we need that in order to persist the share
int projectId = Convert.ToInt32(formParams["ProjectId"]);
foreach (string key in formParams)
{
if (key.StartsWith("muni_"))
{
//Parse into Dict keyed by the CountyId
int id = Convert.ToInt32(key.Split('_')[1]);
//bool isPrimary = false;
//double share = 0;
MunicipalityShareModel item = null;
if (shares.ContainsKey(id))
{
item = shares[id];
}
else
{
item = new MunicipalityShareModel();
item.MunicipalityId = id;
item.ProjectId = projectId;
shares.Add(id, item);
}
//See if we got Primary or share
if (key.EndsWith("_IsPrimary"))
{
//Html checkboxes are only included in form posts
//if they are checked. So there is no real need
//for this check and there is no notification of
//a "false" value.
if (formParams[key] == "on")
{
item.Primary = true;
}
}
if (key.EndsWith("_share"))
{
//stored as 0 to 1 range not a percent
//so we divide by 100
item.Share = Convert.ToDouble(formParams[key]) / 100;
}
}
}
return shares;
}
public JsonResult AddMuniShare(int projectId, int muniId, double share, bool isPrimary)
{
MunicipalityShareModel model = new MunicipalityShareModel();
model.ProjectId = projectId;
model.MunicipalityId = muniId;
model.Primary = isPrimary;
model.Share = share / 100;
try
{
_rtpProjectRepository.AddMunicipalityShare(model);
}
catch (Exception ex)
{
//this.Logger.LogMethodError("ProjectController", "AddCountyShare", Request.Form.ToString(), ex);
return Json(new { error = "Changes could not be stored. An error has been logged." });
}
return Json(new { message = "Municipality successfully added." });
}
/// <summary>
/// Adds a Muni Share record (ProjectMuniGeography table)
/// </summary>
/// <param name="model"></param>
public void AddMunicipalityShare(MunicipalityShareModel model)
{
//[TIP].[AddProjectMuniGeography]
using (SqlCommand command = new SqlCommand("[dbo].[AddProjectMuniGeography]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@PROJECTID", model.ProjectId);
command.Parameters.AddWithValue("@MUNIID", model.MunicipalityId);
command.Parameters.AddWithValue("@SHARE", model.Share);
command.Parameters.AddWithValue("@PRIMARY", model.Primary);
this.ExecuteNonQuery(command);
}
}
/// <summary>
/// Get the municipality shares for a project
/// </summary>
/// <param name="versionId"></param>
/// <returns></returns>
public IList<MunicipalityShareModel> GetProjectMunicipalityShares(int projectVersionId)
{
IList<MunicipalityShareModel> result = new List<MunicipalityShareModel>();
using (SqlCommand command = new SqlCommand("[dbo].[GetProjectMuniShares]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@PROJECTVERSIONID", projectVersionId);
using (IDataReader rdr = ExecuteReader(command))
{
while (rdr.Read())
{
MunicipalityShareModel model = new MunicipalityShareModel();
model.MunicipalityId = rdr["MuniGeographyId"] != DBNull.Value ? (int?)rdr["MuniGeographyId"] : null;
model.MunicipalityName = rdr["MuniName"].ToString();
model.Primary = rdr["Primary"] != DBNull.Value ? (bool?)rdr["Primary"] : null;
model.Share = rdr["Share"] != DBNull.Value ? (double?)Convert.ToDouble(rdr["Share"]) : null;
model.ProjectId = rdr["ProjectId"] != DBNull.Value ? (int?)rdr["ProjectId"] : null;
result.Add(model);
}
}
}
return result;
}
public JsonResult UpdateMuniShare(int projectId, int muniId, double share, bool isPrimary, int projectVersionId)
{
MunicipalityShareModel model = new MunicipalityShareModel();
model.ProjectId = projectId;
model.MunicipalityId = muniId;
model.Primary = isPrimary;
model.Share = share / 100;
try
{
_surveyRepository.UpdateMunicipalityShare(model);
_surveyRepository.CheckUpdateStatusId(_surveyRepository.GetProjectBasics(projectVersionId));
}
catch (Exception ex)
{
//this.Logger.LogMethodError("ProjectController", "AddCountyShare", Request.Form.ToString(), ex);
return Json(new { error = "Changes could not be stored. An error has been logged." });
}
return Json(new { message = "Municipality successfully updated." });
}