private void button4_Click(object sender, EventArgs e)
{
Model.Contract ctrtemp = new Model.Contract();
ctrtemp.inputempdetailcontract();
string connection_string = Utils.getConnectionstr();
string username = Utils.getusername();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var detaillist = from p in dc.tbl_tempcontractsdatadetails
where p.Username == username
select p;
GridViewdetail.DataSource = detaillist;
}
private void button2_Click_1(object sender, EventArgs e)
{
// inputempmastercontract
Model.Contract ctrtemp = new Model.Contract();
ctrtemp.inputempmastercontract();
string connection_string = Utils.getConnectionstr();
string username = Utils.getusername();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var masterlist = from p in dc.tbl_tempmastercontractmasscreates
where p.Username == username
select p;
gridviewmaster.DataSource = masterlist;
}
private void saveData()
{
// Vérifier si l'adresse n'existe pas
var estAddr = Model.EstateDbContext.Current.Estates.Where(e => e.Address == Address).ToList();
if (estAddr.Count != 0)
{
// Créer l'estate
var estate = new Model.Estate()
{
Type = SelectedEstateType,
Address = Address,
Zip = Zip,
City = City,
Surface = Int32.Parse(Surface),
FloorCount = Int32.Parse(FloorC),
FloorNumber = Int32.Parse(FloorN),
RoomsCount = Int32.Parse(RoomsC),
EnergyEfficiency = Int32.Parse(EnergyE),
BuildDate = BuildDate,
OwnerId = idPerson
};
// Récupérer l'id en base de données
var estId = Model.EstateDbContext.Current.Estates.Where(e => e.Address == Address).Select(e => e.Id).ToList();
int eId = 0;
if (estId.Count != 0)
{
eId = estId[0];
}
// Créer le contrat
var contract = new Model.Contract()
{
EstateId = eId,
Type = SelectedContractType,
PubDate = new DateTime(),
Description = Description,
Title = Title,
Price = Price
};
}
}
public override IModel CreateModel(SqlDataReader dr)
{
Model.Contract contract = new Model.Contract();
int indexContractId = dr.GetOrdinal("ContractId");
contract.ContractId = Convert.ToInt32(dr[indexContractId]);
int indexContractNo = dr.GetOrdinal("ContractNo");
if (dr["ContractNo"] != DBNull.Value)
{
contract.ContractNo = Convert.ToString(dr[indexContractNo]);
}
int indexOutContractNo = dr.GetOrdinal("OutContractNo");
if (dr["OutContractNo"] != DBNull.Value)
{
contract.OutContractNo = Convert.ToString(dr[indexOutContractNo]);
}
int indexContractDate = dr.GetOrdinal("ContractDate");
if (dr["ContractDate"] != DBNull.Value)
{
contract.ContractDate = Convert.ToDateTime(dr[indexContractDate]);
}
int indexContractName = dr.GetOrdinal("ContractName");
if (dr["ContractName"] != DBNull.Value)
{
contract.ContractName = Convert.ToString(dr[indexContractName]);
}
int indexTradeBorder = dr.GetOrdinal("TradeBorder");
if (dr["TradeBorder"] != DBNull.Value)
{
contract.TradeBorder = Convert.ToInt32(dr[indexTradeBorder]);
}
int indexContractLimit = dr.GetOrdinal("ContractLimit");
if (dr["ContractLimit"] != DBNull.Value)
{
contract.ContractLimit = Convert.ToInt32(dr[indexContractLimit]);
}
int indexContractSide = dr.GetOrdinal("ContractSide");
if (dr["ContractSide"] != DBNull.Value)
{
contract.ContractSide = Convert.ToInt32(dr[indexContractSide]);
}
int indexTradeDirection = dr.GetOrdinal("TradeDirection");
if (dr["TradeDirection"] != DBNull.Value)
{
contract.TradeDirection = Convert.ToInt32(dr[indexTradeDirection]);
}
int indexHaveGoodsFlow = dr.GetOrdinal("HaveGoodsFlow");
if (dr["HaveGoodsFlow"] != DBNull.Value)
{
contract.HaveGoodsFlow = Convert.ToInt32(dr[indexHaveGoodsFlow]);
}
int indexContractPeriodS = dr.GetOrdinal("ContractPeriodS");
if (dr["ContractPeriodS"] != DBNull.Value)
{
contract.ContractPeriodS = Convert.ToDateTime(dr[indexContractPeriodS]);
}
int indexContractPeriodE = dr.GetOrdinal("ContractPeriodE");
if (dr["ContractPeriodE"] != DBNull.Value)
{
contract.ContractPeriodE = Convert.ToDateTime(dr[indexContractPeriodE]);
}
int indexPremium = dr.GetOrdinal("Premium");
if (dr["Premium"] != DBNull.Value)
{
contract.Premium = Convert.ToDecimal(dr[indexPremium]);
}
int indexInitQP = dr.GetOrdinal("InitQP");
if (dr["InitQP"] != DBNull.Value)
{
contract.InitQP = Convert.ToDateTime(dr[indexInitQP]);
}
int indexAssetId = dr.GetOrdinal("AssetId");
if (dr["AssetId"] != DBNull.Value)
{
contract.AssetId = Convert.ToInt32(dr[indexAssetId]);
}
int indexSettleCurrency = dr.GetOrdinal("SettleCurrency");
if (dr["SettleCurrency"] != DBNull.Value)
{
contract.SettleCurrency = Convert.ToInt32(dr[indexSettleCurrency]);
}
int indexSignAmount = dr.GetOrdinal("SignAmount");
if (dr["SignAmount"] != DBNull.Value)
{
contract.SignAmount = Convert.ToDecimal(dr[indexSignAmount]);
}
int indexExeAmount = dr.GetOrdinal("ExeAmount");
if (dr["ExeAmount"] != DBNull.Value)
{
contract.ExeAmount = Convert.ToDecimal(dr[indexExeAmount]);
}
int indexUnitId = dr.GetOrdinal("UnitId");
if (dr["UnitId"] != DBNull.Value)
{
contract.UnitId = Convert.ToInt32(dr[indexUnitId]);
}
int indexPriceMode = dr.GetOrdinal("PriceMode");
if (dr["PriceMode"] != DBNull.Value)
{
contract.PriceMode = Convert.ToInt32(dr[indexPriceMode]);
}
int indexMemo = dr.GetOrdinal("Memo");
if (dr["Memo"] != DBNull.Value)
{
contract.Memo = Convert.ToString(dr[indexMemo]);
}
int indexDeliveryStyle = dr.GetOrdinal("DeliveryStyle");
if (dr["DeliveryStyle"] != DBNull.Value)
{
contract.DeliveryStyle = Convert.ToInt32(dr[indexDeliveryStyle]);
}
int indexDeliveryDate = dr.GetOrdinal("DeliveryDate");
if (dr["DeliveryDate"] != DBNull.Value)
{
contract.DeliveryDate = Convert.ToDateTime(dr[indexDeliveryDate]);
}
int indexCreateFrom = dr.GetOrdinal("CreateFrom");
if (dr["CreateFrom"] != DBNull.Value)
{
contract.CreateFrom = Convert.ToInt32(dr[indexCreateFrom]);
}
int indexContractStatus = dr.GetOrdinal("ContractStatus");
if (dr["ContractStatus"] != DBNull.Value)
{
contract.ContractStatus = (StatusEnum)Convert.ToInt32(dr[indexContractStatus]);
}
int indexCreatorId = dr.GetOrdinal("CreatorId");
if (dr["CreatorId"] != DBNull.Value)
{
contract.CreatorId = Convert.ToInt32(dr[indexCreatorId]);
}
int indexCreateTime = dr.GetOrdinal("CreateTime");
if (dr["CreateTime"] != DBNull.Value)
{
contract.CreateTime = Convert.ToDateTime(dr[indexCreateTime]);
}
int indexLastModifyId = dr.GetOrdinal("LastModifyId");
if (dr["LastModifyId"] != DBNull.Value)
{
contract.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]);
}
int indexLastModifyTime = dr.GetOrdinal("LastModifyTime");
if (dr["LastModifyTime"] != DBNull.Value)
{
contract.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]);
}
return contract;
}
