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; } }