public static bool Update(Mobile mobile)
{
string sqlConnection = MobileRespository.GetDBConnection();
using (SqlConnection myConnection = new SqlConnection(sqlConnection))
{
myConnection.Open();
string sql = "SP_UpdateData";
SqlCommand sqlCommand = new SqlCommand(sql, myConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@MobileID", mobile.MobileID);
sqlCommand.Parameters.AddWithValue("@Brand", mobile.Brand);
sqlCommand.Parameters.AddWithValue("@Model", mobile.Model);
sqlCommand.Parameters.AddWithValue("@Battery", mobile.Battery);
sqlCommand.Parameters.AddWithValue("@RAM", mobile.RAM);
sqlCommand.Parameters.AddWithValue("@ROM", mobile.ROM);
sqlCommand.Parameters.AddWithValue("@Price", mobile.Price);
int limit = sqlCommand.ExecuteNonQuery();
if (limit >= 1)
{
return(true);
}
return(false);
}
}
public DataTable GetDetails()
{
string sqlConnection = MobileRespository.GetDBConnection();
using (SqlConnection myConnection = new SqlConnection(sqlConnection))
{
myConnection.Open();
string sql = "SP_Display";
SqlCommand sqlCommand = new SqlCommand(sql, myConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
return(dataTable);
}
}
public static bool Delete(int MobileID)
{
string sqlConnection = MobileRespository.GetDBConnection();
using (SqlConnection myConnection = new SqlConnection(sqlConnection))
{
myConnection.Open();
string sql = "SP_Delete";
SqlCommand sqlCommand = new SqlCommand(sql, myConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@MobileID", MobileID);
int limit = sqlCommand.ExecuteNonQuery();
if (limit >= 1)
{
return(true);
}
return(false);
}
}
