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