public static ServingSize GetOne(int ID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; ServingSize ObjTmp = new ServingSize(); try { string Query = "SELECT * FROM HG_ServingSize where ServingId=" + ID; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@ServingId", ID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.ServingId = SDR.GetInt32(0); ObjTmp.Name = SDR.GetString(1); ObjTmp.OrgId = SDR.GetInt32(2); } } catch (Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public static List <ServingSize> GetAll(int OrgId) { DBCon con = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; List <ServingSize> listOrgId = new List <ServingSize>(); try { string Quary = "Select * from HG_ServingSize where OrgId=" + OrgId; cmd = new SqlCommand(Quary, con.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ServingSize OBJINT = new ServingSize(); OBJINT.ServingId = SDR.GetInt32(0); OBJINT.Name = SDR.GetString(1); OBJINT.OrgId = SDR.GetInt32(2); listOrgId.Add(OBJINT); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); con.Con.Close(); } return(listOrgId); }