public CS_OnOffValidate GetData(int idOffer, string offerNo, string item)
{
try
{
string sql = $"SELECT * FROM CS_OnOffValidate WHERE Id_Offer = {idOffer} AND OfferNo = '{offerNo}' AND Item = '{item}'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
CS_OnOffValidate onoff = new CS_OnOffValidate();
onoff.Id = Convert.ToInt32(reader["Id"]);
onoff.Id_Offer = Convert.ToInt32(reader["Id_Offer"]);
onoff.OfferNo = reader["OfferNo"].ToString();
onoff.Item = reader["Item"].ToString();
if (reader["On_Off"].ToString() == "1")
{
onoff.On_Off = true;
}
else
{
onoff.On_Off = false;
}
conn.Close();
return(onoff);
}
else
{
conn.Close();
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Insert(CS_OnOffValidate onOff)
{
try
{
string on_off = onOff.On_Off ? "1" : "0";
string sql = @"INSERT INTO CS_OnOffValidate (Id, Id_Offer, OfferNo, Item, On_Off,
TBCreated, TBModified, TBCreatedID) VALUES (" +
$"{onOff.Id}, {onOff.Id_Offer}, '{onOff.OfferNo}', '{onOff.Item}', " +
$"'{on_off}', '{onOff.TBCreated}', '{onOff.TBModified}', {onOff.TBCreatedID}" +
")";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public List <CS_OnOffValidate> GetDataFiltered()
{
try
{
string sql = "SELECT * FROM CS_OnOffValidate WHERE On_Off = 1";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
List <CS_OnOffValidate> list = new List <CS_OnOffValidate>();
while (reader.Read())
{
CS_OnOffValidate onOff = new CS_OnOffValidate();
onOff.Id = Convert.ToInt32(reader["Id"]);
onOff.Id_Offer = Convert.ToInt32(reader["Id_Offer"]);
onOff.Item = reader["Item"].ToString();
onOff.OfferNo = reader["OfferNo"].ToString();
if (Convert.ToInt32(reader["On_Off"]) == 1)
{
onOff.On_Off = true;
}
else
{
onOff.On_Off = false;
}
list.Add(onOff);
}
reader.Close();
conn.Close();
return(list);
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
