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);
}
