public string CheckAvailability(string userName) { try { using (SqlConnection sqlDBConnection = new SqlConnection(ConnectionString)) { StringBuilder sqlstmt = new StringBuilder("select EmployeeID, EmployeeName from [dbo].[EmployeeDB] where EmployeeName = @userName COLLATE Latin1_General_CS_AS "); //sqlstmt.Append(Convert.ToString(userid)); SqlCommand myCommand = new SqlCommand(sqlstmt.ToString(), sqlDBConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@userName", userName); bool foundRecord = false; sqlDBConnection.Open(); using (SqlDataReader myReader = myCommand.ExecuteReader()) { if (myReader.Read()) foundRecord = true; myReader.Close(); } sqlDBConnection.Close(); object jsonObject = new { available = (!foundRecord) }; var json = new JavaScriptSerializer().Serialize(jsonObject); return json.ToString(); } } catch (Exception ex) { return string.Format("Exception : {0}", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { Autentificador recibido = new JavaScriptSerializer().Deserialize<Autentificador>(Request.Params["datos"]); Response.Write(recibido.ToString()); Response.ContentType = "application/json"; Response.End(); }
public string CheckAvailability(string userName) { try { using (SqlConnection sqlDBConnection = new SqlConnection(ConnectionString)) { StringBuilder sqlstmt = new StringBuilder("select id,username,password,firstname,lastname,address,contactnumber,dateofbirth,emailid,securityquestion,answer,addressproof,photoidentity,status,rewardpoints from [dbo].[User] where username = @userName COLLATE Latin1_General_CS_AS "); SqlCommand myCommand = new SqlCommand(sqlstmt.ToString(), sqlDBConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@userName", userName); bool foundRecord = false; sqlDBConnection.Open(); using (SqlDataReader myReader = myCommand.ExecuteReader()) { if (myReader.Read()) foundRecord = true; myReader.Close(); } sqlDBConnection.Close(); object jsonObject = new { available = (!foundRecord)}; var json = new JavaScriptSerializer().Serialize(jsonObject); return json.ToString(); } } catch (Exception ex) { return string.Format("Exception : {0}", ex.Message); } }
public string CheckAvailability(string userName) { try { using (SqlConnection sqlDBConnection = new SqlConnection(ConnectionString)) { StringBuilder sqlstmt = new StringBuilder("SELECT COUNT(*) FROM Customer WHERE UserID=@userName"); //sqlstmt.Append(Convert.ToString(userid)); SqlCommand myCommand = new SqlCommand(sqlstmt.ToString(), sqlDBConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@userName", userName); bool foundRecord = false; sqlDBConnection.Open(); int val = (int)myCommand.ExecuteScalar(); if (val >0) foundRecord = true; sqlDBConnection.Close(); object jsonObject = new { available = (!foundRecord) }; var json = new JavaScriptSerializer().Serialize(jsonObject); return json.ToString(); } } catch (Exception ex) { return string.Format("Exception : {0}", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { // Creating Instance(object) of employee class Employee empObj = new Employee(); // Assinging values to employee object empObj.FirstName = "Kannadasan"; empObj.LastName = "Govindasamy"; empObj.Designation = "Tech Lead"; ; empObj.Department = "Development"; empObj.DOB.Date = 30; empObj.DOB.Month = 4; empObj.DOB.Year = 1988; // Serialize Employee Object var json = new JavaScriptSerializer().Serialize(empObj); Response.Write(json.ToString()); }
public string CheckAvailability(string userName) { try { string connectionString = ConfigurationManager.ConnectionStrings["databaseConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand command = new SqlCommand("select count(*) from dbo.Users where username='******';", con); SqlDataReader reader = command.ExecuteReader(); reader.Read(); bool isUserNameAvailable = (Convert.ToInt32(reader[0]) == 0 ); object jsonObject = new { available = isUserNameAvailable }; var json = new JavaScriptSerializer().Serialize(jsonObject); return json.ToString(); } catch (Exception ex) { return string.Format("Exception : {0}", ex.Message); } }
public void LogError(long order_id,string err_subject, string err_msg,oCreateOrderRequest o, string ip) { try { email em = new email(); em.SendEmail("*****@*****.**", "*****@*****.**", "", "*****@*****.**", "RedBubble endpoint", err_subject, err_msg, "smtp.yourself.com", "", "", "", false); using (var dc = new redbubbleDataContext()) { dc.sp_insert_orders_error_log(order_id, err_subject, err_msg, ip); } } catch { } try { var json = new JavaScriptSerializer().Serialize(o); using (var dc2 = new redbubbleDataContext()) { dc2.sp_update_ordrers_err_log_json(order_id, json.ToString()); } } catch { } }
private HttpResponseMessage SaveUserPreferences(UserPreference preferences, string user) { HttpClient client = new HttpClient(); client.BaseAddress = new Uri(ConfigurationManager.AppSettings["APIurl"] + "/api/UserPreference/SaveUserPreference"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var json = new JavaScriptSerializer().Serialize(preferences); string urlParameters = "?user="******"&preferences=" + json.ToString(); HttpContent content = new StringContent(""); HttpResponseMessage response = client.PostAsync(urlParameters, content).Result; return response; }
public String SerializeObject(Object obj) { var json = new JavaScriptSerializer().Serialize(obj); return json.ToString(); }
public ActionResult LogOn(LogOnModel model, string returnUrl) { if (ModelState.IsValid) { var json = new JavaScriptSerializer().Serialize(model); //if (Membership.ValidateUser(model.Email, model.Password)) if(Http.HttpPost("http://localhost:8080/Auth/Validate", json.ToString()).Equals("\"ok\"")) { return RedirectToAction("Index", "Home"); //FormsAuthentication.SetAuthCookie(model.Email, model.RememberMe); //if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") // && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) //{ // return Redirect(returnUrl); //} //else //{ // return RedirectToAction("Index", "Home"); //} } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } // If we got this far, something failed, redisplay form return View(model); }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user //MembershipCreateStatus createStatus; var json = new JavaScriptSerializer().Serialize(model); //Membership.CreateUser(model.UserName, model.Password, model.Email, null, null, true, null, out createStatus); //int createStatus = System.Convert.ToInt32(Http.HttpPost("http://localhost:8080/Auth", "{\"Email\":\"2147483647\",\"Password\":\"String content\"}")); int createStatus = System.Convert.ToInt32(Http.HttpPost("http://localhost:8080/Auth/Register", json.ToString())); if (createStatus == 0) { //FormsAuthentication.SetAuthCookie(model.UserName, false /* createPersistentCookie */); return RedirectToAction("Index", "Home"); }else if(createStatus == 7) { ModelState.AddModelError("", ErrorCodeToString(MembershipCreateStatus.DuplicateEmail)); } else { ModelState.AddModelError("", ErrorCodeToString(new MembershipCreateStatus())); } } // If we got this far, something failed, redisplay form return View(model); }