private String GetType(String ColumnName, GridViewRow row) { String Result = ""; clsSearch obj = new clsSearch(); // i have set up the table name static as now we require to make search working for macintosh project only. // as per rakesh sir directed. Int32 Type = obj.GetNumberForDataTypeofColumn("tblProperty", ColumnName); switch (Type) { case 1: DateTime dtvalue = (DateTime)DataBinder.Eval(row.DataItem, ColumnName); Result = dtvalue.ToString(); break; case 2: String svalue = (String)DataBinder.Eval(row.DataItem, ColumnName); Result = svalue; break; case 3: break; case 4: Int32 ivalue = (Int32)DataBinder.Eval(row.DataItem, ColumnName); Result = ivalue.ToString(); break; case 5: Guid gvalue = (Guid)DataBinder.Eval(row.DataItem, ColumnName); Result = gvalue.ToString(); break; } return Result; }
private void init_value() { string[] SetYear_ = SetYear.Split('|'); try { Session["step"] = 0; clsSearch clsC = new clsSearch(); clsC.init_value(Request.Params["year"], Request.Params["make"], Request.Params["model"], Request.Params["other"], Request.Params["class"], Request.Params["searchtext"]); year = (Session["year"] != null ? Session["year"].ToString() : ""); make = (Session["make"] != null ? Session["make"].ToString() : ""); model = (Session["model"] != null ? Session["model"].ToString() : ""); } catch { } //lVaribleDefault.Text = "alert('" + SetYear_ .Length.ToString()+ "')"; string obtion = "<option value='All'>All</option>"; for (int i = 0; i < SetYear_.Length; i++) { obtion += string.Format("<option value='{0}'>{0}</option>", SetYear_[i]); } DefaultYear.Text = obtion; }
public clsSearch DeserializeSearch(string pstringData) { clsSearch Search = new clsSearch(); dynamic data = JObject.Parse(pstringData); Search = JsonConvert.DeserializeObject <clsSearch>(Convert.ToString(data)); return(Search); }
public string searchBands(string pstringRequest, int pintOffset, int pintLimit) { clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest); clsSearch search = DeserializeJson.DeserializeSearch(request.Data); clsResponse response = new clsResponse(); clsBandsBlock BandsBlock = new clsBandsBlock(); BandsBlock = FacadeDA.getBandsSearch(BandsBlock, ref response, ref search, pintOffset, pintLimit); response.Data = serializer.Serialize(BandsBlock); return(serializer.Serialize(response)); }
public static async Task <string> Search(clsSearch SearchParams) { Serializer serializer = new Serializer(); string RequestBody = serializer.Serialize(SearchParams); clsRequest RequestObject = new clsRequest("-1", -1, RequestBody); HttpResponseMessage request = await clsHttpClient.getClient().PostAsJsonAsync("users/search", RequestObject); if (request.IsSuccessStatusCode) { string response = request.Content.ReadAsStringAsync().Result; return(await Task.FromResult(response)); } else //if ((int) response.StatusCode == 500) { return(await Task.FromResult("Unexpected error ocurred")); } }
public async Task <ActionResult> Search(string name, string country, string genre) { string response = await clsFanRequests.GetFanBands(Int32.Parse(Session["Id"].ToString())); clsSearch searchParams = new clsSearch(); searchParams.Name = name; searchParams.Genre = genre; searchParams.Country = country; string response2 = await clsUserRequests.Search(searchParams); //Hubo error if (!ErrorParser.parse(response).Equals("")) { ViewBag.Message = "F**k my life2..."; } FanProfileViewModel profile = DataParser.parseFanBands(response); profile.SearchResults = DataParser.parseBands(response2); System.Diagnostics.Debug.WriteLine("search " + profile.SearchResults.Count); try { profile.Id = Int32.Parse(Session["Id"].ToString()); profile.Username = Session["Username"].ToString(); profile.Name = Session["Name"].ToString(); } catch (NullReferenceException) { //Not logged in ViewBag.Message = "Please log in first"; return(View("~/Views/Login/Index.cshtml")); } //return View(profile); //TempData["profile"] = profile; //return RedirectToAction("Search", "Fans", new { area = "Fans", userId = Session["id"] }); return(View(profile)); }
public static void Main() { clsFanRead a = new clsFanRead(); Serializer b = new Serializer(); clsBandsBlock h = new clsBandsBlock(); clsResponse d = new clsResponse(); //c.FanCod = 98; //c.Chunks = 10; //c.Offset = 10; clsSearch k = new clsSearch(); k.Name = ""; List <Int32> l = new List <int>(); l.Add(0); k.Genre = "Pop"; k.Country = ""; Console.WriteLine(b.Serialize(a.getBandsSearch(h, ref d, ref k, 0, 5))); Console.WriteLine(d.Message); Console.ReadKey(); }
private void init_value() { string[] SetYear_ = SetYear.Split('|'); try { Session["step"] = 0; clsSearch clsC = new clsSearch(); clsC.init_value(Request.Params["year"], Request.Params["make"], Request.Params["model"], Request.Params["other"], Request.Params["class"], Request.Params["searchtext"]); year = (Session["year"] != null ? Session["year"].ToString() : ""); make = (Session["make"] != null ? Session["make"].ToString() : ""); model = (Session["model"] != null ? Session["model"].ToString() : ""); } catch { } //lVaribleDefault.Text = "alert('" + SetYear_ .Length.ToString()+ "')"; string obtion = "<option value='All'>All</option>"; for (int i = 0; i < SetYear_.Length; i++) { obtion+=string.Format("<option value='{0}'>{0}</option>", SetYear_[i]); } DefaultYear.Text = obtion; }
public clsBandsBlock getBandsSearch(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, ref clsSearch pclsSearch, int pintOffset, int pintLimit) { return(FanRead.getBandsSearch(pclsBandsBlock, ref pclsResponse, ref pclsSearch, pintOffset, pintLimit)); }
public clsBandsBlock getBandsSearch(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, ref clsSearch pclsSearch, int pintOffset, int pintLimit) { try { SqlCommand cmd = new SqlCommand("myFan.SP_GetBandFilteredByName", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@intOffset", System.Data.SqlDbType.Int).Value = pintOffset; cmd.Parameters.Add("@intRows", System.Data.SqlDbType.Int).Value = pintLimit; cmd.Parameters.Add("@strPais", System.Data.SqlDbType.VarChar).Value = pclsSearch.Country; cmd.Parameters.Add("@strGeneros", System.Data.SqlDbType.VarChar).Value = pclsSearch.Genre; cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsSearch.Name; conn.Open(); SqlDataReader result = cmd.ExecuteReader(); List <String> values = new List <String>(); List <String> cods = new List <String>(); List <clsSimpleInfo> bands = new List <clsSimpleInfo>(); while (result.Read()) { clsSimpleInfo tmp = new clsSimpleInfo(); tmp.Name = result["NombreBanda"].ToString(); tmp.Id = Convert.ToInt32(result["UserCode"].ToString()); DateTime dat = Convert.ToDateTime(result["FechaCreacion"].ToString()); tmp.DateCreation = dat.ToString("yyyy"); bands.Add(tmp); } pclsBandsBlock.Bands = bands; pclsResponse.Code = 0; pclsResponse.Message = "Done"; pclsResponse.Success = true; } catch (SqlException ex) { pclsResponse.Code = 1; pclsResponse.Success = false; pclsResponse.Message = ex.Message; } catch (Exception ex) { pclsResponse.Code = 2; pclsResponse.Success = false; pclsResponse.Message = "Unexpected error."; } finally { conn.Close(); } return(pclsBandsBlock); }