private List <PlaceBo> FillLst(DataTable pdtDataTable)
{
List <PlaceBo> lstItems = new List <PlaceBo>();
try
{
PlaceBo placeBo = null;
foreach (DataRow dr in pdtDataTable.Rows)
{
placeBo = new PlaceBo
{
IdPlace = ABLib.Databases.GetInt32(dr, "IdPlace"),
IdResearchRoommate = ABLib.Databases.GetInt32(dr, "IdResearchRoommate"),
IdCreationProject = ABLib.Databases.GetInt32(dr, "IdCreationProject"),
City = ABLib.Databases.GetString(dr, "City"),
PostalCode = ABLib.Databases.GetString(dr, "PostalCode"),
Department = ABLib.Databases.GetString(dr, "Department"),
DepartmentNumber = ABLib.Databases.GetString(dr, "DepartmentNumber"),
Region = ABLib.Databases.GetString(dr, "Region"),
Country = ABLib.Databases.GetString(dr, "County"),
ScopeResearch = ABLib.Databases.GetByte(dr, "ScopeResearch")
};
lstItems.Add(placeBo);
}
}
catch (Exception)
{
throw;
}
return(lstItems);
}
public PlaceBo GetObjectFromPlaceJson(string jsonDataPlace, int ScopeResearch)
{
JObject place = JsonConvert.DeserializeObject <JObject>(jsonDataPlace);
PlaceBo placeBo = new PlaceBo(true);
if (ScopeResearch == (int)ScoopResearch.Commune)
{
placeBo.City = (string)place["label"];
placeBo.PostalCode = (string)place["postcode"];
string[] context = place["context"].ToString().Split(',');
if (context != null)
{
placeBo.DepartmentNumber = (context.Length >= 1) ? context[0] : "";
placeBo.Department = (context.Length >= 2) ? context[1] : "";
placeBo.Region = (context.Length >= 3) ? context[2] : "";
}
}
else if (ScopeResearch == (int)ScoopResearch.Departement)
{
placeBo.Department = (string)place["nom"];
placeBo.DepartmentNumber = (string)place["code"];
}
else if (ScopeResearch == (int)ScoopResearch.Region)
{
placeBo.Region = (string)place["nom"];
}
return(placeBo);
}
public bool Upd(PlaceBo placeBo, int idResearchRoommate, int idCreationProject)
{
if (this.PlaceSql == null)
{
return(false);
}
else
{
return(this.PlaceSql.Upd(placeBo, idResearchRoommate, idCreationProject));
}
}
public int Add(PlaceBo placeBo, int idResearchRoommate, int idCreationProject)
{
if (this.PlaceSql == null)
{
return(0);
}
else
{
return(this.PlaceSql.Add(placeBo, idResearchRoommate, idCreationProject));
}
}
public PeopleSearchingViewModel(bool init)
{
if (init == true)
{
PlaceBo = new PlaceBo(true);
ResearchRoommateBo = new ResearchRoommateBo(true);
LstPeopleSearchingVM = new List <PeopleSearchingViewModel>();
LstPlaceBo = new List <PlaceBo>();
IdPeopleSearching = new int();
}
}
public bool Upd(PlaceBo placeBo, int idResearchRoommate, int idCreationProject)
{
ABLib.DAL.Sql.SqlParametersCollection oSqlParameters = new ABLib.DAL.Sql.SqlParametersCollection();
oSqlParameters.Add("IdResearchRoommate", (idResearchRoommate == 0) ? null : idResearchRoommate.ToString(), SqlDbType.NVarChar);
oSqlParameters.Add("IdCreationProject", (idCreationProject == 0) ? null : idCreationProject.ToString(), SqlDbType.NVarChar);
oSqlParameters.Add("City", placeBo.City, SqlDbType.NVarChar);
oSqlParameters.Add("PostalCode", placeBo.PostalCode, SqlDbType.NVarChar);
oSqlParameters.Add("Department", placeBo.Department, SqlDbType.NVarChar);
oSqlParameters.Add("DepartmentNumber", placeBo.DepartmentNumber, SqlDbType.NVarChar);
oSqlParameters.Add("Region", placeBo.Region, SqlDbType.NVarChar);
oSqlParameters.Add("Country", placeBo.Country, SqlDbType.NVarChar);
oSqlParameters.Add("ScopeResearch", placeBo.ScopeResearch, SqlDbType.TinyInt);
return(this.SqlDbStoredProcedureDAL.ExecWithTryCatch("Place_Upd", oSqlParameters));
}
public PlaceBo GetFullPlaceName(PlaceBo placeBo)
{
if (placeBo.ScopeResearch == (int)ScoopResearch.Commune)
{
placeBo.FullPlaceName = placeBo.City + ", " + placeBo.DepartmentNumber + " - " + placeBo.Department + ", " + placeBo.Region + ", " + placeBo.Country;
}
else if (placeBo.ScopeResearch == (int)ScoopResearch.Departement)
{
placeBo.FullPlaceName = placeBo.DepartmentNumber + " - " + placeBo.Department + ", " + placeBo.Country;
}
else if (placeBo.ScopeResearch == (int)ScoopResearch.Region)
{
placeBo.FullPlaceName = placeBo.Region + ", " + placeBo.Country;
}
return(placeBo);
}
public ActionResult DisplayInputSearchPlace(string jsonDataPlace, string scopeResearch)
{
jsonDataPlace = HttpUtility.UrlDecode(jsonDataPlace, System.Text.Encoding.Default);
_InputSearchPlace inputSearchPlace = new _InputSearchPlace();
PlaceBo placeBo = inputSearchPlace.GetObjectFromPlaceJson(jsonDataPlace, Convert.ToInt32(scopeResearch));
placeBo = inputSearchPlace.GetFullPlaceName(placeBo);
AllViewModel allViewModel = new AllViewModel();
allViewModel.PeopleSearchingVM = new PeopleSearchingViewModel(true);
allViewModel.PeopleSearchingVM.LstPlaceBo.Add(placeBo);
return(View("~/Views/PeopleSearching/AddUpd_ModalPeopleSearch.cshtml", allViewModel));
}
