/// <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>())); } }