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