public FrmAvalaibleCollateralProducts() { InitializeComponent(); product = new CollateralProduct(); InitializePackages(); webBrowserPackage.ObjectForScripting = this; }
/// <summary> /// Method to add a package into database. We use the NullableTypes to make the correspondance between /// nullable int, decimal and double types in database and our own objects /// </summary> /// <param name="colProduct">Package Object</param> /// <returns>The id of the package which has been added</returns> public int AddCollateralProduct(CollateralProduct colProduct) { string sqlText = @"INSERT INTO [CollateralProducts] ( [name] ,[desc] ,[deleted] ) VALUES ( @name ,@desc ,@deleted ) SELECT CONVERT(int, SCOPE_IDENTITY())"; using (SqlConnection connection = GetConnection()) using (OpenCbsCommand cmd = new OpenCbsCommand(sqlText, connection)) { cmd.AddParam("@name", colProduct.Name); cmd.AddParam("@desc", colProduct.Description); cmd.AddParam("@deleted", colProduct.Delete); colProduct.Id = int.Parse(cmd.ExecuteScalar().ToString()); } foreach (CollateralProperty collateralProperty in colProduct.Properties) { AddCollateralProperty(colProduct.Id, collateralProperty); } return(colProduct.Id); }
public void AddCollateralProduct(CollateralProduct collateralProduct) { var productName = collateralProduct.Name; CheckCollateralProductNameExistance(productName); collateralProductManager.AddCollateralProduct(collateralProduct); }
public void Package_DoubleClick(object sender, HtmlElementEventArgs e) { string sID = webBrowserPackage.Document.GetElementFromPoint(e.MousePosition).Id; CollateralProduct selectedProduct = ServicesProvider.GetInstance().GetCollateralProductServices().SelectCollateralProduct(Convert.ToInt32(sID)); FrmAddCollateralProduct addCollateralProduct = new FrmAddCollateralProduct(selectedProduct); addCollateralProduct.ShowDialog(); }
public FrmAvalaibleCollateralProducts() { InitializeComponent(); product = new CollateralProduct(); refreshListView(); _package = new CollateralProduct(); _selectedPackage = new CollateralProduct(); }
public ContractCollateralForm(CollateralProduct product) { this.product = product; contractCollateral = new ContractCollateral(); myProperties = new CustomClass(); collections = new CollectionList(); InitializeComponent(); FillCollateralProperties(); }
public void Package_Click(object sender, HtmlElementEventArgs e) { var tag = (HtmlElement)(sender); PackageFormId = Convert.ToInt32(tag.Id); product = ServicesProvider.GetInstance().GetCollateralProductServices().SelectCollateralProduct(PackageFormId); buttonDeletePackage.Enabled = true; buttonEditProduct.Enabled = true; }
public FrmAddCollateralProduct() { InitializeComponent(); propertyGrid.SelectedObject = myProperties; collateralProduct = new CollateralProduct(); InitializeMenuPropertyTypes(); SetAddNewProductMode(true); }
private void determineRowColor(CollateralProduct cP, ListViewItem lvi) { if (cP.Delete == true) { lvi.BackColor = System.Drawing.Color.LightGray; } else { lvi.BackColor = System.Drawing.Color.White; } }
public FrmAddCollateralProduct(CollateralProduct collateralProduct) { InitializeComponent(); this.collateralProduct = collateralProduct; propertyGrid.SelectedObject = myProperties; InitializeMenuPropertyTypes(); InitializeProductValues(); SetAddNewProductMode(false); }
public CollateralProduct SelectCollateralProductByPropertyId(int propertyId) { int productId; const string sqlProductIdText = @"SELECT product_id FROM [CollateralProperties] WHERE id = @id "; using (SqlConnection connection = GetConnection()) using (OpenCbsCommand cmd = new OpenCbsCommand(sqlProductIdText, connection)) { cmd.AddParam("@id", propertyId); using (OpenCbsReader reader = cmd.ExecuteReader()) { if (reader.Empty) { return(null); // nothing is coming... (c) } reader.Read(); productId = reader.GetInt("product_id"); } } const string sqlText = @"SELECT [name] ,[desc] ,[deleted] FROM CollateralProducts WHERE id = @id"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand selectProduct = new OpenCbsCommand(sqlText, conn)) { selectProduct.AddParam("@id", productId); using (OpenCbsReader reader = selectProduct.ExecuteReader()) { if (reader.Empty) { return(null); } reader.Read(); CollateralProduct colProduct = new CollateralProduct { Id = productId, Name = reader.GetString("name"), Description = reader.GetString("desc"), Delete = reader.GetBool("deleted") }; return(colProduct); } } }
private void buttonEditProduct_Click(object sender, EventArgs e) { if (PackageFormId != 0) { CollateralProduct selectedProduct = ServicesProvider.GetInstance().GetCollateralProductServices().SelectCollateralProduct(PackageFormId); FrmAddCollateralProduct addCollateralProduct = new FrmAddCollateralProduct(selectedProduct); addCollateralProduct.ShowDialog(); } else { MessageBox.Show(MultiLanguageStrings.GetString(Ressource.PackagesForm, "messageSelection.Text"), MultiLanguageStrings.GetString(Ressource.PackagesForm, "title.Text"), MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void DeletePackage() { try { ServicesProvider.GetInstance().GetCollateralProductServices().DeleteCollateralProduct(retrieveSelectedPackage().Id); refreshListView(); product = null; buttonDeletePackage.Enabled = false; buttonEditProduct.Enabled = false; } catch (Exception ex) { new frmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog(); } }
public ContractCollateralForm(CollateralProduct product, ContractCollateral contractCollateral, bool isView) { this.product = product; this.contractCollateral = contractCollateral; myProperties = new CustomClass(); collections = new CollectionList(); InitializeComponent(); FillCollateralPropertyValues(contractCollateral); if (isView) { propertyGrid.Enabled = false; groupBoxOwnerDetails.Enabled = false; buttonSave.Enabled = false; } }
public ContractCollateralForm(CollateralProduct product, bool isView, IApplicationController applicationController) { _applicationController = applicationController; this.product = product; contractCollateral = new ContractCollateral(); myProperties = new CustomClass(); collections = new CollectionList(); InitializeComponent(); FillCollateralProperties(); if (isView) { propertyGrid.Enabled = false; groupBoxOwnerDetails.Enabled = false; buttonSave.Enabled = false; } }
/// <summary> /// Select all packages in database /// </summary> /// <param name="pShowAlsoDeleted"></param> /// <returns>a list contains all packages</returns> public List <CollateralProduct> SelectAllCollateralProducts(bool pShowAlsoDeleted) { List <CollateralProduct> packagesList = new List <CollateralProduct>(); string sqlText = @"SELECT id FROM CollateralProducts WHERE 1 = 1"; if (!pShowAlsoDeleted) { sqlText += " AND deleted = 0"; } using (SqlConnection connection = GetConnection()) using (OpenCbsCommand selectPackages = new OpenCbsCommand(sqlText, connection)) { using (OpenCbsReader reader = selectPackages.ExecuteReader()) { if (reader.Empty) { return(new List <CollateralProduct>()); } while (reader.Read()) { CollateralProduct pack = new CollateralProduct { Id = reader.GetInt("id") }; packagesList.Add(pack); } } } for (int i = 0; i < packagesList.Count; i++) { packagesList[i] = SelectCollateralProduct(packagesList[i].Id); } return(packagesList); }
private static string _CreateHtmlForShowingPackage(CollateralProduct collateralProduct) { string img = "package.png"; if (collateralProduct.Delete) { img = "package_delete.png"; } string text = string.Format(@" <form id='{1}' name='package{1}'> <table id={1} cellpadding='0' cellspacing='0' border='0' class='list_content' onclick='click_book(this,{1});' onmouseenter='mouse_enter_book(this);' onmouseleave='mouse_leave_book(this);'> <tr> <td> <table class='book_list' cellpadding='0' cellspacing='0' border='0'> <tr> <td> <table cellpadding='0' cellspacing='0' border='0'> <tr> <td><img id='{1}' src='{0}'/></td> </tr> </table> </td> </tr> </table> </td> <td style='width:100%'> <span > <span class='title_popup'>{2} ({3})</span> </span> </td> </tr> </table></form>", Path.Combine(UserSettings.GetTemplatePath, img), collateralProduct.Id, collateralProduct.Name, collateralProduct.Description); return(text); }
private CollateralProduct retrieveSelectedPackage() { _package = (CollateralProduct)descriptionListView.SelectedItems[0].Tag; _selectedPackage = ServicesProvider.GetInstance().GetCollateralProductServices().SelectCollateralProduct(_package.Id); return(_selectedPackage); }
/// <summary> /// This method allows us to select a package from database. We use the NullableTypes to make the correspondance between /// nullable int, decimal and double types in database and our own objects /// </summary> /// <param name="colProductId">id's of package searched</param> /// <returns>A package Object if id matches with datas in database, null if not</returns> public CollateralProduct SelectCollateralProduct(int colProductId) { const string sqlText = @"SELECT [name] ,[desc] ,[deleted] FROM CollateralProducts WHERE id = @id"; CollateralProduct colProduct = new CollateralProduct(); using (SqlConnection connection = GetConnection()) using (OpenCbsCommand cmd = new OpenCbsCommand(sqlText, connection)) { cmd.AddParam("@id", colProductId); using (OpenCbsReader reader = cmd.ExecuteReader()) { if (reader.Empty) { return(null); } reader.Read(); colProduct.Id = colProductId; colProduct.Name = reader.GetString("name"); colProduct.Description = reader.GetString("desc"); colProduct.Delete = reader.GetBool("deleted"); reader.Dispose(); } } List <CollateralProperty> properties = new List <CollateralProperty>(); const string sqlPropertyText = @"SELECT id ,type_id ,[name] ,[desc] FROM CollateralProperties WHERE product_id = @product_id"; using (SqlConnection connection = GetConnection()) using (OpenCbsCommand cmd = new OpenCbsCommand(sqlPropertyText, connection)) { cmd.AddParam("@product_id", colProduct.Id); using (OpenCbsReader reader = cmd.ExecuteReader()) { if (reader.Empty) { return(null); } while (reader.Read()) { CollateralProperty collateralProperty = new CollateralProperty(); collateralProperty.Id = reader.GetInt("id"); collateralProperty.Type = (OCollateralPropertyTypes)Enum.ToObject(typeof(OCollateralPropertyTypes), reader.GetInt("type_id")); collateralProperty.Name = reader.GetString("name"); collateralProperty.Description = reader.GetString("desc"); if (collateralProperty.Type == OCollateralPropertyTypes.Collection) { List <string> propertyList = new List <string>(); const string sqlListText = @"SELECT [value] FROM CollateralPropertyCollections WHERE property_id = @property_id"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand selectList = new OpenCbsCommand(sqlListText, conn)) { selectList.AddParam("@property_id", collateralProperty.Id); using (OpenCbsReader listReader = selectList.ExecuteReader()) { if (listReader.Empty) { return(null); } while (listReader.Read()) { propertyList.Add(listReader.GetString("value")); } collateralProperty.Collection = propertyList; } } } properties.Add(collateralProperty); } colProduct.Properties = properties; } } return(colProduct); }