private void cbProduct_SelectedIndexChanged(object sender, EventArgs e) { lblDimension.Text = ""; Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbProduct.SelectedItem; DBLayer.Services.Details det = DBLayer.Services.GetDetails(li.ID); this.Product = det; double quantity = 0; if (tbQuantity.Text.Trim() != "") { quantity = Convert.ToDouble(tbQuantity.Text); } double cost = (det.CostPerUnit * quantity); lblCost.Text = cost.ToString(); DBLayer.Dimensions.Details detD = DBLayer.Dimensions.GetDetails(det.DimensionId); lblDimension.Text = detD.Name; }
public static void Update(DBLayer.Services.Details det) { ZFort.DB.Execute.ExecuteString_void("UPDATE Services SET [DimensionId] = " + det.DimensionId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Services SET [CostPerUnit] = " + det.CostPerUnit.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Services SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Services SET [Type] = " + det.Type.ToString() + " WHERE [Id] = " + det.Id.ToString()); }
public static int Insert(DBLayer.Services.Details det) { string sql = "INSERT INTO Services (DimensionId, [Name], CostPerUnit, [Type]) "; sql += " VALUES (" + det.DimensionId.ToString() + ", '" + det.Name + "', " + det.CostPerUnit.ToString().Replace(",", ".") + ", " + det.Type.ToString() + ")"; ZFort.DB.Execute.ExecuteString_void(sql); return((int)ZFort.DB.Execute.ExecuteString_Scalar("SELECT Max(ID) FROM Services")); }
public FrmEditService(int id) { InitializeComponent(); this.Id = id; this.Details = DBLayer.Services.GetDetails(id); LoadDimensions(Details.DimensionId); tbName.Text = Details.Name; tbCurrentPrice.Text = Details.CostPerUnit.ToString(); cbType.SelectedIndex = Details.Type; LoadPrices(); }
public FrmEditServicePrice(DBLayer.Services.Details det) { InitializeComponent(); this.ProductDetails = det; }