/// <summary>
/// Get Team Members Details by ShopName
/// </summary>
/// <param name="shopName">name of shop</param>
/// <returns></returns>
public List <OnlineShopTestimonials> GetOnlineShopTestimonials(string shopName)
{
if (string.IsNullOrEmpty(ConnectionString))
{
ConnectionString = ConfigurationManager.ConnectionStrings["SQLDbConnection"].ToString();
}
List <OnlineShopTestimonials> onlineShopDiscount = new List <OnlineShopTestimonials>();
SqlConnection con = new SqlConnection(ConnectionString);
var cmd = new SqlCommand("dbo.[getOnlineShopHomeTestimonials]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SEARCHTEXT", SqlDbType.VarChar)).Value = shopName;//Pass the parameter for lookingAtLat
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
onlineShopDiscount = new ReflectionPopulator <OnlineShopTestimonials>().CreateList(cmd.ExecuteReader());
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(onlineShopDiscount);
}
public List <SubCatgory> GetSubCatgoryList()
{
List <SubCatgory> onlineShopSubCategory = new List <SubCatgory>();
if (string.IsNullOrEmpty(ConnectionString))
{
ConnectionString = ConfigurationManager.ConnectionStrings["SQLDbConnection"].ToString();
}
SqlConnection con = new SqlConnection(ConnectionString);
var cmd = new SqlCommand("dbo.[getSubCatgoryList]", con);
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
onlineShopSubCategory = new ReflectionPopulator <SubCatgory>().CreateList(cmd.ExecuteReader());
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(onlineShopSubCategory);
}
/// <summary>
/// Get the sub category list based on department id
/// </summary>
/// <param name="catId">department id</param>
/// <returns></returns>
public static List <SubCatgory> GetSubCatgoryList(int catId)
{
List <SubCatgory> onlineShopSubCategory = new List <SubCatgory>();
SqlConnection con = new SqlConnection(DBConnection);
var cmd = new SqlCommand("dbo.[getSubCatgoryList]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@catId", SqlDbType.Int)).Value = catId;//Pass the parameter for lookingAtLat
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
onlineShopSubCategory = new ReflectionPopulator <SubCatgory>().CreateList(cmd.ExecuteReader());
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(onlineShopSubCategory);
}
/// <summary>
/// Return the list of category
/// </summary>
/// <returns></returns>
public static List <Category> GetCatgoryList()
{
List <Category> onlineShopCategory = new List <Category>();
SqlConnection con = new SqlConnection(DBConnection);
var cmd = new SqlCommand("dbo.[getCatgoryList]", con);
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
onlineShopCategory = new ReflectionPopulator <Category>().CreateList(cmd.ExecuteReader());
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(onlineShopCategory);
}
/// <summary>
/// Tìm kiếm dữ liệu
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="KeyID"></param>
/// <returns></returns>
public static async Task <T> GetItemAsync <T>(String api, params object[] Objs)
{
try
{
Objs = Objs ?? new object[] { };
String Url = ModuleHelper.Url + $"/{(api.TrimStart('/'))}";
foreach (Object obj in Objs)
{
Url += $"/{obj}";
}
IRestClient client = new RestClient(Url);
IRestRequest request = new RestRequest();
request.Method = Method.GET;
request.AddHeader("IDAccount", clsGeneral.curAccount.KeyID.ToString());
IRestResponse response = await client.ExecuteTaskAsync(request);
T Item = response.Content.DeserializeJsonToObject <T>();
if (Item == null)
{
Item = ReflectionPopulator.CreateObject <T>();
}
return(Item);
}
catch { return(ReflectionPopulator.CreateObject <T>()); }
}
/// <summary>
/// Cập nhật dữ liệu
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="api"></param>
/// <param name="entity"></param>
/// <returns></returns>
public static Tuple <bool, T> Put <T>(String api, T entity)
{
try
{
IRestClient client = new RestClient(ModuleHelper.Url + "/" + api.TrimStart('/'));
IRestRequest request = new RestRequest();
request.Method = Method.PUT;
request.AddHeader("Accept", "application/json");
request.AddHeader("IDAccount", clsGeneral.curAccount.KeyID.ToString());
request.AddParameter("application/json", (new List <T>()
{
entity
}).SerializeListObjectToJson(), ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
bool Status = response.StatusCode == System.Net.HttpStatusCode.OK;
T Item = response.Content.DeserializeJsonToListObject <T>().FirstOrDefault();
if (Item == null)
{
Item = ReflectionPopulator.CreateObject <T>();
}
;
return(Tuple.Create(Status, Item));
}
catch { return(Tuple.Create(false, ReflectionPopulator.CreateObject <T>())); }
}
public List <DiscountDetailsModel> GetDiscountDetailsWithoutLocation(int catId, int subCatId, string searchText)
{
List <DiscountDetailsModel> discountDetails = new List <DiscountDetailsModel>();
if (string.IsNullOrEmpty(ConnectionString))
{
ConnectionString = ConfigurationManager.ConnectionStrings["SQLDbConnection"].ToString();
}
SqlConnection con = new SqlConnection(ConnectionString);
var cmd = new SqlCommand("dbo.[getDiscountCheckWithoutLocation]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DepartmentId", SqlDbType.Int)).Value = catId;//Pass the parameter for lookingAtLat }
cmd.Parameters.Add(new SqlParameter("@SubDepartmentId", SqlDbType.Int)).Value = subCatId;//Pass the parameter for lookingAtLat }
cmd.Parameters.Add(new SqlParameter("@SEARCHTEXT", SqlDbType.VarChar)).Value = string.IsNullOrEmpty(searchText) ? string.Empty : searchText;//Pass the parameter for lookingAtLat }
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
discountDetails = new ReflectionPopulator <DiscountDetailsModel>().CreateList(cmd.ExecuteReader());
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(discountDetails);
}
public static Tuple <bool, T> Login <T>(String api, string Username, string Password)
{
try
{
IRestClient client = new RestClient(ModuleHelper.Url + "/" + api.TrimStart('/'));
IRestRequest request = new RestRequest();
request.Method = Method.GET;
request.AddHeader("Accept", "application/json");
request.AddHeader("Username", Username);
request.AddHeader("Password", Password);
IRestResponse response = client.Execute(request);
bool Status = response.StatusCode == System.Net.HttpStatusCode.OK;
T Item = response.Content.DeserializeJsonToObject <T>();
if (Item == null)
{
Item = ReflectionPopulator.CreateObject <T>();
}
return(Tuple.Create(Status, Item));
}
catch { return(Tuple.Create(false, ReflectionPopulator.CreateObject <T>())); }
}
