public string[] getWarranty(string connString, int pid)
{
try
{
string query = @"select warranty,name from _Product where ID=" + pid + "";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
string[] result = new string[2];
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.M_Product_BS pObj = new BusinessObjects.M_Product_BS();
result[0] = reader[0].ToString();
result[1] = reader[1].ToString();
}
conn.Close();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public BusinessObjects.M_Product_BS Get1Product(string connString)
{
try
{
string query = @"select ID,name,unitPrice,cost,category,description,warranty from _Product where name='" + name + "'";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
BusinessObjects.M_Product_BS pObj = new BusinessObjects.M_Product_BS();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
pObj.ID = Convert.ToInt32(reader[0].ToString());
pObj.name = reader[1].ToString();
pObj.unitPrice = Convert.ToDecimal(reader[2].ToString());
pObj.cost = Convert.ToDecimal(reader[3].ToString());
pObj.category = Convert.ToInt32(reader[4].ToString());
pObj.description = reader[5].ToString();
pObj.warranty = reader[6].ToString();
}
conn.Close();
return(pObj);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BusinessObjects.M_Product_BS> GetProductsWithLikeQuery(string connString, string TypingText)
{
try
{
TypingText = "%" + TypingText + "%";
List <BusinessObjects.M_Product_BS> ProductList = new List <BusinessObjects.M_Product_BS>();
string query = "select ID,name,unitPrice,cost,category,description,warranty from _Product WHERE name LIKE '" + TypingText + "'";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.M_Product_BS pObj = new BusinessObjects.M_Product_BS();
pObj.ID = Convert.ToInt32(reader[0].ToString());
pObj.name = reader[1].ToString();
pObj.unitPrice = Convert.ToDecimal(reader[2].ToString());
pObj.cost = Convert.ToDecimal(reader[3].ToString());
pObj.category = Convert.ToInt32(reader[4].ToString());
pObj.description = reader[5].ToString();
pObj.warranty = reader[6].ToString();
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <M_Product_BS> GetOutOfStockProducts(string connString)
{
try
{
List <BusinessObjects.M_Product_BS> ProductList = new List <BusinessObjects.M_Product_BS>();
string query = @"select ID,name,unitPrice,cost,category,description,warranty from _Product where ID not in (select distinct(pid) from _stock_product)";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.M_Product_BS pObj = new BusinessObjects.M_Product_BS();
pObj.ID = Convert.ToInt32(reader[0].ToString());
pObj.name = reader[1].ToString();
pObj.unitPrice = Convert.ToDecimal(reader[2].ToString());
pObj.cost = Convert.ToDecimal(reader[3].ToString());
pObj.category = Convert.ToInt32(reader[4].ToString());
pObj.description = reader[5].ToString();
pObj.warranty = reader[6].ToString();
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BusinessObjects.M_Product_BS> getProductByVat_ID(string connString, int catID)
{
try
{
List <BusinessObjects.M_Product_BS> ProductList = new List <BusinessObjects.M_Product_BS>();
string query = @"select ID,name,unitPrice,cost,category,warranty from _Product where category=" + catID + "";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.M_Product_BS pObj = new BusinessObjects.M_Product_BS();
pObj.ID = Convert.ToInt32(reader[0].ToString());
pObj.name = reader[1].ToString();
pObj.unitPrice = Convert.ToDecimal(reader[2].ToString());
pObj.cost = Convert.ToDecimal(reader[3].ToString());
pObj.category = Convert.ToInt32(reader[4].ToString());
pObj.warranty = reader[5].ToString();
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
private void lnkAdd_Click(object sender, EventArgs e)
{
try
{
//if (string.IsNullOrEmpty(txtPCost.Text) || string.IsNullOrEmpty(txtProName.Text) || string.IsNullOrEmpty(txtPMPrice.Text) ||
// cmbCategory.SelectedIndex == -1 ||string.IsNullOrEmpty(txtBundlePrice.Text) ||string.IsNullOrEmpty(txtpackagecost.Text)||string.IsNullOrEmpty(txtDescp.Text))
if (string.IsNullOrEmpty(txtPCost.Text) || string.IsNullOrEmpty(txtProName.Text) || string.IsNullOrEmpty(txtPMPrice.Text) ||
cmbCategory.SelectedIndex == -1)
{
MetroMessageBox.Show(this, "Please enter valid data to the text fields", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (Convert.ToDecimal(txtPMPrice.Text) < Convert.ToDecimal(txtPCost.Text))
{
MetroMessageBox.Show(this, "Unit Price should be higher than Unit Cost", "System Warning !", MessageBoxButtons.OK, MessageBoxIcon.Warning);;
}
//else if (Convert.ToDecimal(txtBundlePrice.Text) <= Convert.ToDecimal(txtpackagecost.Text))
//{
// MetroMessageBox.Show(this, "Package Price should be higher than Package Cost", "System Warning !", MessageBoxButtons.OK, MessageBoxIcon.Warning); ;
//}
else
{
string name, description;
//decimal price, boundlePrice, cost, boundlecost;
decimal price, cost;
int category;
name = txtProName.Text;
category = Convert.ToInt32(cmbCategory.SelectedValue);
price = Convert.ToDecimal(txtPMPrice.Text);
//boundlePrice = Convert.ToDecimal(txtBundlePrice.Text);
cost = Convert.ToDecimal(txtPCost.Text);
//boundlecost = Convert.ToDecimal(txtpackagecost.Text);
if (string.IsNullOrEmpty(txtDescp.Text))
{
description = "";
}
else
{
description = txtDescp.Text;
}
BusinessObjects.M_Product_BS BP = new BusinessObjects.M_Product_BS();
//BP.boundlePrice = boundlePrice;
BP.name = name;
BP.category = category;
BP.cost = cost;
BP.unitPrice = price;
//BP.boundleCost = boundlecost;
BP.description = description;
if (cmbMonth.Checked)
{
BP.warranty = numericUpDown1.Value.ToString() + " /Month";
}
else
{
BP.warranty = numericUpDown1.Value.ToString() + " /Week";
}
if (BP.Add(con))
{
MetroMessageBox.Show(this, "Product data added Successfully", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearText();
getMaxId();
}
else
{
MetroMessageBox.Show(this, "! Process encountered an error", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);;
}
}
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, " !System Error. " + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
