protected void grdItems_IDB(object sender, DataGridItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Product p = (Product)e.Item.DataItem; Label lblTitle = (Label)e.Item.FindControl("lblTitle"); Label lblQty = (Label)e.Item.FindControl("lblQty"); Label lblDetails = (Label)e.Item.FindControl("lblDetails"); lblTitle.Text = p.LongTitle; lblQty.Text = p.NumQtyOrdered.ToString(); lblDetails.Text = "TODO:"; if (p.ProductId.ToLower().EndsWith("c")) { KVPair Nerdo = new KVPair(); //***EAc @%$#*@# UI is giving me problems...hardcoding class for now lblTitle.Text = "<span class=textLoud>Cover Only: </span>" + p.LongTitle; Nerdo.Key = p.LongTitle; Nerdo.Val = PubEnt.DAL2.DAL.GetNerdoURLByChild(p.ProductId); Nerdos.Add(Nerdo); } } }
public static KVPairCollection GetAllShippingMethods() { Database db = DatabaseFactory.CreateDatabase(); DbCommand cw = db.GetStoredProcCommand("sp_NCIPL_GetAllShippingMethods"); using (System.Data.IDataReader dr = db.ExecuteReader(cw)) { KVPairCollection coll = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair((string)dr.GetString(0), (string)dr.GetString(1)); coll.Add(k); } return(coll); } }
//********************************************************************* // // Generate Collection Methods // // The following methods are used to generate collections of objects //[] //********************************************************************* public static KVPairCollection GetKVPair(string s) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cw = db.GetStoredProcCommand(s); using (System.Data.IDataReader dr = db.ExecuteReader(cw)) { KVPairCollection coll = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair(dr.GetInt32(0).ToString(), (string)dr.GetString(1)); coll.Add(k); } return(coll); } }
public static KVPairCollection GetOrderMedia(string role) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cw = db.GetStoredProcCommand("sp_NCIPLCC_getOrderMedia"); db.AddInParameter(cw, "role", DbType.String, role); using (System.Data.IDataReader dr = db.ExecuteReader(cw)) { KVPairCollection coll = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair(dr.GetInt32(0).ToString(), (string)dr.GetString(1)); coll.Add(k); } return(coll); } }
//END HITT 8329 ############################################# //BEGIN CR - 23 -- Canned Search public static KVPairCollection GetCannedSearchIdText(string procname, string param) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cw = db.GetStoredProcCommand(procname); db.AddInParameter(cw, "recordid", DbType.String, param); using (System.Data.IDataReader dr = db.ExecuteReader(cw)) { KVPairCollection coll = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair( dr.GetInt32(0).ToString(), (dr[1] == DBNull.Value) ? "" : dr[1].ToString() ); coll.Add(k); } return(coll); } }
//Get Key, Value, Selected information for the lists public static KVPairCollection GetKVPair(string procname, int mode, int cannid) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cw = db.GetStoredProcCommand(procname); db.AddInParameter(cw, "mode", DbType.Int32, mode); db.AddInParameter(cw, "cannid", DbType.Int32, cannid); using (System.Data.IDataReader dr = db.ExecuteReader(cw)) { KVPairCollection coll = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair( dr.GetInt32(0).ToString(), (dr[1] == DBNull.Value) ? "" : dr[1].ToString(), dr.GetInt32(2).ToString() ); coll.Add(k); } return(coll); } }
public static KVPairCollection GetCities(int z) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("sp_NCIPL_GetCities"); db.AddInParameter(dbCommand, "zip", DbType.String, z.ToString().PadLeft(5, '0'));//***EAC HOTFIX for hitt8245...better to change here than in the calling procedures. using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Processing code KVPairCollection c = new KVPairCollection(); while (dr.Read()) { KVPair k = new KVPair( dr["cityname"].ToString(), dr["state"].ToString() ); c.Add(k); } return(c); } }