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