public ClsItemData getSingleItemData(int itemId)
{
ClsItemData itemData = new ClsItemData();
try
{
string querry = @"SELECT * FROM vw_item WHERE itemId = '" + itemId + "'; ";
DataTable dt = new DataTable();
dt = CONN.getDataTable(querry);
if (dt.Rows.Count > 0)
{
itemData._itemId = Convert.ToInt32(dt.Rows[0]["itemId"].ToString());
itemData._itemCode = dt.Rows[0]["itemCode"].ToString();
itemData._itemName = dt.Rows[0]["itemName"].ToString();
itemData._altName = dt.Rows[0]["altName"].ToString();
itemData._itemTypeId = Convert.ToInt32(dt.Rows[0]["itemTypeId"].ToString());
itemData._itemTypeName = dt.Rows[0]["itemType"].ToString();
itemData._stockUnitId = Convert.ToInt32(dt.Rows[0]["stockUnitId"].ToString());
itemData._stockUnitName = dt.Rows[0]["stockUnit"].ToString();
itemData._shopUnitId = Convert.ToInt32(dt.Rows[0]["shopUnitId"].ToString());
itemData._shopUnitName = dt.Rows[0]["shopUnit"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(itemData);
}
public bool insertData_item(ClsItemData itemData)
{
bool isOK = false;
string querry = string.Empty;
try
{
querry += "INSERT INTO tbl_item (itemId, itemCode, itemName, altName, itemTypeId, stockUnitId, shopUnitId) VALUES (";
querry += "'" + itemData._itemId + "',";
querry += "'" + itemData._itemCode + "',";
querry += "'" + itemData._itemName + "',";
querry += "'" + itemData._altName + "',";
querry += "'" + itemData._itemTypeId + "',";
querry += "'" + itemData._stockUnitId + "',";
querry += "'" + itemData._shopUnitId + "'";
querry += ");";
isOK = CONN.update(querry);
}
catch (Exception ex)
{
throw ex;
}
return(isOK);
}
public bool updateData_item(ClsItemData itemData)
{
bool isOK = false;
string querry = string.Empty;
try
{
querry += "UPDATE tbl_item SET ";
querry += "itemName = '" + itemData._itemName + "', ";
querry += "altName = '" + itemData._altName + "', ";
querry += "itemTypeId = '" + itemData._itemTypeId + "', ";
querry += "stockUnitId = '" + itemData._stockUnitId + "', ";
querry += "shopUnitId = '" + itemData._shopUnitId + "' ";
querry += "WHERE itemId = '" + itemData._itemId + "';";
isOK = CONN.update(querry);
}
catch (Exception ex)
{
throw ex;
}
return(isOK);
}
