private long GetTotalRowsFilter(TourSearch valFilter)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
if (valFilter.Categories == null)
{
valFilter.Categories = new string[0];
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdCity", valFilter.IdCity.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@Categories", valFilter.Categories.Length > 0 ? string.Join(",", valFilter.Categories) : null),
new SqlParameter("@MinPrice", valFilter.MinPrice),
new SqlParameter("@MaxPrice", valFilter.MaxPrice),
new SqlParameter("@MinDuration", valFilter.MinDuration),
new SqlParameter("@MaxDuration", valFilter.MaxDuration),
new SqlParameter("@MinScore", valFilter.MinScore),
new SqlParameter("@MaxScore", valFilter.MaxScore)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Tour_Filter_Total", vConnection);
vResult = DataTableToListFilterTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
public string SearchText(GeneralSearch valSearchText)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try
{
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valSearchText.IdLanguage.ToString()),
new SqlParameter("@SearchText", valSearchText.SearchText.ToString())
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_SearchText", vConnection);
List <GeneralResult> 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);
}
private long GetTotalRowsFilter(ActivitySearch valFilter)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
if (valFilter.DateStart == DateTime.MinValue)
{
valFilter.DateStart = new DateTime(1753, 1, 1);
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdTour", valFilter.IdTour.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@DateStart", valFilter.DateStart),
new SqlParameter("@MinimumPeople", valFilter.MinimumPeople),
new SqlParameter("@RowsPerPage", valFilter.RowsPerPage),
new SqlParameter("@PageNumber", valFilter.PageNumber)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity_Filter_Total", vConnection);
vResult = DataTableToListFilterTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
public string SelectByTour(ActivitySearch valFilter)
{
string vResult = string.Empty;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
if (valFilter.DateStart == DateTime.MinValue)
{
valFilter.DateStart = new DateTime(1753, 1, 1);
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdTour", valFilter.IdTour.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@DateStart", valFilter.DateStart),
new SqlParameter("@MinimumPeople", valFilter.MinimumPeople),
new SqlParameter("@RowsPerPage", valFilter.RowsPerPage),
new SqlParameter("@PageNumber", valFilter.PageNumber)
};
ActivityResponse vModel = new ActivityResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity_Filter", vConnection);
List <Activity> vData = DataTableToListFilter(vDatainTable);
vModel.Activities = vData;
vModel.TotalRows = GetTotalRowsFilter(valFilter);
if (vModel.Activities != null & vModel.Activities.Count > 0)
{
vResult = JsonConvert.SerializeObject(vModel, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = string.Empty;
}
return(vResult);
}
public string SelectByUser(PaymentUserSearch valSearch)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdUser", valSearch.IdUser.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString()),
new SqlParameter("@RowsPerPage", valSearch.RowsPerPage),
new SqlParameter("@PageNumber", valSearch.PageNumber)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment_User", vConnection);
List <Payment> vData = DataTableToListSearchUser(vDatainTable);
SetIfUserHasRankingActivity(ref vData);
long vTotalRows = GetTotalByUser(valSearch);
PaymentResponse vResponseObject = new PaymentResponse();
vResponseObject.Payments = vData;
vResponseObject.TotalRows = vTotalRows;
if (vResponseObject != null)
{
vResult = JsonConvert.SerializeObject(vResponseObject, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
public bool Update(Company valCompany)
{
bool vResult = false;
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
Company vCompanyOld = new Company();
vParameterList.Add(new SqlParameter("@Id", valCompany.Id));
DataTable vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Company", "Master");
vCompanyOld = DataTableToElement(vDatainTable);
if (vCompanyOld != null)
{
vParameterList.Add(new SqlParameter("@Name", !string.Equals(valCompany.Name, vCompanyOld.Name) ? valCompany.Name : vCompanyOld.Name));
vParameterList.Add(new SqlParameter("@TypeNumberDocument", !string.Equals(valCompany.TypeNumberDocument, vCompanyOld.TypeNumberDocument) ? valCompany.TypeNumberDocument : vCompanyOld.TypeNumberDocument));
vParameterList.Add(new SqlParameter("@NumberDocument", !string.Equals(valCompany.NumberDocument, vCompanyOld.NumberDocument) ? valCompany.NumberDocument : vCompanyOld.NumberDocument));
vParameterList.Add(new SqlParameter("@Phone", !string.Equals(valCompany.Phone, vCompanyOld.Phone) ? valCompany.Phone : vCompanyOld.Phone));
vParameterList.Add(new SqlParameter("@Movil", !string.Equals(valCompany.Movil, vCompanyOld.Movil) ? valCompany.Movil : vCompanyOld.Movil));
vParameterList.Add(new SqlParameter("@UrlPhoto", !string.Equals(valCompany.UrlPhoto, vCompanyOld.UrlPhoto) ? valCompany.UrlPhoto : vCompanyOld.UrlPhoto));
vParameterList.Add(new SqlParameter("@Address", !string.Equals(valCompany.Address, vCompanyOld.Address) ? valCompany.Address : vCompanyOld.Address));
vParameterList.Add(new SqlParameter("@IdDistrict", !Equals(valCompany.IdDistrict, vCompanyOld.IdDistrict) ? valCompany.IdDistrict : vCompanyOld.IdDistrict));
vParameterList.Add(new SqlParameter("@Email1", !string.Equals(valCompany.Email1, vCompanyOld.Email1) ? valCompany.Email1 : vCompanyOld.Email1));
vParameterList.Add(new SqlParameter("@Email2", !string.Equals(valCompany.Email2, vCompanyOld.Email2) ? valCompany.Email2 : vCompanyOld.Email2));
vParameterList.Add(new SqlParameter("@IsEnable", !Equals(valCompany.IsEnable, vCompanyOld.IsEnable) ? valCompany.IsEnable : vCompanyOld.IsEnable));
vParameterList.Add(new SqlParameter("@State", !Equals(valCompany.State, vCompanyOld.State) ? valCompany.State : vCompanyOld.State));
vParameterList.Add(new SqlParameter("@UserUpdate", valCompany.UserUpdate));
vResult = vSqlTools.ExecuteIUWithStoreProcedure(vParameterList, "sp_Update_Company", "Master");
}
} catch (Exception) {
vResult = false;
}
return(vResult);
}
public string VerifyUserPortal(string vUser, string vPassword)
{
string vResult = string.Empty;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParametersList = new List <SqlParameter>();
vParametersList.Add(new SqlParameter("@Email", vUser));
vParametersList.Add(new SqlParameter("@password", vPassword));
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParametersList, "sp_Select_UserPortal_Login", vConnection);
List <UserPortalAdmin> vData = DataTableToListSearchUserPortal(vDatainTable);
if (vData != null && vData.Count == 1)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
else
{
vResult = null;
}
} catch (Exception vEx) {
vResult = vEx.Message;
}
return(vResult);
}
public City SelectUserPortalByName(string valName)
{
City vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vListofParameters = new List <SqlParameter> {
new SqlParameter("@Email", valName)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vListofParameters, "sp_Select_City_BYName", vConnection);
vResult = DataTableToElement(vDatainTable);
} catch (Exception) {
vResult = null;
}
return(vResult);
}
public string SelectAll()
{
string vResult = string.Empty;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(null, "sp_Select_Currency_Active", vConnection);
List <Currency> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count > 0)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception) {
vResult = JsonConvert.SerializeObject(new List <Currency>());
}
return(vResult);
}
public Company SelectCompanyByPayment(Guid valId)
{
Company 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_Company_ByPayment", vConnection);
vResult = DataTableToElement(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = new Company();
}
return(vResult);
}
public UserPortalAdmin SelectUserPortalByEmail(string email)
{
UserPortalAdmin vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vListofParameters = new List <SqlParameter> {
new SqlParameter("@Email", email)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vListofParameters, "sp_Select_UserPortal_Email", vConnection);
vResult = DataTableToElementForUserPortal(vDatainTable);
} catch (Exception) {
vResult = null;
}
return(vResult);
}
public User SelectByEmail(string valEmail)
{
User vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("Email", valEmail)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_User_Email", vConnection);
vResult = DataTableToElement(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
public List <FolderViewModel> GetByUser(Guid valIdUser)
{
List <FolderViewModel> vResult = null;
try {
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
List <SqlParameter> vParameterList = new List <SqlParameter>();
vParameterList.Add(new SqlParameter("@STRIDUSER", valIdUser.ToString()));
DataTable vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Folder_User");
List <FolderViewModel> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count > 0)
{
vResult = vData;
}
} catch (Exception) {
throw;
}
return(vResult); throw new NotImplementedException();
}
public Payment SelectById(Guid valIdPayment, Guid valIdLanguage)
{
Payment vResult = new Payment();
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdPayment", valIdPayment.ToString()),
new SqlParameter("@IdLanguage", valIdLanguage.ToString())
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment", vConnection);
vResult = DataTableToElement(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
return(vResult);
}
private long GetTotalByUser(PaymentUserSearch valSearch)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdUser", valSearch.IdUser.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString()),
new SqlParameter("@RowsPerPage", valSearch.RowsPerPage),
new SqlParameter("@PageNumber", valSearch.PageNumber)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment_User_Count", vConnection);
vResult = DataTableToListSearchTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
public string Verify(string vUser, string vPassword)
{
string vResult = string.Empty;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vParameterList.Add(new SqlParameter("@UserName", vUser));
vParameterList.Add(new SqlParameter("@Password", vPassword));
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_User", vConnection);
List <User> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count == 1)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception) {
vResult = string.Empty;
}
return(vResult);
}
public UrlViewModel GetUrlToRedirect(string valSubDomainUrl)
{
UrlViewModel vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vParameterList.Add(new SqlParameter("@UrlSubDomain", valSubDomainUrl));
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Url_ByUrlSubDomain");
List <UrlViewModel> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count == 1)
{
vResult = vData.FirstOrDefault();
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
return(vResult);
}
public string SelectCityAll()
{
string vResult = string.Empty;
SQLToolsLibrary vToolsLibrary = new SQLToolsLibrary();
DataTable vDatainTable = new DataTable();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vDatainTable = vToolsLibrary.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_City_All", vConnection);
List <City> vData = DataTableToList(vDatainTable);
if (vData != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = "3";
}
return(vResult);
}
public string SelectByLanguage(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_City_Language", vConnection);
List <City> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count > 0)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception) {
vResult = JsonConvert.SerializeObject(new List <City>());
}
return(vResult);
}
public UserViewModel Verify(string vUser, string vPassword)
{
UserViewModel vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vParameterList.Add(new SqlParameter("@STRUSERNAME", vUser));
vParameterList.Add(new SqlParameter("@STRPASSWORD", vPassword));
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_User_Verify");
List <UserViewModel> vData = DataTableToList(vDatainTable);
if (vData != null && vData.Count == 1)
{
vResult = vData.FirstOrDefault();
}
} catch (Exception) {
vResult = null;
}
return(vResult);
}
private Activity GetById(Guid valIdActivity, Guid valIdLanguage, Guid valIdCurrency)
{
Activity vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valIdLanguage.ToString()),
new SqlParameter("@IdActivity", valIdActivity.ToString()),
new SqlParameter("@IdCurrency", valIdCurrency.ToString())
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Activity", vConnection);
vResult = DataTableToElement(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = new Activity();
}
return(vResult);
}
public string SelectUserPortalAll()
{
string vResult = "4";
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter>();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_User_Portal", vConnection);
List <UserPortalAdmin> vData = DataTableToListSearchUserPortal(vDatainTable);
if (vData != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = "3";
}
return(vResult);
}
public string SelectByCity(TourSearch valFilter)
{
string vResult = string.Empty;
try {
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
if (valFilter.Categories == null)
{
valFilter.Categories = new string[0];
}
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdLanguage", valFilter.IdLanguage.ToString()),
new SqlParameter("@IdCity", valFilter.IdCity.ToString()),
new SqlParameter("@IdCurrency", valFilter.IdCurrency.ToString()),
new SqlParameter("@Categories", valFilter.Categories.Length > 0 ? string.Join(",", valFilter.Categories) : null),
new SqlParameter("@MinPrice", valFilter.MinPrice),
new SqlParameter("@MaxPrice", valFilter.MaxPrice),
new SqlParameter("@MinDuration", valFilter.MinDuration),
new SqlParameter("@MaxDuration", valFilter.MaxDuration),
new SqlParameter("@MinScore", valFilter.MinScore),
new SqlParameter("@MaxScore", valFilter.MaxScore),
new SqlParameter("@RowsPerPage", valFilter.RowsPerPage),
new SqlParameter("@PageNumber", valFilter.PageNumber)
};
TourResponse vModel = new TourResponse();
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Tour_Filter", vConnection);
List <Tour> vDataTours = DataTableToListFilter(vDatainTable);
vModel.Tours = vDataTours;
vModel.TotalRows = GetTotalRowsFilter(valFilter);
if (vModel != null && vModel.Tours != null && vModel.Tours.Count > 0)
{
vResult = JsonConvert.SerializeObject(vModel, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = string.Empty;
}
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 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);
}
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);
}
