public RMS.Common.ObjectModel.CResult GetCategory3(int inCat3ID)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.GetCategory3), inCat3ID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
CCategory3 oCat = ReaderToCategory3(oReader);
oResult.Data = oCat;
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private bool CheckCatOrder3ForUpdate(CCategory3 inUser)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.CheckCat3OrderForUpdate), inUser.Category3Order, inUser.Category2ID, inUser.Category3ID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
if (oReader.Read())
{
if (oReader["cat3_id"] != null)
{
int iTemp = Int32.Parse(oReader["cat3_id"].ToString());
return(true);
}
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return(false);
}
private bool CheckCat3(CCategory3 inUser)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.CheckDupCat3), inUser.Category3Name, inUser.Category2ID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
if (oReader["cat3_id"] != null)
{
int iTemp = Int32.Parse(oReader["cat3_id"].ToString());
return(true);
}
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemInsert()", ex);
}
finally
{
this.CloseConnection();
}
return(false);
}
public RMS.Common.ObjectModel.CResult GetCategory3All()
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetCategory3All));
IDataReader oReader = this.ExecuteReader(sqlCommand);
List <CCategory3> oCat3List = new List <CCategory3>();
if (oReader != null)
{
while (oReader.Read())
{
CCategory3 oCat = ReaderToCategory3(oReader);
oCat3List.Add(oCat);
}
}
oResult.Data = oCat3List;
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult UpdateCategory3Order(CCategory3 inUser, CCategory3 inUser2, bool inUpFlag)
{
try
{
if (inUpFlag)
{
//up
m_oResult = RMS.DataAccess.Database.Instance.Category3.Cat3UpdateOrderUp(inUser, inUser2);
}
else
{
//down
m_oResult = RMS.DataAccess.Database.Instance.Category3.Cat3UpdateOrderDown(inUser, inUser2);
}
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at DeleteItem() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in DeleteItem()", LogLevel.Error, "CItemManager");
}
return(m_oResult);
}
private void dgvFoodItem_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
try
{
if (e.ColumnIndex == 6)
{
Int32 itemID = Convert.ToInt32("0" + dgvFoodItem.Rows[e.RowIndex].Cells[0].Value);
UpdateFoodItemCtl objUpdate = new UpdateFoodItemCtl(itemID);
objUpdate.Parent = this.ParentForm;
UserControlManager.UserControls.Push(this);
Panel pnl = (Panel)this.ParentForm.Controls["pnlContext"];
string s = pnl.Name;
objUpdate.ParentForm.Controls[s].Controls.Clear();
objUpdate.ParentForm.Controls[s].Controls.Add(objUpdate);
}
else if (e.ColumnIndex == 7)
{
if (MessageBox.Show("Are you sure you want to delete the selected category?", RMSGlobal.MessageBoxTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int itemID = 0;
bool bTempBool = Int32.TryParse(dgvFoodItem.Rows[e.RowIndex].Cells[0].Value.ToString(), out itemID);
if (bTempBool)
{
CCategory3 oCat = new CCategory3();
oCat.Category3ID = itemID;
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.DeleteCat3(oCat);
if (oResult.IsSuccess)
{
dgvFoodItem.Rows.RemoveAt(e.RowIndex);
}
}
}
}
}
catch (Exception exp)
{
throw exp;
}
}
private CResult GetOrderCandidateSingle(CCategory3 oCat)
{
CResult oResult = new CResult();
try
{
List <int> iTempList = new List <int>();
//CCat3Rank oTempCat2List = new CCat3Rank();
this.OpenConnection();
// CResult oResult2 = GetChildCat3(iTempCat2ID);
CCat3Rank oTempCat2Rank = new CCat3Rank();
oTempCat2Rank.Category3ID = oCat.Category3ID;
CResult oResult3 = GetChildCat4ByCat3(oCat.Category3ID);
if (oResult3.IsSuccess && oResult3.Data != null)
{
List <CCat4Rank> oTempChildList2 = (List <CCat4Rank>)oResult3.Data;
oTempCat2Rank.ChildCat4List = oTempChildList2;
}
//oTempCat2List.Add(oTempCat2Rank);
oResult.Data = oTempCat2Rank;
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult DeleteCat3(CCategory3 inUser)
{
try
{
m_oResult = RMS.DataAccess.Database.Instance.Category3.Cat3Delete(inUser);
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at DeleteItem() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in DeleteItem()", LogLevel.Error, "CItemManager");
}
return(m_oResult);
}
public void AddPurchaseStore(CCategory3 objFoodItem, string name)
{
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.AddPurchaseStore), objFoodItem.Category3Name,
objFoodItem.UoM, objFoodItem.Category3ID, name);
this.ExecuteNonQuery(sqlComm);
}
catch (Exception)
{
}
finally
{
this.CloseConnection();
}
}
private CCategory3 ReaderToCategory3(IDataReader oReader)
{
CCategory3 oItem = new CCategory3();
if (oReader["cat3_id"] != null)
{
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
}
if (oReader["cat3_name"] != null)
{
oItem.Category3Name = oReader["cat3_name"].ToString();
}
if (oReader["cat2_id"] != null)
{
oItem.Category2ID = Int32.Parse(oReader["cat2_id"].ToString());
}
if (oReader["description"] != null)
{
oItem.Category3Description = oReader["description"].ToString();
}
if (oReader["table_price"] != null)
{
oItem.Category3TablePrice = Double.Parse(oReader["table_price"].ToString());
}
if (oReader["tw_price"] != null)
{
oItem.Category3TakeAwayPrice = Double.Parse(oReader["tw_price"].ToString());
}
if (oReader["bar_price"] != null)
{
oItem.Category3BarPrice = Double.Parse(oReader["bar_price"].ToString());
}
if (oReader["status"] != null)
{
oItem.Category3OrderStatus = Int32.Parse(oReader["status"].ToString());
}
if (oReader["cat3_order"] != null)
{
oItem.Category3Order = Int32.Parse(oReader["cat3_order"].ToString());
}
if (oReader["view_table"] != null)
{
oItem.Category3ViewTable = Int32.Parse(oReader["view_table"].ToString());
}
if (oReader["view_bar"] != null)
{
oItem.Category3ViewBar = Int32.Parse(oReader["view_bar"].ToString());
}
if (oReader["view_takeaway"] != null)
{
oItem.Category3ViewTakeAway = Int32.Parse(oReader["view_takeaway"].ToString());
}
if (oReader["food_item_stock_quantity"] != null)
{
oItem.InitialItemQuantity = Int32.Parse("0" + oReader["food_item_stock_quantity"]);
}
if (oReader["unlimited_status"] != null)
{
oItem.UnlimitStatus = Convert.ToInt32(oReader["unlimited_status"]);
}
if (oReader["selling_in"] != null)
{
oItem.ItemSellingIn = Convert.ToString(oReader["selling_in"]);
}
//Vat
if (oReader["vat_Rate"] != null)
{
oItem.vatRate = Double.Parse(oReader["vat_Rate"].ToString());
}
if (oReader["vat_included"] != null)
{
oItem.vatIncluded = Convert.ToBoolean(oReader["vat_included"].ToString());
}
try
{
if (oReader["productType"] != null)
{
oItem.ProductType = oReader["productType"].ToString();
}
}
catch { }
//print_area
try
{
if (oReader["print_area"] != null)
{
oItem.PrintArea = oReader["print_area"].ToString();
}
}
catch { }
try
{
if (oReader["uom"] != null)
{
oItem.UoM = oReader["uom"].ToString();
}
}
catch { }
if (oReader["cat3_rank"] != null)
{
String sTempStr = oReader["cat3_rank"].ToString();
if (!sTempStr.Equals(String.Empty))
{
oItem.Rank = Int64.Parse(sTempStr);
}
}
try
{
oItem.TableCost = Convert.ToDouble(oReader["tablecost"]);
}
catch (Exception)
{
}
try
{
oItem.TakeAwayCost = Convert.ToDouble(oReader["takeawaycost"]);
}
catch (Exception)
{
}
try
{
oItem.BarCost = Convert.ToDouble(oReader["barcost"]);
}
catch (Exception)
{
}
return(oItem);
}
private void btnUp_Click(object sender, EventArgs e)
{
try
{
if (m_selectedIndex > 0 && dgvFoodItem.Rows.Count > m_selectedIndex)
{
int iTempInt = Int32.Parse(dgvFoodItem.Rows[m_selectedIndex].Cells[0].Value.ToString());
int iTempInt3 = Int32.Parse(dgvFoodItem.Rows[m_selectedIndex].Cells[2].Value.ToString());
CCategory3 oCat = new CCategory3();
oCat.Category3ID = iTempInt;
oCat.Category3Order = iTempInt3;
if ((m_selectedIndex - 1) >= 0 && dgvFoodItem.Rows.Count > (m_selectedIndex - 1))
{
int iTempInt2 = Int32.Parse(dgvFoodItem.Rows[(m_selectedIndex - 1)].Cells[0].Value.ToString());
int iTempInt4 = Int32.Parse(dgvFoodItem.Rows[(m_selectedIndex - 1)].Cells[2].Value.ToString());
int iTempIndex = m_selectedIndex - 1;
CCategory3 oCat2 = new CCategory3();
oCat2.Category3ID = iTempInt2;
oCat2.Category3Order = iTempInt4;
if (cmbCategory.SelectedValue != null)
{
int iTempInt10 = Int32.Parse(cmbCategory.SelectedValue.ToString());
oCat2.Category2ID = iTempInt10;
oCat.Category2ID = iTempInt10;
}
CCategoryManager oCatManager = new CCategoryManager();
CResult oResult = oCatManager.UpdateCategory3Order(oCat, oCat2, true);
if (oResult.IsSuccess)
{
if (m_bGridFlag)
{
Int32 categoryID = Convert.ToInt32(cmbCategory.SelectedValue);
FillFoodItem(categoryID);
dgvFoodItem.Rows[0].Selected = false;
dgvFoodItem.Rows[iTempIndex].Selected = true;
m_selectedIndex = iTempIndex;
if (m_selectedIndex > 12)
{
dgvFoodItem.FirstDisplayedScrollingRowIndex = m_selectedIndex - 12;
}
}
else
{
Int32 categoryID = Convert.ToInt32(cmbCategory.SelectedValue);
FillFoodItem(categoryID);
dgvFoodItem.Rows[0].Selected = false;
dgvFoodItem.Rows[iTempIndex].Selected = true;
m_selectedIndex = iTempIndex;
if (m_selectedIndex > 12)
{
dgvFoodItem.FirstDisplayedScrollingRowIndex = m_selectedIndex - 12;
}
}
}
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message + "Error Occured. Please contact to your administrator.", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Saving the food item.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
CResult objResult = ValidateForm();
if (objResult.IsSuccess)
{
CCategory3 objFoodItem = new CCategory3();
objFoodItem.Category2ID = Int32.Parse(cmbCategory.SelectedValue.ToString());
objFoodItem.Category3Name = txtProductName.Text.Trim();
objFoodItem.Category3Description = txtDescription.Text.Trim();
objFoodItem.PrintArea = printareacomboBox.Text;
if (chkTable.Checked)
{
objFoodItem.Category3ViewTable = 1;
}
if (chkBar.Checked)
{
objFoodItem.Category3ViewBar = 1;
}
if (chkTakeAway.Checked)
{
objFoodItem.Category3ViewTakeAway = 1;
}
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtTakeawayPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TakeAwayPrice = Double.Parse(txtTakeawayPrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
//Add by mithu
if (!tblCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TableCost = Double.Parse(tblCost.Text.Trim());
}
if (!takeawayCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TakeAwayCost = Double.Parse(takeawayCost.Text.Trim());
}
if (!barCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.BarCost = Double.Parse(barCost.Text.Trim());
}
if (rdoActive.Checked)
{
objFoodItem.Category3OrderStatus = 1;
}
else if (rdoInactive.Checked)
{
objFoodItem.Category3OrderStatus = 0;
}
if (chkUnlimited.Checked)
{
objFoodItem.InitialItemQuantity = 0;
objFoodItem.UnlimitStatus = 1;
}
else
{
objFoodItem.InitialItemQuantity = Convert.ToInt32("0" + txtInitialQuantity.Text);
objFoodItem.UnlimitStatus = 0;
}
objFoodItem.ItemSellingIn = cmbSellingIn.Text; //Whether the item sold in quantity or weight
try
{
objFoodItem.vatRate = Convert.ToDouble(txtVateRate.Text.ToString());
}
catch
{
objFoodItem.vatRate = 0.00;
}
if (chkVateIncluded.Checked)
{
objFoodItem.vatIncluded = true;
}
else
{
objFoodItem.vatIncluded = false;
}
objFoodItem.ProductType = ProductType;
// if(ProductType=="")
try
{
objFoodItem.UoM = cmbSellingIn.Text;
}
catch { }
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.AddCategory3(objFoodItem);
if (oResult2.IsSuccess)
{
if (ProductType == "RawMaterial")
{
CCategory3DAO aCategory3Dao = new CCategory3DAO();
objFoodItem.Category3ID = Convert.ToInt32(categorycomboBox.SelectedValue);
aCategory3Dao.AddPurchaseStore(objFoodItem, categorycomboBox.Text);
}
lblSaveStatus.Text = " The product has been saved successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = "The product can not be added. Please try again. ";
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = objResult.Message;
lblSaveStatus.Visible = true;
}
}
private void LoadExistingData()
{
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.GetCategory3(m_foodItemID);
CCategory3 objFoodItem = new CCategory3();
if (oResult.IsSuccess && oResult.Data != null)
{
objFoodItem = (CCategory3)oResult.Data;
txtProductName.Text = objFoodItem.Category3Name;
txtOrder.Text = objFoodItem.Category3Order.ToString();
m_iCat3Order = objFoodItem.Category3Order;
txtDescription.Text = objFoodItem.Category3Description;
txtTablePrice.Text = objFoodItem.Category3TablePrice.ToString("F02");
txtTakeawayPrice.Text = objFoodItem.Category3TakeAwayPrice.ToString("F02");
txtBarPrice.Text = objFoodItem.Category3BarPrice.ToString("F02");
cmbSellingIn.Text = objFoodItem.ItemSellingIn;
txtVateRate.Text = objFoodItem.vatRate.ToString();
selectarealabel.Text = objFoodItem.PrintArea;
tblCost.Text = objFoodItem.TableCost.ToString("F02");
takeawayCost.Text = objFoodItem.TakeAwayCost.ToString("F02");
barCost.Text = objFoodItem.BarCost.ToString("F02");
try
{
chkVateIncluded.Checked = objFoodItem.vatIncluded;
}
catch { }
if (objFoodItem.UnlimitStatus == 1)
{
txtInitialQuantity.Clear();
chkUnlimited.Checked = true;
}
else
{
txtInitialQuantity.Text = objFoodItem.InitialItemQuantity.ToString();
}
m_iRank = objFoodItem.Rank;
if (objFoodItem.Category3ViewTable == 1)
{
chkTable.Checked = true;
}
if (objFoodItem.Category3ViewBar == 1)
{
chkBar.Checked = true;
}
if (objFoodItem.Category3ViewTakeAway == 1)
{
chkTakeAway.Checked = true;
}
}
oResult = oManager.GetCategoryAncestors(m_foodItemID, 3);
CCategoryAncestor oCatAnc = (CCategoryAncestor)oResult.Data;
if (oResult.IsSuccess && oResult.Data != null)
{
int tmpCat3ID = oCatAnc.Category3ID;
int tmpCat2ID = oCatAnc.Category2ID;
int tmpCat1ID = oCatAnc.Category1ID;
int tmpParentCatID = oCatAnc.ParentCategoryID;
if (objFoodItem.Category3OrderStatus == 1)
{
m_activeStatus = true;
rdoActive.Checked = true;
}
else if (objFoodItem.Category3OrderStatus == 0)
{
rdoInActive.Checked = true;
m_activeStatus = false;
}
cmbParent.SelectedValue = tmpParentCatID;
cmbFoodType.SelectedValue = tmpCat1ID;
cmbCategory.SelectedValue = tmpCat2ID;
}
}
/// <summary>
/// Saving the food item.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
CResult objResult = ValidateForm();
if (objResult.IsSuccess)
{
CCategory3 objFoodItem = new CCategory3();
objFoodItem.Category2ID = Int32.Parse(cmbCategory.SelectedValue.ToString());
objFoodItem.Category3Name = txtProductName.Text.Trim();
objFoodItem.Category3Description = txtDescription.Text.Trim();
if (chkTable.Checked)
{
objFoodItem.Category3ViewTable = 1;
}
if (chkBar.Checked)
{
objFoodItem.Category3ViewBar = 1;
}
if (chkTakeAway.Checked)
{
objFoodItem.Category3ViewTakeAway = 1;
}
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtTakeawayPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TakeAwayPrice = Double.Parse(txtTakeawayPrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
if (rdoActive.Checked)
{
objFoodItem.Category3OrderStatus = 1;
}
else if (rdoInactive.Checked)
{
objFoodItem.Category3OrderStatus = 0;
}
if (chkUnlimited.Checked)
{
objFoodItem.InitialItemQuantity = 0;
objFoodItem.UnlimitStatus = 1;
}
else
{
objFoodItem.InitialItemQuantity = Convert.ToInt32("0" + txtInitialQuantity.Text);
objFoodItem.UnlimitStatus = 0;
}
objFoodItem.ItemSellingIn = cmbSellingIn.Text; //Whether the item sold in quantity or weight
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.AddCategory3(objFoodItem);
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = " The product has been saved successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = "The product can not be added. Please try again. ";
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = objResult.Message;
lblSaveStatus.Visible = true;
}
}
private CCategory3 ReaderToCategory3(IDataReader oReader)
{
CCategory3 oItem = new CCategory3();
if (oReader["cat3_id"] != null)
{
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
}
if (oReader["cat3_name"] != null)
{
oItem.Category3Name = oReader["cat3_name"].ToString();
}
if (oReader["cat2_id"] != null)
{
oItem.Category2ID = Int32.Parse(oReader["cat2_id"].ToString());
}
if (oReader["description"] != null)
{
oItem.Category3Description = oReader["description"].ToString();
}
if (oReader["table_price"] != null)
{
oItem.Category3TablePrice = Double.Parse(oReader["table_price"].ToString());
}
if (oReader["tw_price"] != null)
{
oItem.Category3TakeAwayPrice = Double.Parse(oReader["tw_price"].ToString());
}
if (oReader["bar_price"] != null)
{
oItem.Category3BarPrice = Double.Parse(oReader["bar_price"].ToString());
}
if (oReader["status"] != null)
{
oItem.Category3OrderStatus = Int32.Parse(oReader["status"].ToString());
}
if (oReader["cat3_order"] != null)
{
oItem.Category3Order = Int32.Parse(oReader["cat3_order"].ToString());
}
if (oReader["view_table"] != null)
{
oItem.Category3ViewTable = Int32.Parse(oReader["view_table"].ToString());
}
if (oReader["view_bar"] != null)
{
oItem.Category3ViewBar = Int32.Parse(oReader["view_bar"].ToString());
}
if (oReader["view_takeaway"] != null)
{
oItem.Category3ViewTakeAway = Int32.Parse(oReader["view_takeaway"].ToString());
}
if (oReader["food_item_stock_quantity"] != null)
{
oItem.InitialItemQuantity = Int32.Parse("0" + oReader["food_item_stock_quantity"]);
}
if (oReader["unlimited_status"] != null)
{
oItem.UnlimitStatus = Convert.ToInt32(oReader["unlimited_status"]);
}
if (oReader["selling_in"] != null)
{
oItem.ItemSellingIn = Convert.ToString(oReader["selling_in"]);
}
if (oReader["cat3_rank"] != null)
{
String sTempStr = oReader["cat3_rank"].ToString();
if (!sTempStr.Equals(String.Empty))
{
oItem.Rank = Int64.Parse(sTempStr);
}
}
return(oItem);
}
private CCategory3 ReaderToCategory3(IDataReader oReader)
{
CCategory3 oItem = new CCategory3();
if (oReader["cat3_id"] != null)
{
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
}
if (oReader["cat3_name"] != null)
{
oItem.Category3Name = oReader["cat3_name"].ToString();
}
if (oReader["cat2_id"] != null)
{
oItem.Category2ID = Int32.Parse(oReader["cat2_id"].ToString());
}
if (oReader["description"] != null)
{
oItem.Category3Description = oReader["description"].ToString();
}
if (oReader["table_price"] != null)
{
oItem.Category3TablePrice = Double.Parse(oReader["table_price"].ToString());
}
if (oReader["tw_price"] != null)
{
oItem.Category3TakeAwayPrice = Double.Parse(oReader["tw_price"].ToString());
}
if (oReader["bar_price"] != null)
{
oItem.Category3BarPrice = Double.Parse(oReader["bar_price"].ToString());
}
if (oReader["status"] != null)
{
oItem.Category3OrderStatus = Int32.Parse(oReader["status"].ToString());
}
if (oReader["cat3_order"] != null)
{
oItem.Category3Order = Int32.Parse(oReader["cat3_order"].ToString());
}
if (oReader["view_table"] != null)
{
oItem.Category3ViewTable = Int32.Parse(oReader["view_table"].ToString());
}
if (oReader["view_bar"] != null)
{
oItem.Category3ViewBar = Int32.Parse(oReader["view_bar"].ToString());
}
if (oReader["view_takeaway"] != null)
{
oItem.Category3ViewTakeAway = Int32.Parse(oReader["view_takeaway"].ToString());
}
//if (oReader["cat3_rank"] != null)
// oItem.Rank = Int64.Parse(oReader["cat3_rank"].ToString());
if (oReader["cat3_rank"] != null)
{
String sTempStr = oReader["cat3_rank"].ToString();
if (!sTempStr.Equals(String.Empty))
{
oItem.Rank = Int64.Parse(sTempStr);
}
}
return(oItem);
}
private CResult GetOrderCandidateLower(CCategory3 oCat, int inCatOrder)
{
CResult oResult = new CResult();
try
{
List <int> iTempList = new List <int>();
List <CCat3Rank> oTempCat3List = new List <CCat3Rank>();
if (oCat.Category3Order <= inCatOrder)
{
oResult.Data = oTempCat3List;
oResult.IsSuccess = true;
}
else
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetCat3OrderCandidateLower), oCat.Category2ID, inCatOrder, oCat.Category3Order);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
if (oReader["cat3_id"] != null)
{
int iTempInt = Int32.Parse(oReader["cat3_id"].ToString());
iTempList.Add(iTempInt);
}
}
oReader.Close();
for (int counter = 0; counter < iTempList.Count; counter++)
{
int iTempCat2ID = iTempList[counter];
CCat3Rank oTempCat2Rank = new CCat3Rank();
oTempCat2Rank.Category3ID = iTempCat2ID;
CResult oResult3 = GetChildCat4ByCat3(iTempCat2ID);
if (oResult3.IsSuccess && oResult3.Data != null)
{
List <CCat4Rank> oTempChildList2 = (List <CCat4Rank>)oResult3.Data;
oTempCat2Rank.ChildCat4List = oTempChildList2;
}
oTempCat3List.Add(oTempCat2Rank);
}
oResult.Data = oTempCat3List;
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private void btnSave_Click(object sender, EventArgs e)
{
CResult oResult = ValidateForm();
if (oResult.IsSuccess)
{
CCategory3 objFoodItem = new CCategory3();
String tempName = txtProductName.Text;
int tempCat3Order = int.Parse(txtOrder.Text);
String tempDescription = txtDescription.Text;
objFoodItem.PrintArea = printareacomboBox.Text;
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
if (!txtTakeawayPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TakeAwayPrice = Double.Parse(txtTakeawayPrice.Text.Trim());
}
if (!tblCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TableCost = Double.Parse(tblCost.Text.Trim());
}
if (!takeawayCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TakeAwayCost = Double.Parse(takeawayCost.Text.Trim());
}
if (!barCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.BarCost = Double.Parse(barCost.Text.Trim());
}
int tempViewTable = chkTable.Checked == true ? 1 : 0;
int tempViewBar = chkBar.Checked == true ? 1 : 0;
int tempViewTW = chkTakeAway.Checked == true ? 1 : 0;
objFoodItem.Category3Name = tempName;
objFoodItem.Category3Order = tempCat3Order;
objFoodItem.Category3Description = tempDescription;
objFoodItem.Category3ViewTable = tempViewTable;
objFoodItem.Category3ViewBar = tempViewBar;
objFoodItem.Category3ViewTakeAway = tempViewTW;
objFoodItem.Category3ID = m_foodItemID;
if (chkUnlimited.Checked)
{
objFoodItem.InitialItemQuantity = 0;
objFoodItem.UnlimitStatus = 1;
}
else
{
objFoodItem.InitialItemQuantity = Convert.ToInt32("0" + txtInitialQuantity.Text);
objFoodItem.UnlimitStatus = 0;
}
objFoodItem.ItemSellingIn = cmbSellingIn.Text;
objFoodItem.Category2ID = Int32.Parse(cmbCategory.SelectedValue.ToString());
if (m_activeStatus == true)
{
objFoodItem.Category3OrderStatus = 1;
}
else if (m_activeStatus)
{
objFoodItem.Category3OrderStatus = 0;
}
//Vat included or not and amount of vat
try
{
objFoodItem.vatRate = Convert.ToDouble(txtVateRate.Text.ToString());
}
catch
{
objFoodItem.vatRate = 0.00;
}
if (chkVateIncluded.Checked)
{
objFoodItem.vatIncluded = true;
}
else
{
objFoodItem.vatIncluded = false;
}
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.UpdateCategory3(objFoodItem, m_iCat3Order);
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = "Food item has been updated successfully. ";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult2.Message;
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}