// GET: Account
public ActionResult Registration(string email, string Password)
{
string ErrorMsg = "";
//Check email Validation
bool valid = EmailValidation.IsEmail(email);
if (valid == false)
{
ErrorMsg = "Invalid Email Address";
return(new JsonResult
{
Data = ErrorMsg,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ErrorMsg = "Success";
db = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
string sql = " INSERT INTO tblUsers(UserName,Password) " +
" VALUES (@email,@Password)";
try
{
db.Execute(sql, new
{
email,
Password
});
}
catch (Exception e)
{
if (e.Message.IndexOf("Email-Already-Exist") > 0)
{
ErrorMsg = "Email Address Already Exist....";
}
else
{
ErrorMsg = e.Message;
}
db.Close();
}
return(new JsonResult
{
Data = ErrorMsg,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}