public string SelectUserPortalById(Guid Id)
{
string vResult = "4";
DataTable vDatainTable = new DataTable();
SQLToolsLibrary VSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@Id", Id != Guid.Empty?Id:throw new Exception(GlobalValues.vTextExceptionParameterNull))
};
vDatainTable = VSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_select_UserPortal_ById", vConnection);
UserPortalAdmin vData = DataTableToSelectUser(vDatainTable);
if (vData.UserName != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = "3";
}
return(vResult);
}
private int GetIfUserHAsRankingActivity(string valUserCreate, Guid valIdActivity, Guid valIdPayment)
{
int vResult = 0;
try {
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@UserCreate", valUserCreate),
new SqlParameter("@IdActivity", valIdActivity.ToString()),
new SqlParameter("@IdPayment", valIdPayment.ToString())
};
DataTable vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_If_User_Has_Ranking_Activity", vConnection);
foreach (DataRow vRow in vDatainTable.Rows)
{
vResult = Convert.ToInt32(vRow["TOTAL_RANKING"]);
}
;
} catch (Exception) {
vResult = 0;
}
return(vResult);
}
public Currency SelectById(Guid valId)
{
Currency vResult = new Currency();
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@Id", valId)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Currency_Id", vConnection);
Currency vData = DataTableToElement(vDatainTable);
if (vData != null)
{
vResult = vData;
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = new Currency();
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
public string SelectById(Guid valId)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@Id", valId)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_City", vConnection);
List <City> vData = DataTableToList(vDatainTable);
if (vData != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = "3";
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
public string SelectAllByLanguage(string valIdLanguage)
{
string vResult = string.Empty;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valIdLanguage)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_CategoryLanguage_Language", vConnection);
List <Category> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count > 0)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = JsonConvert.SerializeObject(new List <Category>(), Formatting.Indented);
}
return(vResult);
}
public bool SaveFolder(FolderViewModel valFolder)
{
bool vResult = false;
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vParameterList.Add(new SqlParameter("@STRID", valFolder.Id));
vParameterList.Add(new SqlParameter("@STRNAME", valFolder.Name));
vParameterList.Add(new SqlParameter("@STRVISUALNAME", valFolder.VisualName));
vParameterList.Add(new SqlParameter("@STRTHUMBNAIL", valFolder.Thumnail));
vParameterList.Add(new SqlParameter("@STRABSOLUTEURL", valFolder.Url));
vParameterList.Add(new SqlParameter("@STRICON", Constants.vIconFolder));
vParameterList.Add(new SqlParameter("@INTSTATE", valFolder.State));
vParameterList.Add(new SqlParameter("@STRUSERCREATE", valFolder.UserCreate));
bool vInsert = vSqlTools.ExecuteIUWithStoreProcedure(vParameterList, "sp_Insert_Folder_User");
vResult = vInsert;
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
public bool UpdateListCityLanguage(List <City> valCity)
{
bool vResult = false;
try
{
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
foreach (var vRow in valCity)
{
List <SqlParameter> vParameterListCL = new List <SqlParameter> {
new SqlParameter("@Id", vRow.IdCityLanguage),
new SqlParameter("@IdCity", vRow.Id != Guid.Empty?vRow.Id:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@IdLanguage", vRow.IdLanguage != Guid.Empty?vRow.IdLanguage:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@Slogan", !string.IsNullOrEmpty(vRow.Slogan)?vRow.Slogan:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@Description", !string.IsNullOrEmpty(vRow.Description)?vRow.Description:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@Location", !string.IsNullOrEmpty(vRow.Location)?vRow.Location:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@FarmingProduction", !string.IsNullOrEmpty(vRow.FarmingProduction)?vRow.FarmingProduction:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@DescriptionDistricts", !string.IsNullOrEmpty(vRow.DescriptionDistricts)?vRow.DescriptionDistricts:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@State", vRow.State),
new SqlParameter("@UserUpdate", !string.IsNullOrEmpty(vRow.UserUpdate)?vRow.UserUpdate:throw new Exception(GlobalValues.vTextExceptionParameterNull)),
new SqlParameter("@DateUpdate", vRow.DateUpdate != DateTime.MinValue?vRow.DateCreate:DateTime.Now),
};
bool vResponseCityLanguage = vSqlTools.ExecuteIUWithStoreProcedure(vParameterListCL, "sp_Update_Citylanguage", vConnection);
if (vResponseCityLanguage)
{
vResult = true;
}
}
}
catch (Exception vEx)
{
string vMessage = vEx.Message;
}
return(vResult);
}
public string SelectById(PaymentSearch valSearch)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdPayment", valSearch.IdPayment.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString())
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment", vConnection);
Payment vData = DataTableToElement(vDatainTable);
if (vData != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
