private void LoadDimensions(int id)
{
ArrayList al = DBLayer.Dimensions.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Dimensions.Details det = (DBLayer.Dimensions.Details)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.Name;
cbDimension.Items.Add(li);
}
for (int i = 0; i < cbDimension.Items.Count; i++)
{
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbDimension.Items[i];
if (li.ID == id)
{
cbDimension.SelectedIndex = i;
break;
}
}
}
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 FrmEditDimension(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.Dimensions.GetDetails(id);
tbName.Text = this.Details.Name;
}
private void cbProduct_SelectedIndexChanged(object sender, EventArgs e)
{
lblDimension.Text = "";
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbProduct.SelectedItem;
DBLayer.Products.Details det = DBLayer.Products.GetDetails(li.ID);
DBLayer.Dimensions.Details detD = DBLayer.Dimensions.GetDetails(det.DimensionId);
lblDimension.Text = detD.Name;
}
private void LoadData()
{
ArrayList al = DBLayer.Dimensions.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Dimensions.Details det = (DBLayer.Dimensions.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.Name;
}
grSources.DataSource = dt;
}
public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM Dimensions");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Dimensions.Details det = new DBLayer.Dimensions.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
al.Add(det);
}
return(al);
}
public static void Update(DBLayer.Dimensions.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE Dimensions SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString());
}
/*#region Check
*
* public static bool Check(string name, int id)
* {
*
* Database.Service serv = new Management.Database.Service();
*
* return serv.AdvertisingSource_Check(name, id);
* }
*
#endregion*/
#region Insert
public static void Insert(DBLayer.Dimensions.Details det)
{
ZFort.DB.Execute.ExecuteString_void("INSERT INTO Dimensions ([Name]) VALUES ('" + det.Name + "')");
}
