public static OfferTitle GetOneByItems(int CBID) { DBCon dBCon = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; OfferTitle Tmp = new OfferTitle(); Tmp.TotalItemPrice = 0.00; string Query = "SELECT * FROM OfferTitle where CBID=" + CBID.ToString(); try { cmd = new SqlCommand(Query, dBCon.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { int index = 0; OfferTitle ObjTmp = new OfferTitle(); ObjTmp.TitleId = SDR.GetInt32(index++); ObjTmp.CBID = SDR.GetInt32(index++); ObjTmp.Name = SDR.GetString(index++); ObjTmp.Discription = SDR.GetString(index++); ObjTmp.MaxOrdQty = SDR.GetInt32(index++); ObjTmp.FinalPrice = SDR.GetDouble(index++); ObjTmp.Tax = SDR.GetDouble(index++); ObjTmp.itemOffers = ItemOffer.GetAll("Select *, dbo.GetItemName(ItemId),dbo.GetItemPrice(ItemId) FROM ItemOffer where CashBkId=" + ObjTmp.CBID + " and IsDeleted=0"); ObjTmp.TotalItemPrice = ObjTmp.itemOffers.Sum(x => x.TotalItemPrice); Tmp = ObjTmp; } } catch (Exception e) { e.ToString(); } finally { dBCon.Close(); } return(Tmp); }
public static OfferTitle GetOne(int CBID, int Type) { DBCon dBCon = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; OfferTitle Tmp = new OfferTitle(); string Query = "SELECT * FROM OfferTitle where CBID=" + CBID.ToString() + " and Type=" + Type; try { cmd = new SqlCommand(Query, dBCon.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { int index = 0; OfferTitle ObjTmp = new OfferTitle(); ObjTmp.TitleId = SDR.GetInt32(index++); ObjTmp.CBID = SDR.GetInt32(index++); ObjTmp.Name = SDR.GetString(index++); ObjTmp.Discription = SDR.GetString(index++); ObjTmp.MaxOrdQty = SDR.GetInt32(index++); ObjTmp.FinalPrice = SDR.GetDouble(index++); ObjTmp.Tax = SDR.GetDouble(index++); ObjTmp.Type = SDR.GetInt32(index++); ObjTmp.KeepFixPrice = SDR.GetBoolean(index++); ObjTmp.OfferMenus = OfferMenu.GetAll(ObjTmp.TitleId); ObjTmp.TotalItemPrice = ObjTmp.OfferMenus.Sum(x => x.TotalItmPrice); Tmp = ObjTmp; } } catch (Exception e) { e.ToString(); } finally { dBCon.Close(); } return(Tmp); }