public ActionResult Create(StaffRegistrationModel staffRegistrationModel) { DB dbConn = new DB(); // String connectionString = @"server=localhost;port=3306;user id=root;database=mas_isscs;password=ThirtyFirst9731@;"; using (MySqlConnection mySqlCon = dbConn.DBConnection()) { mySqlCon.Open(); String qry = "INSERT INTO users(UserName,UserEmail,UserMobile,Password,ConfirmPassword,UserDepartment,UserType) VALUES(@UserName,@UserEmail,@UserMobile,@Password,@ConfirmPassword,@UserDepartment,@UserType)"; MySqlCommand mySqlcmd = new MySqlCommand(qry, mySqlCon); mySqlcmd.Parameters.AddWithValue("@UserName", staffRegistrationModel.UserFullName); mySqlcmd.Parameters.AddWithValue("@UserEmail", staffRegistrationModel.UserEmail); mySqlcmd.Parameters.AddWithValue("@UserMobile", staffRegistrationModel.UserMobile); mySqlcmd.Parameters.AddWithValue("@Password", staffRegistrationModel.Password); mySqlcmd.Parameters.AddWithValue("@ConfirmPassword", staffRegistrationModel.ConfirmPassword); mySqlcmd.Parameters.AddWithValue("@UserDepartment", staffRegistrationModel.UserDepartment); mySqlcmd.Parameters.AddWithValue("@UserType", staffRegistrationModel.UserType); mySqlcmd.ExecuteNonQuery(); } return(RedirectToAction("Create")); }
public ActionResult Create(StaffRegistrationModel userRegistrationModel) { DB dbConn = new DB(); // String connectionString = @"server=localhost;port=3306;user id=root;database=mas_isscs;password=ThirtyFirst9731@;"; using (MySqlConnection mySqlCon = dbConn.DBConnection()) { mySqlCon.Open(); String qry = "INSERT INTO users(UserName,UserEmail,UserMobile,Password,ConfirmPassword,UserDepartment,UserType,SecretKey,Validation,UserImage) VALUES(@UserName,@UserEmail,@UserMobile,@Password,@ConfirmPassword,@UserDepartment,@UserType,@SecretKey,@Validation,@UserImage)"; MySqlCommand mySqlcmd = new MySqlCommand(qry, mySqlCon); mySqlcmd.Parameters.AddWithValue("@UserName", userRegistrationModel.UserFullName); mySqlcmd.Parameters.AddWithValue("@UserEmail", userRegistrationModel.UserEmail); mySqlcmd.Parameters.AddWithValue("@UserMobile", userRegistrationModel.UserMobile); mySqlcmd.Parameters.AddWithValue("@Password", userRegistrationModel.Password); mySqlcmd.Parameters.AddWithValue("@ConfirmPassword", userRegistrationModel.ConfirmPassword); mySqlcmd.Parameters.AddWithValue("@UserDepartment", userRegistrationModel.UserDepartment); mySqlcmd.Parameters.AddWithValue("@UserType", userRegistrationModel.UserType); mySqlcmd.Parameters.AddWithValue("@UserImage", "NULL"); Session["forgotEmail"] = userRegistrationModel.UserEmail; Session["forgotMobile"] = Convert.ToInt32(userRegistrationModel.UserMobile); int mobileDigists = Convert.ToInt32(userRegistrationModel.UserMobile) % 10000; userRegistrationModel.SecretKey = mobileDigists + Convert.ToInt32(DateTime.Now.ToString("yymmssfff")); mySqlcmd.Parameters.AddWithValue("@SecretKey", userRegistrationModel.SecretKey); mySqlcmd.Parameters.AddWithValue("@Validation", "false"); string UserName = "******"; //acount username string Password = "******"; //account password string PhoneNo = "94" + userRegistrationModel.UserMobile.ToString(); string Message = "Hello " + userRegistrationModel.UserFullName + ". Welcome to MAS IMS.Your Security Code : " + userRegistrationModel.SecretKey.ToString(); string url = @"http://api.liyanagegroup.com/sms_api.php?sms=" + @Message + "&to=" + @PhoneNo + "&usr="******"&pw=" + @Password; WebRequest request = HttpWebRequest.Create(url); WebResponse response = request.GetResponse(); StreamReader reader = new StreamReader(response.GetResponseStream()); string urlText = reader.ReadToEnd(); //it takes the response from your url. now you can use as your need if (urlText == "OK") { Response.Write("SMS Sent..!"); } else { Response.Write("SMS Sent Fail.!"); } mySqlcmd.ExecuteNonQuery(); } return(RedirectToAction("SecureCode", "UserRegistration")); }
internal MySqlConnection DBConnection(StaffRegistrationModel staffRegistrationModel1, object staffRegistrationModel2) { throw new NotImplementedException(); }