public BE_Json CreateParameter([FromBody] BE_Parameter bE_Parameter)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Parameter bL_Parameter = new BL_Parameter();
bL_Parameter.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Parameter.CreateParameter(bE_Parameter));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public List <BE_Parameter> GetParameter(int idParameter)
{
BE_Parameter bE_Parameter = null;
List <BE_Parameter> bE_Parameters = new List <BE_Parameter>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_idparameter", idParameter == 0 ? DBNull.Value : (object)idParameter);
var rows = _database.QuerySP("sp_getParameter", parameters);
foreach (var row in rows)
{
bE_Parameter = new BE_Parameter();
bE_Parameter.idParameter = string.IsNullOrEmpty(row["idparameter"]) ? 0 : int.Parse(row["idparameter"]);;
bE_Parameter.initials = row["initials"];
bE_Parameter.name = row["name"];
bE_Parameter.createdBy = row["createdBy"];
bE_Parameter.createdDate = string.IsNullOrEmpty(row["createdDate"]) ? DateTime.MinValue : DateTime.Parse(row["createdDate"]);
bE_Parameter.createdDateFormat = bE_Parameter.createdDate.ToShortDateString();
bE_Parameter.updatedBy = row["updatedBy"];
bE_Parameter.updatedDate = string.IsNullOrEmpty(row["updatedDate"]) ? DateTime.MinValue : DateTime.Parse(row["updatedDate"]);
bE_Parameter.updatedDateFormat = bE_Parameter.updatedDate.ToShortDateString();
bE_Parameter.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false;
bE_Parameters.Add(bE_Parameter);
}
return(bE_Parameters);
}
public BE_Parameter CreateParameter(BE_Parameter bE_Parameter)
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_initials", bE_Parameter.initials);
parameters.Add("_name", bE_Parameter.name);
parameters.Add("_createdBy", bE_Parameter.createdBy);
parameters.Add("_isEnabled", bE_Parameter.isEnabled);
var id = _database.ExecuteSPGetId("sp_createParameter", parameters);
bE_Parameter.idParameter = int.Parse(id.ToString());
return(bE_Parameter);
}
public BE_Parameter UpdateParameter(BE_Parameter bE_Parameter)
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_idparameter", bE_Parameter.idParameter);
parameters.Add("_initials", bE_Parameter.initials);
parameters.Add("_name", bE_Parameter.name);
parameters.Add("_updatedBy", bE_Parameter.updatedBy);
parameters.Add("_isEnabled", bE_Parameter.isEnabled);
var result = _database.ExecuteSP("sp_updateParameter", parameters);
if (result > 0)
{
return(bE_Parameter);
}
return(null);
}
public BE_Parameter UpdateParameter(BE_Parameter bE_Parameter)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Parameter(_database).UpdateParameter(bE_Parameter));
}
