public static OrderMenuCategory GetOne(int Id) { DBCon dBCon = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; OrderMenuCategory ObjTmp = new OrderMenuCategory(); string Query = "SELECT * FROM OrdMenuCategory where Id=" + Id.ToString() + " "; try { cmd = new SqlCommand(Query, dBCon.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { int index = 0; ObjTmp.id = SDR.GetInt32(index++); ObjTmp.CategoryId = SDR.GetInt32(index++); ObjTmp.DisplayName = SDR.GetString(index++); ObjTmp.OrderNo = SDR.GetInt32(index++); ObjTmp.OrderMenuid = SDR.GetInt32(index++); ObjTmp.Status = SDR.GetBoolean(index++); } } catch (Exception e) { e.ToString(); } finally { dBCon.Con.Close(); if (!SDR.IsClosed) { SDR.Close(); } } return(ObjTmp); }
public static List <OrderMenuCategory> GetAll(int OderMenuId = 0, int CategoryId = 0, int Id = 0) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; List <OrderMenuCategory> ListTmp = new List <OrderMenuCategory>(); string Query = "SELECT * FROM OrdMenuCategory where OrderMenuId=" + OderMenuId.ToString() + " "; if (CategoryId > 0) { Query = "SELECT * FROM OrdMenuCategory where CategoryId=" + CategoryId.ToString() + " "; } try { cmd = new SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { int index = 0; OrderMenuCategory ObjTmp = new OrderMenuCategory(); ObjTmp.id = SDR.GetInt32(index++); ObjTmp.CategoryId = SDR.GetInt32(index++); ObjTmp.DisplayName = SDR.GetString(index++); ObjTmp.OrderNo = SDR.GetInt32(index++); ObjTmp.OrderMenuid = SDR.GetInt32(index++); ObjTmp.Status = SDR.GetBoolean(index++); ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); if (!SDR.IsClosed) { SDR.Close(); } } return(ListTmp); }