// Insert Data Into Database.
public bool Insert(Members_Model c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(connString);
try
{
// Create SQL query to insert Data.
string sql = "INSERT INTO members_db(FirstName,LastName,Phone,Address,Level,Gender) VALUES(@FirstName,@LastName,@Phone,@Address,@Level,@Gender)";
SqlCommand sqlc = new SqlCommand(sql, conn);
sqlc.Parameters.AddWithValue("@FirstName", c.FirstName);
sqlc.Parameters.AddWithValue("@LastName", c.LastName);
sqlc.Parameters.AddWithValue("@Phone", c.Phone);
sqlc.Parameters.AddWithValue("@Address", c.Address);
sqlc.Parameters.AddWithValue("@Level", c.Level);
sqlc.Parameters.AddWithValue("@Gender", c.Gender);
// Connection Open.
conn.Open();
int rows = sqlc.ExecuteNonQuery();
// Success
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex) { }
finally
{
conn.Close();
}
return(isSuccess);
}
// Update Data In Database.
public bool Update(Members_Model c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(connString);
try
{
string sql = "UPDATE members_db SET FirstName=@FirstName,LastName=@LastName,Phone=@Phone,Address=@Address,Level=@Level,Gender=@Gender WHERE Id=@Id";
SqlCommand sqlc = new SqlCommand(sql, conn);
sqlc.Parameters.AddWithValue("@FirstName", c.FirstName);
sqlc.Parameters.AddWithValue("@LastName", c.LastName);
sqlc.Parameters.AddWithValue("@Phone", c.Phone);
sqlc.Parameters.AddWithValue("@Address", c.Address);
sqlc.Parameters.AddWithValue("@Level", c.Level);
sqlc.Parameters.AddWithValue("@Gender", c.Gender);
sqlc.Parameters.AddWithValue("@Id", c.ID);
// Connection Open.
conn.Open();
int rows = sqlc.ExecuteNonQuery();
// Success
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex) { }
finally
{
conn.Close();
}
return(isSuccess);
}
// Delete Data In Database.
public bool Delete(Members_Model c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(connString);
try
{
string sql = "DELETE FROM members_db WHERE Id=@Id";
SqlCommand sqlc = new SqlCommand(sql, conn);
sqlc.Parameters.AddWithValue("@Id", c.ID);
conn.Open();
int rows = sqlc.ExecuteNonQuery();
// Success
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex) { }
finally
{
conn.Close();
}
return(isSuccess);
}