public PrintForm(EDeals deals)
{
InitializeComponent();
_SellerName = deals.SellerName;
_SellerSO = deals.SellerSO;
_SellerRO = deals.SellerRO;
_PurchaserName = deals.PurchaserName;
_PurchaserSO = deals.PurchaserSO;
_PurchaserRO = deals.PurchaserRO;
_PlotHouseNo = deals.PlotHouseNo;
_Phase = deals.Phase;
_StreetNo = deals.StreetNo;
_RegistrationNo = deals.RegistrationNo;
_Catagory = deals.Catagory;
_Size = deals.Size;
_TotalAmount = deals.TotalAmount;
_Biana = deals.Biana;
_BalanceAmount = deals.BalanceAmount;
_OnOrBefore = deals.OnOrBefore;
_SellerCnic = deals.SellerCnic;
_PurchaserCnic = deals.PurchaserCnic;
_WitnessOneName = deals.WitnessOneName;
_WitnessOneCnic = deals.WitnessOneCnic;
_WitnessTwoName = deals.WitnessTwoName;
_WitnessTwoCnic = deals.WitnessTwoCnic;
}
public void Insert(EDeals edeals)
{
string query = "INSERT INTO [Table](Date,SellerName,SellerSO,SellerRO,PurchaserName,PurchaserSO,PurchaserRO,PlotHouseNo,Phase,StreetNo,RegistrationNo,Catagory,Size,TotalAmount,Biana,BalanceAmount,OnOrBefore,SellerCnic,PurchaserCnic,WitnessOneName,WitnessOneCnic,WitnessTwoName,WitnessTwoCnic)VALUES (@Date,@SellerName,@SellerSO,@SellerRO,@PurchaserName,@PurchaserSO,@PurchaserRO,@PlotHouseNo,@Phase,@StreetNo,@RegistrationNo,@Catagory,@Size,@TotalAmount,@Biana,@BalanceAmount,@OnOrBefore,@SellerCnic,@PurchaserCnic,@WitnessOneName,@WitnessOneCnic,@WitnessTwoName,@WitnessTwoCnic)";
Hashtable paramters = new Hashtable();
paramters.Add("@Date", edeals.Date);
paramters.Add("@SellerName", edeals.SellerName);
paramters.Add("@SellerSO", edeals.SellerSO);
paramters.Add("@SellerRO", edeals.SellerRO);
paramters.Add("@PurchaserName", edeals.PurchaserName);
paramters.Add("@PurchaserSO", edeals.PurchaserSO);
paramters.Add("@PurchaserRO", edeals.PurchaserRO);
paramters.Add("@PlotHouseNo", edeals.PlotHouseNo);
paramters.Add("@Phase", edeals.Phase);
paramters.Add("@StreetNo", edeals.StreetNo);
paramters.Add("@RegistrationNo", edeals.RegistrationNo);
paramters.Add("@Catagory", edeals.Catagory);
paramters.Add("@Size", edeals.Size);
paramters.Add("@TotalAmount", edeals.TotalAmount);
paramters.Add("@Biana", edeals.Biana);
paramters.Add("@BalanceAmount", edeals.BalanceAmount);
paramters.Add("@OnOrBefore", edeals.OnOrBefore);
paramters.Add("@SellerCnic", edeals.SellerCnic);
paramters.Add("@PurchaserCnic", edeals.PurchaserCnic);
paramters.Add("@WitnessOneName", edeals.WitnessOneName);
paramters.Add("@WitnessOneCnic", edeals.WitnessOneCnic);
paramters.Add("@WitnessTwoName", edeals.WitnessTwoName);
paramters.Add("@WitnessTwoCnic", edeals.WitnessTwoCnic);
db.ExecuteQuery(query, paramters);
}
