internal static void ExecuteInsert(User user) { try { using (SqlConnection sqlConn = new SqlConnection(Registeration.GetConnectionString())) { SqlCommand sqlCmd = new SqlCommand("sp_RegisterationDetails", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; { sqlCmd.Parameters.AddWithValue("@FirstName", user.FirstName); sqlCmd.Parameters.AddWithValue("@LastName", user.LastName); sqlCmd.Parameters.AddWithValue("@Age", user.Age); sqlCmd.Parameters.AddWithValue("@SetPassword", user.SetPassword); sqlCmd.Parameters.AddWithValue("@ConfirmPassword", user.ConfirmPassword); sqlCmd.Parameters.AddWithValue("@Gender", user.Gender); sqlCmd.Parameters.AddWithValue("@Email", user.Email); sqlCmd.Parameters.AddWithValue("@LocationAddress", user.LocationAddress); sqlCmd.Parameters.AddWithValue("@City", user.City); sqlCmd.Parameters.AddWithValue("@Pincode", user.Pincode); sqlConn.Open(); sqlCmd.ExecuteNonQuery(); } } } catch (Exception exception) { Console.WriteLine("problem in opening connection" + exception.Message); } }
internal void ExecuteLogin() { using (SqlConnection sqlConn = new SqlConnection(Registeration.GetConnectionString())) { SqlCommand sqlCmd = new SqlCommand("sp_RegisterationDetails", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; } }
internal static int ExecuteLogin(string Email, string SetPassword) { using (SqlConnection sqlConn = new SqlConnection(Registeration.GetConnectionString())) { sqlConn.Open(); SqlCommand sqlCmd = new SqlCommand("sp_Login", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@Email", Email); sqlCmd.Parameters.AddWithValue("@SetPassword", SetPassword); int result = (Int32)sqlCmd.ExecuteScalar(); sqlConn.Close(); return(result); } }