//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- Update ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Converts the object properties to SQL paramters and executes the update procedure.
/// </summary>
/// <param name="CountriesObj">Model object.</param>
/// <returns>The result of update query.</returns>
//--------------------------------------------------------------------
public bool Update(CountriesModel CountriesObj)
{
bool result = false;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("[dbo].[Countries_Update]", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//----------------------------------------------------------------------------------------------
// Set the parameters
//----------------------------------------------------------------------------------------------
myCommand.Parameters.Add("@CountryID", SqlDbType.Int, 4).Value = CountriesObj.CountryID;
myCommand.Parameters.Add("@Code", SqlDbType.NVarChar, 5).Value = CountriesObj.Code;
myCommand.Parameters.Add("@EnglishName", SqlDbType.NVarChar, 255).Value = CountriesObj.EnglishName;
myCommand.Parameters.Add("@ArabicName", SqlDbType.NVarChar, 255).Value = CountriesObj.ArabicName;
myCommand.Parameters.Add("@TIMEZONE_H", SqlDbType.Int, 4).Value = CountriesObj.TIMEZONE_H;
myCommand.Parameters.Add("@TIMEZONE_M", SqlDbType.Int, 4).Value = CountriesObj.TIMEZONE_M;
myCommand.Parameters.Add("@Reg_ID", SqlDbType.Int, 4).Value = CountriesObj.Reg_ID;
myCommand.Parameters.Add("@SimpleArName", SqlDbType.NVarChar, 255).Value = CountriesObj.SimpleArName;
myCommand.Parameters.Add("@SimpleEnName", SqlDbType.NVarChar, 255).Value = CountriesObj.SimpleEnName;
//----------------------------------------------------------------------------------------------
// Execute the command
//----------------------------------------------------------------------------------------------
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
result = true;
}
myConnection.Close();
return result;
//----------------------------------------------------------------------------------------------
}
}
public JsonResult SaveCountries(CountriesModel model)
{
var resultado = "OK";
var mensagens = new List <string>();
var idSalvo = string.Empty;
if (!ModelState.IsValid)
{
resultado = "AVISO";
mensagens = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList();
}
else
{
try
{
var id = model.Save();
if (id > 0)
{
idSalvo = id.ToString();
}
else
{
resultado = "ERRO";
}
}
catch (Exception)
{
resultado = "ERRO";
}
}
return(Json(new { Resultado = resultado, Mensagens = mensagens, IdSalvo = idSalvo }));
}
public ActionResult Update(CountriesModel CountriesObj)
{
//------------------------------------------
//Check ModelState
//------------------------------------------
if (!ModelState.IsValid)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Invalid data"));
}
//------------------------------------------
try
{
bool result = CountriesFactor.Update(CountriesObj);
if (result == true)
{
return(List(1, 25, null, null, null, null));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Saving operation faild"));
}
}
catch (Exception ex)
{ return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message)); }
}
public ActionResult EditCountry(long id)
{
ViewBag.ActiveURL = "/Admin/Countries";
CountriesModel model = objAPI.GetObjectByKey <CountriesModel>("configuration", "countriesbyid", id.ToString(), "id");
return(View(model));
}
public AdministrationPanel(User userConnected)
{
InitializeComponent();
_userConnected = userConnected;
Registry.USER_ID = userConnected.Id.ToString();
UsersModel usersModel = new UsersModel();
_users = usersModel.GetAll <User>();
CompetitionsModel competitionsModel = new CompetitionsModel();
_competitions = competitionsModel.GetAll <Competition>();
ShootersModel shootersModel = new ShootersModel();
_shooters = shootersModel.GetAll <Shooter>();
CountriesModel countriesModel = new CountriesModel();
_countries = countriesModel.GetAll <Country>();
Fullname.DataContext = _userConnected;
ImgProfilePicture.DataContext = _userConnected;
Main.Content = new Views.Index(_shooters, _competitions);
}
private async Task GotoDetailScreen()
{
CountriesModel _selectedItem = SelectedItem;
Application.Current.Properties["SelectedCountryValue"] = JsonConvert.SerializeObject(SelectedItem);
await Application.Current.SavePropertiesAsync();
await PushAsync <CountryDetailsPageModel>();
}
//------------------------------------------------------------------------------------------------------
#endregion
#region --------------GetObject--------------
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Gets the spesific record.
/// </summary>
/// <param name="ID">The model id.</param>
/// <returns>Model object.</returns>
//--------------------------------------------------------------------
public static CountriesModel GetObject(int CountryID)
{
CountriesModel CountriesObj = null;
List <CountriesModel> list = CountriesSqlDataPrvider.Instance.Get(CountryID);
if (list != null && list.Count > 0)
{
CountriesObj = list[0];
}
return(CountriesObj);
}
// GET
public IActionResult Index()
{
var model = new CountriesModel("Countries - Mustache example");
model.Codes.Add("FR");
model.Codes.Add("IT");
model.Codes.Add("US");
model.Codes.Add("CA");
model.Codes.Add("UK");
return(View(model));
}
public ActionResult EditCountry(CountriesModel model)
{
ViewBag.ActiveURL = "/Admin/Countries";
if (ModelState.IsValid)
{
string jsonStr = JsonConvert.SerializeObject(model);
TempData["ErrMsg"] = objAPI.PostRecordtoApI("configuration", "addEditCountries", jsonStr);
return(RedirectToAction("index", "Countries", new { Area = "Admin" }));
}
return(View(model));
}
public HttpResponseMessage Put(int id, CountriesModel country)
{
Country dbEntry = context.Countries.Find(id);
byte[] imageBytes = Convert.FromBase64String(country.ImagePath);
dbEntry.Description = country.Description;
dbEntry.Name = country.Name;
dbEntry.ImageData = imageBytes;
context.SaveChanges();
return(Request.CreateResponse(
HttpStatusCode.Created));
}
public HttpResponseMessage Post(CountriesModel country)
{
byte[] imageBytes = Convert.FromBase64String(country.ImagePath);
Country newCountry = new Country();
newCountry.Description = country.Description;
newCountry.Name = country.Name;
newCountry.ImageData = imageBytes;
context.Countries.Add(newCountry);
context.SaveChanges();
return(Request.CreateResponse(
HttpStatusCode.Created));
}
public ActionResult Index()
{
ViewBag.ListaTamPag = new SelectList(new int[] { _quantMaxLinhasPorPagina, 10, 15, 20 }, _quantMaxLinhasPorPagina);
ViewBag.QuantMaxLinhasPorPagina = _quantMaxLinhasPorPagina;
ViewBag.PaginaAtual = 1;
var lista = CountriesModel.RecoverList(ViewBag.PaginaAtual, _quantMaxLinhasPorPagina);
var quant = CountriesModel.RecoverQuantity();
var difQuantPaginas = (quant % ViewBag.QuantMaxLinhasPorPagina) > 0 ? 1 : 0;
ViewBag.QuantPaginas = (quant / ViewBag.QuantMaxLinhasPorPagina) + difQuantPaginas;
return(View(lista));
}
public ActionResult GetObject(int id)
{
try
{
CountriesModel CountriesObj = CountriesFactor.GetObject(id);
if (CountriesObj == null)
{
CountriesObj = new CountriesModel();
}
return(Json(CountriesObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message));
}
}
// GET: Countries
public ActionResult Index(string countryName = "", int page = 1)
{
int rowCount = 0;
var model = new CountriesModel
{
ListCountries = new Countries {
CountryName = countryName
}.GetPage(string.Empty, string.Empty, string.Empty, CmsConstants.RowAmount20, page > 0?page - 1:page, ref rowCount),
RowCount = rowCount,
Pagination = new PaginationModel
{
TotalPage = rowCount,
PageSize = CmsConstants.RowAmount20,
LinkLimit = 5,
PageIndex = page
}
};
return(View(model));
}
public HttpResponseMessage Put(Guid id, [FromBody] CountriesModel item)
{
_process.Save(item.Token, item.CountryId, item.IsActive, item.Country, item.Code, UpdatedId);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
public JsonResult RecuperarCountries(int id)
{
return(Json(CountriesModel.RecoverById(id)));
}
//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- PopulateModelFromIDataReader ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Populates model from IDataReader .
/// </summary>
/// <param name="reader"></param>
/// <returns>Model object.</returns>
//--------------------------------------------------------------------
private CountriesModel PopulateModelFromIDataReader(IDataReader reader)
{
//Create a new object
CountriesModel CountriesObj = new CountriesModel();
//Fill the object with data
//------------------------------------------------
//[CountryID]
//------------------------------------------------
if (reader["CountryID"] != DBNull.Value)
CountriesObj.CountryID = (int)reader["CountryID"];
//------------------------------------------------
//------------------------------------------------
//[Code]
//------------------------------------------------
if (reader["Code"] != DBNull.Value)
CountriesObj.Code = (string)reader["Code"];
//------------------------------------------------
//------------------------------------------------
//[EnglishName]
//------------------------------------------------
if (reader["EnglishName"] != DBNull.Value)
CountriesObj.EnglishName = (string)reader["EnglishName"];
//------------------------------------------------
//------------------------------------------------
//[ArabicName]
//------------------------------------------------
if (reader["ArabicName"] != DBNull.Value)
CountriesObj.ArabicName = (string)reader["ArabicName"];
//------------------------------------------------
//------------------------------------------------
//[TIMEZONE_H]
//------------------------------------------------
if (reader["TIMEZONE_H"] != DBNull.Value)
CountriesObj.TIMEZONE_H = (int)reader["TIMEZONE_H"];
//------------------------------------------------
//------------------------------------------------
//[TIMEZONE_M]
//------------------------------------------------
if (reader["TIMEZONE_M"] != DBNull.Value)
CountriesObj.TIMEZONE_M = (int)reader["TIMEZONE_M"];
//------------------------------------------------
//------------------------------------------------
//[Reg_ID]
//------------------------------------------------
if (reader["Reg_ID"] != DBNull.Value)
CountriesObj.Reg_ID = (int)reader["Reg_ID"];
//------------------------------------------------
//------------------------------------------------
//[SimpleArName]
//------------------------------------------------
if (reader["SimpleArName"] != DBNull.Value)
CountriesObj.SimpleArName = (string)reader["SimpleArName"];
//------------------------------------------------
//------------------------------------------------
//[SimpleEnName]
//------------------------------------------------
if (reader["SimpleEnName"] != DBNull.Value)
CountriesObj.SimpleEnName = (string)reader["SimpleEnName"];
//------------------------------------------------
//Return the populated object
return CountriesObj;
}
public JsonResult CountriesPagina(int page, int tamPag, string order)
{
var lista = CountriesModel.RecoverList(page, tamPag, order: order);
return(Json(lista));
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
CountriesModel countriesModel = new CountriesModel();
return(countriesModel.GetFlagPicture((int)value));
}
//------------------------------------------------------------------------------------------------------
#endregion
#region --------------Update--------------
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Updates model object by calling sql data provider update method.
/// </summary>
/// <param name="CountriesObj">The model object.</param>
/// <returns>The result of update operation.</returns>
//--------------------------------------------------------------------
public static bool Update(CountriesModel CountriesObj)
{
return(CountriesSqlDataPrvider.Instance.Update(CountriesObj));
}
public JsonResult ExcluirCountries(int id)
{
return(Json(CountriesModel.ExcludeId(id)));
}
