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