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