public bool Delete(ClassLocationNotAvailableTimes LNoTimes)
{
bool c = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "DELETE FROM NATLocation WHERE Id = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", LNoTimes.Id);
conn.Open();
int row = cmd.ExecuteNonQuery();
if (row > 0)
{
c = true;
}
else
{
c = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(c);
}
public bool Update(ClassLocationNotAvailableTimes LNoTimes)
{
//Create a default return type and set its default value to false
bool isSuccess = false;
//Step 1 : Connect database
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//Sql command to update data in the database
string sql = "update NATLocation set SeRoom=@comboBoxLNo1, SeDay=@comboBoxLNo2, STime=@comboBoxLNo3, Etime=@comboBoxLNo4 where Id = @id";
//Creating cmd using sql & conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create Parameters to Add Data
cmd.Parameters.AddWithValue("@id", LNoTimes.Id);
cmd.Parameters.AddWithValue("@comboBoxLNo1", LNoTimes.SeRoom);
cmd.Parameters.AddWithValue("@comboBoxLNo2", LNoTimes.SeDay);
cmd.Parameters.AddWithValue("@comboBoxLNo3", LNoTimes.STime);
cmd.Parameters.AddWithValue("@comboBoxLNo4", LNoTimes.Etime);
//Connection Open
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error!!!");
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Inserting Data into Database
public bool Insert(ClassLocationNotAvailableTimes LNoTimes)
{
//Creating a default return type and setting its value to false
bool isSuccess = false;
//Step 1 : Connect database
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//Step 2: Create sql query to inert data
String sql = "Insert Into NATLocation(SeRoom, SeDay, STime, Etime) Values(@comboBoxLNo1, @comboBoxLNo2, @comboBoxLNo3, @comboBoxLNo4)";
//Creating cmd using sql & conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create Parameters to Add Data
cmd.Parameters.AddWithValue("@comboBoxLNo1", LNoTimes.SeRoom);
cmd.Parameters.AddWithValue("@comboBoxLNo2", LNoTimes.SeDay);
cmd.Parameters.AddWithValue("@comboBoxLNo3", LNoTimes.STime);
cmd.Parameters.AddWithValue("@comboBoxLNo4", LNoTimes.Etime);
//Connection Open
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs successfully then the value of rows will be greater than 0 else its value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}