public bool Delete(HouseOption house, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_HouseOptionDeleteByHouseId");
db.AddInParameter(command, "HouseId", DbType.Guid, house.HouseId);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
return true;
}
public bool Delete(HouseOption house, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_HouseOptionDeleteByHouseId");
db.AddInParameter(command, "HouseId", DbType.Guid, house.HouseId);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
return(true);
}
public bool Select(House entity)
{
bool result = true;
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_HouseSelect");
db.AddInParameter(dbCommand, "HouseId", DbType.Guid, entity.HouseId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
if (entity == null)
{
entity = new House();
}
RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, entity);
}
if (dataReader.NextResult())
{
while (dataReader.Read())
{
HouseOption houseOption = new HouseOption();
RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, houseOption);
if (entity.HouseOptionList == null)
{
entity.HouseOptionList = new List <HouseOption>();
}
entity.HouseOptionList.Add(houseOption);
}
}
}
if (entity.HouseOptionList != null)
{
foreach (HouseOption houseOption in entity.HouseOptionList)
{
Option option = RHP.Utility.Generic.Get <Option>(houseOption.OptionId);
houseOption.Option = option;
}
}
return(result);
}
public bool Insert(HouseOption option, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_HouseOptionInsert");
db.AddInParameter(command, "HouseId", DbType.Guid, option.HouseId);
db.AddInParameter(command, "OptionId", DbType.Int32, option.OptionId);
db.AddInParameter(command, "OptionValue", DbType.String, option.OptionValue);
db.AddInParameter(command, "CreatedBy", DbType.Guid, option.CreatedBy);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
return true;
}
public bool Insert(HouseOption option, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_HouseOptionInsert");
db.AddInParameter(command, "HouseId", DbType.Guid, option.HouseId);
db.AddInParameter(command, "OptionId", DbType.Int32, option.OptionId);
db.AddInParameter(command, "OptionValue", DbType.String, option.OptionValue);
db.AddInParameter(command, "CreatedBy", DbType.Guid, option.CreatedBy);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
return(true);
}
public bool Select(House entity)
{
bool result = true;
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_HouseSelect");
db.AddInParameter(dbCommand, "HouseId", DbType.Guid, entity.HouseId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
if (entity == null)
{
entity = new House();
}
RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, entity);
}
if (dataReader.NextResult())
{
while (dataReader.Read())
{
HouseOption houseOption = new HouseOption();
RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, houseOption);
if (entity.HouseOptionList == null)
{
entity.HouseOptionList = new List<HouseOption>();
}
entity.HouseOptionList.Add(houseOption);
}
}
}
if (entity.HouseOptionList != null)
{
foreach (HouseOption houseOption in entity.HouseOptionList)
{
Option option = RHP.Utility.Generic.Get<Option>(houseOption.OptionId);
houseOption.Option = option;
}
}
return result;
}
public void AddPropertyInfo()
{
house = House.Select(HouseId);
if (house == null)
house = new House();
if (house.HouseOptionList == null)
{
house.HouseOptionList = new List<HouseOption>();
}
else
{
house.HouseOptionList.Clear();
}
// house.HouseOptionList.Clear();
foreach (ListItem item in chkOptionList.Items)
{
if (item.Selected)
{
HouseOption option = new HouseOption();
option.HouseId = house.HouseId.Value;
option.OptionId = int.Parse(item.Value);
house.HouseOptionList.Add(option);
}
}
foreach (ListItem item in chkFurnishedroomoptions.Items)
{
if (item.Selected)
{
HouseOption option = new HouseOption();
option.HouseId = house.HouseId.Value;
option.OptionId = int.Parse(item.Value);
house.HouseOptionList.Add(option);
}
}
foreach (ListItem item in chkFurnishedlivingspaceOptions.Items)
{
if (item.Selected)
{
HouseOption option = new HouseOption();
option.HouseId = house.HouseId.Value;
option.OptionId = int.Parse(item.Value);
house.HouseOptionList.Add(option);
}
}
foreach (ListItem item in chkFurnishedkitchenOptions.Items)
{
if (item.Selected)
{
HouseOption option = new HouseOption();
option.HouseId = house.HouseId.Value;
option.OptionId = int.Parse(item.Value);
house.HouseOptionList.Add(option);
}
}
if (houseOption.Save(house))
{
}
}