protected override IDbDataParameter[] CreateInsertParameters(EntityBase anEntity) { ACCESSORIES theEntity = (ACCESSORIES)anEntity; List <IDbDataParameter> cmdParams = new List <IDbDataParameter>(); cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "i")); if (!string.IsNullOrEmpty(theEntity.PK_ID)) { cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID)); } if (!string.IsNullOrEmpty(theEntity.VEHICLE_TYPE_ID)) { cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_TYPE_ID", theEntity.VEHICLE_TYPE_ID)); } if (!string.IsNullOrEmpty(theEntity.ACCESSORIESS)) { cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ACCESSORIES", theEntity.ACCESSORIESS)); } cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", "")); return(cmdParams.ToArray()); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { ACCESSORIES theEntity = new ACCESSORIES(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_TYPE_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.ACCESSORIESS = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; return(theEntity); }
public static void CreateCar(string carName, double carSpeed, bool used, Color color, ACCESSORIES accessory) { CarLib car = new CarLib { CarID = NUMBEROFCAR, CarName = carName, CarSpeed = carSpeed, Used = used, Color = color }; car.Accessory.Add(accessory); cars.Add(car); NUMBEROFCAR++; }
private int populateDb() { Log.UCTechReception.Debug("populateDb()"); int idLoan = 0; // creating a loan associated with product, accessories, doc try { // using elementAt(0) because the list is empty after creating another one VisualisationPret loan = detail.ElementAt(0); LOAN newLoan = new LOAN { LOA_USER_ID_FK = UserManager.currentUser.Id, LOA_PROVIDER = radDropDownListProvider.Text, LOA_COMM_G = tBoxObservation.Text, LOA_DATE = dateTimePicker1.Value, LOA_STATE = 0 }; VpretContext.Instance.vPretContext.LOAN.InsertOnSubmit(newLoan); VpretContext.Instance.vPretContext.SubmitChanges(); idLoan = newLoan.LOA_ID; foreach (string item in loan.l_Photo) { DOCUMENT photo = new DOCUMENT { DOC_LOA_ID_FK = idLoan, DOC_NAME = item.ToString(), }; VpretContext.Instance.vPretContext.DOCUMENT.InsertOnSubmit(photo); VpretContext.Instance.vPretContext.SubmitChanges(); } foreach (VisualisationProduct product in loan.listProducts) { PRODUCT newProduct = new PRODUCT { PRO_LOA_ID_FK = idLoan, PRO_SN = product.Sn, PRO_NAME = product.Name, PRO_COM = product.Com, PRO_STATE = 0 }; VpretContext.Instance.vPretContext.PRODUCT.InsertOnSubmit(newProduct); VpretContext.Instance.vPretContext.SubmitChanges(); foreach (VisualitationAccesories accessorie in product.listAccessories) { ACCESSORIES naccessorie = new ACCESSORIES { ACC_LOA_ID_FK = idLoan, ACC_PRO_ID_FK = newProduct.PRO_ID, ACC_NAME = accessorie.Name, ACC_PN = accessorie.Pn, ACC_COM = accessorie.Com, ACC_STATE = 0 }; VpretContext.Instance.vPretContext.ACCESSORIES.InsertOnSubmit(naccessorie); VpretContext.Instance.vPretContext.SubmitChanges(); } } } catch (Exception e) { Log.UCTechReception.Error("Population failed with exception: " + e.ToString()); } finally { Log.UCTechReception.Debug("Population completed."); } return(idLoan); }