public RMS.Common.ObjectModel.CResult GetCategory4(RMS.Common.ObjectModel.CCategory4 inCat)
{
CResult oResult = null;
try
{
this.OpenConnection();
string sSql = "";// string.Format(SqlQueries.GetQuery(Query), gItemId);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
inCat = ReaderToCategory4(oReader);
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult Cat4Delete(CCategory4 oCat)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.DeleteCategory4), oCat.Category4ID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return oResult;
}
public RMS.Common.ObjectModel.CResult Cat4Delete(RMS.Common.ObjectModel.CCategory4 oCat)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.DeleteCategory4), oCat.Category4ID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult AddCat4(CCategory4 inUser)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckCat(inUser);
if (bTempFlag)
{
oResult.Message = "Category1 exists with this name.";
}
else
{
bTempFlag = CheckCatOrder(inUser);
if (bTempFlag)
{
oResult.Message = "Category order exists. Write another order.";
}
else
{
this.OpenConnection();
string sSql = "";// String.Format(SqlQueries.GetQuery(Query.AddCategory1), inUser.Category1Name, inUser.Category1Order, inUser.ParentCatID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = 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 oResult;
}
public RMS.Common.ObjectModel.CResult Cat4UpdateOrderUp(RMS.Common.ObjectModel.CCategory4 oCat, RMS.Common.ObjectModel.CCategory4 oCat2)
{
CResult oResult = new CResult();
try
{
CCommonConstants oConstants = ConfigManager.GetConfig <CCommonConstants>();
int iTempCat2Order = 0;
int iTempCat3Order = 0;
CResult oResult4 = GetCategory2Order(oCat.Category3ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
CCat4Rank oTempCat4Rank5 = (CCat4Rank)oResult4.Data;
iTempCat2Order = oTempCat4Rank5.Category2Order;
iTempCat3Order = oTempCat4Rank5.Category3Order;
}
else
{
return(oResult);
}
this.OpenConnectionWithTransection();
CCat4Rank oTempCat4Rank7 = new CCat4Rank();
oTempCat4Rank7.Category4ID = oCat.Category4ID;
oTempCat4Rank7.Category4Order = oCat2.Category4Order;
UpdateCat4Rank(oTempCat4Rank7, iTempCat2Order, iTempCat3Order);
CCat4Rank oTempCat4Rank6 = new CCat4Rank();
oTempCat4Rank6.Category4ID = oCat2.Category4ID;
oTempCat4Rank6.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank6, iTempCat2Order, iTempCat3Order);
string sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oConstants.MaxOrderChange, oCat2.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oCat2.Category4Order, oCat.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oCat.Category4Order, oCat2.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemDelete()", ex);
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult Cat4Update(RMS.Common.ObjectModel.CCategory4 oCat, int inCatOrder)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckCat4ForUpdate(oCat);
if (bTempFlag)
{
oResult.Message = "Category exists with this name.";
}
else
{
int iTempCat2Order = 0;
int iTempCat3Order = 0;
CResult oResult4 = GetCategory2Order(oCat.Category3ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
CCat4Rank oTempCat4Rank5 = (CCat4Rank)oResult4.Data;
iTempCat2Order = oTempCat4Rank5.Category2Order;
iTempCat3Order = oTempCat4Rank5.Category3Order;
}
else
{
return(oResult);
}
List <int> oTempList = new List <int>();
List <int> oTempList2 = new List <int>();
CResult oResult2 = GetOrderCandidate(oCat);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (List <int>)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateLower(oCat, inCatOrder);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (List <int>)oResult3.Data;
}
this.OpenConnectionWithTransection();
string sSql = "";
int iTempInt = 0;
int iTempInt2 = 0;
int iTempInt3 = 0;
int i = 0;
for (i = 0; i < oTempList.Count; i++)
{
iTempInt = oTempList[i];
if (iTempInt == oCat.Category4ID)
{
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
}
else
{
iTempInt2 = oCat.Category4Order + 1 + iTempInt3;
iTempInt3 = iTempInt3 + 1;
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = iTempInt2;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), iTempInt2, iTempInt);
this.ExecuteNonQuery(sSql);
}
}
oCat.Category4Name = oCat.Category4Name.Replace("''", "'");
oCat.Category4Name = oCat.Category4Name.Replace("'", "''");
oCat.Category4Description = oCat.Category4Description.Replace("''", "'");
oCat.Category4Description = oCat.Category4Description.Replace("'", "''");
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCategory4), oCat.Category4Name, oCat.Category3ID, oCat.Category4Description, oCat.Category4TablePrice, oCat.Category4TakeAwayPrice, oCat.Category4BarPrice, oCat.Category4OrderStatus, oCat.Category4Order, oCat.Category4ViewTable, oCat.Category4ViewBar, oCat.Category4ViewTakeAway, oCat.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks, oCat.InitialItemQuantity, oCat.UnlimitStatus, oCat.vatIncluded, oCat.vatRate);
this.ExecuteNonQuery(sSql);
iTempInt3 = 1;
sSql = "";
for (i = 0; i < oTempList2.Count; i++)
{
iTempInt = oTempList2[i];
if (iTempInt == oCat.Category4ID)
{
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
}
else
{
iTempInt2 = inCatOrder + iTempInt3 - 1;
iTempInt3 = iTempInt3 + 1;
CCat4Rank oTempCat4Rank6 = new CCat4Rank();
oTempCat4Rank6.Category4ID = iTempInt;
oTempCat4Rank6.Category4Order = iTempInt2;
UpdateCat4Rank(oTempCat4Rank6, iTempCat2Order, iTempCat3Order);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), iTempInt2, iTempInt);
this.ExecuteNonQuery(sSql);
}
}
this.CommitTransection();
oResult.IsSuccess = true;
}
//this.OpenConnection();
//string sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCategory4), oCat.Category4Name, oCat.Category3ID, oCat.Category4Description, oCat.Category4TablePrice, oCat.Category4TakeAwayPrice, oCat.Category4BarPrice, oCat.Category4OrderStatus, oCat.Category4Order, oCat.Category4ViewTable, oCat.Category4ViewBar, oCat.Category4ViewTakeAway, oCat.Rank, oCat.Category4ID);
//this.ExecuteNonQuery(sSql);
//oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult AddCat4(RMS.Common.ObjectModel.CCategory4 inUser)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckCat4(inUser);
if (bTempFlag)
{
oResult.Message = "Category4 exists with this name.";
}
else
{
CResult oResult2 = GetMaxCatOrder();
if (oResult2.IsSuccess && oResult2.Data != null)
{
int iTempOrder = (int)oResult2.Data;
iTempOrder = iTempOrder + 1;
inUser.Category4Name = inUser.Category4Name.Replace("''", "'");
inUser.Category4Name = inUser.Category4Name.Replace("'", "''");
inUser.Category4Description = inUser.Category4Description.Replace("''", "'");
inUser.Category4Description = inUser.Category4Description.Replace("'", "''");
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.AddCategory4), inUser.Category4Name, inUser.Category3ID, inUser.Category4Description, inUser.Category4TablePrice, inUser.Category4TakeAwayPrice, inUser.Category4BarPrice, inUser.Category4OrderStatus, iTempOrder, inUser.Category4ViewTable, inUser.Category4ViewBar, inUser.Category4ViewTakeAway, inUser.Rank, RMSGlobal.LogInUserName, DateTime.Now.Ticks, inUser.InitialItemQuantity, inUser.UnlimitStatus, inUser.vatIncluded, inUser.vatRate);
this.ExecuteNonQuery(sqlCommand);
#region "Added By Baruri"
Int32 category4_Order = 0;
Int32 category3_Order = 0;
Int32 category2_id = 0;
Int32 category2_order = 0;
this.OpenConnection();
sqlCommand = "select cat4_order from category4 where cat4_id=(select max(cat4_id) from category4)";
IDataReader objcategory3ID = this.ExecuteReader(sqlCommand);
if (objcategory3ID != null)
{
if (objcategory3ID.Read())
{
category4_Order = Convert.ToInt32(objcategory3ID["cat4_order"]);
}
}
objcategory3ID.Close();
sqlCommand = "select cat3_order,cat2_id from category3 where cat3_id=" + inUser.Category3ID;
objcategory3ID = this.ExecuteReader(sqlCommand);
if (objcategory3ID != null)
{
if (objcategory3ID.Read())
{
category3_Order = Convert.ToInt32(objcategory3ID["cat3_order"]);
category2_id = Convert.ToInt32(objcategory3ID["cat2_id"]);
}
}
objcategory3ID.Close();
sqlCommand = "select cat2_order from category2 where cat2_id=" + category2_id;
objcategory3ID = this.ExecuteReader(sqlCommand);
if (objcategory3ID != null)
{
if (objcategory3ID.Read())
{
category2_order = Convert.ToInt32(objcategory3ID["cat2_order"]);
}
}
CResult cresultCategoryRank = CalculateCat4Rank(category2_order, category3_Order, category4_Order);
Int64 cateRank = Convert.ToInt64(cresultCategoryRank.Data);
objcategory3ID.Close();
sqlCommand = "update category4 set cat4_rank=" + cateRank + " where cat4_id=(select max(cat4_id) from category4)";
this.ExecuteNonQuery(sqlCommand);
this.CloseConnection();
#endregion
oResult.IsSuccess = 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(oResult);
}
private void dgvSelectionItem_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
try
{
if (e.ColumnIndex == 7)
{
Int32 itemID = Convert.ToInt32("0" + dgvSelectionItem.Rows[e.RowIndex].Cells[0].Value);
UpdateSelectionItemCtl objSelection = new UpdateSelectionItemCtl(itemID);
objSelection.Parent = this.ParentForm;
UserControlManager.UserControls.Push(this);
Panel pnl = (Panel)this.ParentForm.Controls["pnlContext"];
string s = pnl.Name;
objSelection.ParentForm.Controls[s].Controls.Clear();
objSelection.ParentForm.Controls[s].Controls.Add(objSelection);
}
else if (e.ColumnIndex == 8)
{
if (MessageBox.Show("Are you sure you want to delete the selected food type?", RMSGlobal.MessageBoxTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int selectItemCatId = 0;
bool bTempBool = Int32.TryParse(dgvSelectionItem.Rows[e.RowIndex].Cells[0].Value.ToString(), out selectItemCatId);
if (bTempBool)
{
CCategory4 objSelectItem = new CCategory4();
objSelectItem.Category4ID = selectItemCatId;
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.DeleteCat4(objSelectItem);
if (oResult.IsSuccess)
{
dgvSelectionItem.Rows.RemoveAt(e.RowIndex);
}
}
}
}
}
catch (Exception exp)
{
throw exp;
}
}
private void LoadExistingData()
{
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.GetCategory4(m_selectionItemCategoryID);
CCategory4 objSelectionOfItem = new CCategory4();
if (oResult.IsSuccess && oResult.Data != null)
{
objSelectionOfItem = (CCategory4)oResult.Data;
txtItemName.Text = objSelectionOfItem.Category4Name;
txtOrder.Text = objSelectionOfItem.Category4Order.ToString();
m_selectionItemOrder = objSelectionOfItem.Category4Order;
txtDescription.Text = objSelectionOfItem.Category4Description;
txtTablePrice.Text = objSelectionOfItem.Category4TablePrice.ToString("F02");
txtTakeawayPrice.Text = objSelectionOfItem.Category4TakeAwayPrice.ToString("F02");
txtBarPrice.Text = objSelectionOfItem.Category4BarPrice.ToString("F02");
txtVateRate.Text = objSelectionOfItem.vatRate.ToString();
chkVateIncluded.Checked = objSelectionOfItem.vatIncluded;
if (objSelectionOfItem.UnlimitStatus >0)
{
chkunlimited.Checked = true;
txtInitialQuantity.Clear();
}
else
{
txtInitialQuantity.Text = objSelectionOfItem.InitialItemQuantity.ToString();
}
m_iRank = objSelectionOfItem.Rank;
if (objSelectionOfItem.Category4ViewTable == 1)
{
chkTable.Checked = true;
}
if (objSelectionOfItem.Category4ViewBar == 1)
{
chkBar.Checked = true;
}
if (objSelectionOfItem.Category4ViewTakeAway == 1)
{
chkTakeAway.Checked = true;
}
}
oResult = oManager.GetCategoryAncestors(m_selectionItemCategoryID, 4);
if (oResult.IsSuccess && oResult.Data != null)
{
CCategoryAncestor oCatAnc = (CCategoryAncestor)oResult.Data;
int tmpCat4ID = oCatAnc.Category4ID;
int tmpCat3ID = oCatAnc.Category3ID;
int tmpCat2ID = oCatAnc.Category2ID;
int tmpCat1ID = oCatAnc.Category1ID;
int tmpParentCatID = oCatAnc.ParentCategoryID;
CComboBoxItem oItem1 = new CComboBoxItem(1, "Active");
CComboBoxItem oItem2 = new CComboBoxItem(0, "InActive");
if (objSelectionOfItem.Category4OrderStatus == 1)
{
rdoActive.Checked = true;
}
else if (objSelectionOfItem.Category4OrderStatus == 0)
{
rdoInactive.Checked = true;
}
cmbParent.SelectedValue = tmpParentCatID;
cmbFoodType.SelectedValue = tmpCat1ID;
cmbCategory.SelectedValue = tmpCat2ID;
cmbFoodItem.SelectedValue = tmpCat3ID;
}
}
private bool CheckCatOrder(CCategory4 inUser)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = "";// String.Format(SqlQueries.GetQuery(Query.CheckCat1Order), inUser.Category1Order, inUser.ParentCatID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
if (oReader["cat1_id"] != null)
{
int iTemp = Int32.Parse(oReader["cat1_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 CResult GetCategory4(CCategory4 inCat)
{
CResult oResult = null;
try
{
//this.OpenConnection();
//string sSql = string.Format(SqlQueries.GetQuery(Query.ItemGetById), gItemId);
//IDataReader oReader = this.ExecuteReader(sSql);
//if (oReader != null)
//{
// if (oReader.Read())
// oItem = ReaderToCategory4(oReader);
//}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return oResult;
}
private CResult GetOrderCandidate(CCategory4 oCat)
{
CResult oResult = new CResult();
try
{
List<int> iTempList = new List<int>();
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.GetCat4OrderCandidate), oCat.Category3ID, oCat.Category4Order);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
if (oReader["cat4_id"] != null)
{
int iTempInt = Int32.Parse(oReader["cat4_id"].ToString());
iTempList.Add(iTempInt);
}
}
oResult.Data = iTempList;
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 CheckCat4ForUpdate(CCategory4 inUser)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.CheckDupCat4ForUpdate), inUser.Category4Name, inUser.Category3ID, inUser.Category4ID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
if (oReader["cat4_id"] != null)
{
int iTemp = Int32.Parse(oReader["cat4_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 CCategory4 ReaderToCategory4(IDataReader oReader)
{
CCategory4 objSelectionItem = new CCategory4();
if (oReader["cat4_id"] != null)
objSelectionItem.Category4ID = Int32.Parse(oReader["cat4_id"].ToString());
if (oReader["cat4_name"] != null)
objSelectionItem.Category4Name = oReader["cat4_name"].ToString();
if (oReader["cat3_id"] != null)
objSelectionItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
if (oReader["description"] != null)
objSelectionItem.Category4Description = oReader["description"].ToString();
if (oReader["table_price"] != null)
objSelectionItem.Category4TablePrice = Double.Parse(oReader["table_price"].ToString());
if (oReader["tw_price"] != null)
objSelectionItem.Category4TakeAwayPrice = Double.Parse(oReader["tw_price"].ToString());
if (oReader["bar_price"] != null)
objSelectionItem.Category4BarPrice = Double.Parse(oReader["bar_price"].ToString());
if (oReader["status"] != null)
objSelectionItem.Category4OrderStatus = Int32.Parse(oReader["status"].ToString());
if (oReader["cat4_order"] != null)
objSelectionItem.Category4Order = Int32.Parse(oReader["cat4_order"].ToString());
if (oReader["view_table"] != null)
objSelectionItem.Category4ViewTable = Int32.Parse(oReader["view_table"].ToString());
if (oReader["view_bar"] != null)
objSelectionItem.Category4ViewBar = Int32.Parse(oReader["view_bar"].ToString());
if (oReader["view_takeaway"] != null)
objSelectionItem.Category4ViewTakeAway = Int32.Parse(oReader["view_takeaway"].ToString());
if (oReader["slection_item_stock_quantity"] != null)
objSelectionItem.InitialItemQuantity = Int32.Parse("0"+oReader["slection_item_stock_quantity"].ToString());
if (oReader["unlimited_status"] != null)
objSelectionItem.UnlimitStatus = Convert.ToInt32(oReader["unlimited_status"]);
//Vat
if (oReader["vat_Rate"] != null)
objSelectionItem.vatRate = Double.Parse(oReader["vat_Rate"].ToString());
if (oReader["vat_included"] != null)
objSelectionItem.vatIncluded = Convert.ToBoolean(oReader["vat_included"].ToString());
if (oReader["cat4_rank"] != null)
{
String sTempStr = oReader["cat4_rank"].ToString();
if (!sTempStr.Equals(String.Empty))
{
objSelectionItem.Rank = Int64.Parse(sTempStr);
}
}
return objSelectionItem;
}
private void btnDown_Click(object sender, EventArgs e)
{
try
{
if (m_iSelectedIndex >= 0 && dgvSelectionItem.Rows.Count > m_iSelectedIndex)
{
int iTempInt = Int32.Parse(dgvSelectionItem.Rows[m_iSelectedIndex].Cells[0].Value.ToString());
int iTempInt3 = Int32.Parse(dgvSelectionItem.Rows[m_iSelectedIndex].Cells[2].Value.ToString());
CCategory4 oCat = new CCategory4();
oCat.Category4ID = iTempInt;
oCat.Category4Order = iTempInt3;
if ((m_iSelectedIndex + 1) > 0 && dgvSelectionItem.Rows.Count > (m_iSelectedIndex + 1))
{
int iTempInt2 = Int32.Parse(dgvSelectionItem.Rows[(m_iSelectedIndex + 1)].Cells[0].Value.ToString());
int iTempInt4 = Int32.Parse(dgvSelectionItem.Rows[(m_iSelectedIndex + 1)].Cells[2].Value.ToString());
int iTempIndex = m_iSelectedIndex + 1;
CCategory4 oCat2 = new CCategory4();
oCat2.Category4ID = iTempInt2;
oCat2.Category4Order = iTempInt4;
if (cmbFoodItem.SelectedValue != null)
{
int iTempInt10 = Int32.Parse(cmbFoodItem.SelectedValue.ToString());
oCat.Category3ID = iTempInt10;
oCat2.Category3ID = iTempInt10;
}
CCategoryManager oCatManager = new CCategoryManager();
CResult oResult = oCatManager.UpdateCategory4Order(oCat, oCat2, false);
if (oResult.IsSuccess)
{
if (m_bGridFlag)
{
Int32 foodItemID = Convert.ToInt32(cmbFoodItem.SelectedValue);
FillSelectedItems(foodItemID);
dgvSelectionItem.Rows[0].Selected = false;
dgvSelectionItem.Rows[iTempIndex].Selected = true;
m_iSelectedIndex = iTempIndex;
if (m_iSelectedIndex > 12)
{
dgvSelectionItem.FirstDisplayedScrollingRowIndex = m_iSelectedIndex - 12;
}
}
else
{
Int32 foodItemID = Convert.ToInt32(cmbFoodItem.SelectedValue);
FillSelectedItems(foodItemID);
dgvSelectionItem.Rows[0].Selected = false;
dgvSelectionItem.Rows[iTempIndex].Selected = true;
m_iSelectedIndex = iTempIndex;
if (m_iSelectedIndex > 12)
{
dgvSelectionItem.FirstDisplayedScrollingRowIndex = m_iSelectedIndex - 12;
}
}
}
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message + "Error Occured. Please contact to your administrator.",
RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public CResult UpdateCategory4Order(CCategory4 inUser, CCategory4 inUser2, bool inUpFlag)
{
try
{
if (inUpFlag)
{
//up
m_oResult = RMS.DataAccess.Database.Instance.Category4.Cat4UpdateOrderUp(inUser, inUser2);
}
else
{
//down
m_oResult = RMS.DataAccess.Database.Instance.Category4.Cat4UpdateOrderDown(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;
}
public CResult AddCategory4(CCategory4 inUser)
{
try
{
m_oResult = RMS.DataAccess.Database.Instance.Category4.AddCat4(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;
}
private CCategory4 ReaderToCategory4(IDataReader oReader)
{
CCategory4 oItem = new CCategory4();
if (oReader["cat4_id"] != null)
oItem.Category4ID = Int32.Parse(oReader["cat4_id"].ToString());
if (oReader["cat4_name"] != null)
oItem.Category4Name = oReader["cat4_name"].ToString();
if (oReader["cat3_id"] != null)
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
if (oReader["description"] != null)
oItem.Category4Description = oReader["description"].ToString();
if (oReader["table_price"] != null)
oItem.Category4TablePrice = Double.Parse(oReader["table_price"].ToString());
if (oReader["tw_price"] != null)
oItem.Category4TakeAwayPrice = Double.Parse(oReader["tw_price"].ToString());
if (oReader["bar_price"] != null)
oItem.Category4BarPrice = Double.Parse(oReader["bar_price"].ToString());
if (oReader["status"] != null)
oItem.Category4OrderStatus = Int32.Parse(oReader["status"].ToString());
if (oReader["cat4_order"] != null)
oItem.Category4Order = Int32.Parse(oReader["cat4_order"].ToString());
if (oReader["view_table"] != null)
oItem.Category4ViewTable = Int32.Parse(oReader["view_table"].ToString());
if (oReader["view_bar"] != null)
oItem.Category4ViewBar = Int32.Parse(oReader["view_bar"].ToString());
if (oReader["view_takeaway"] != null)
oItem.Category4TakeAwayPrice = Int32.Parse(oReader["view_takeaway"].ToString());
if (oReader["cat4_rank"] != null)
oItem.Rank= Int64.Parse(oReader["cat4_rank"].ToString());
return oItem;
}
private void btnSave_Click(object sender, EventArgs e)
{
CResult oResult = ValidateForm();
if (oResult.IsSuccess)
{
CCategory4 objSelectionofItem = new CCategory4();
String tempName = txtItemName.Text;
int tempCat4Order = int.Parse(txtOrder.Text);
String tempDescription = txtDescription.Text;
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objSelectionofItem.Category4TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objSelectionofItem.Category4BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
if (!txtTakeawayPrice.Text.Trim().Equals(String.Empty))
{
objSelectionofItem.Category4TakeAwayPrice = Double.Parse(txtTakeawayPrice.Text.Trim());
}
int tempViewTable = chkTable.Checked == true ? 1 : 0;
int tempViewBar = chkBar.Checked == true ? 1 : 0;
int tempViewTW = chkTakeAway.Checked == true ? 1 : 0;
objSelectionofItem.Category4Name = tempName;
objSelectionofItem.Category4Order = tempCat4Order;
objSelectionofItem.Category4Description = tempDescription;
objSelectionofItem.Category4ViewTable = tempViewTable;
objSelectionofItem.Category4ViewBar = tempViewBar;
objSelectionofItem.Category4ViewTakeAway = tempViewTW;
objSelectionofItem.Category3ID = Int32.Parse(cmbFoodItem.SelectedValue.ToString());
objSelectionofItem.Category4ID = m_selectionItemCategoryID;
if (rdoActive.Checked)
{
objSelectionofItem.Category4OrderStatus = 1;
}
else
{
objSelectionofItem.Category4OrderStatus =0;
}
if (chkunlimited.Checked)
{
objSelectionofItem.InitialItemQuantity = 0;
objSelectionofItem.UnlimitStatus = 1;
}
else
{
objSelectionofItem.InitialItemQuantity = Convert.ToInt32("0"+txtInitialQuantity.Text);
objSelectionofItem.UnlimitStatus = 0;
}
try
{
objSelectionofItem.vatRate = Convert.ToDouble(txtVateRate.Text.ToString());
}
catch
{
objSelectionofItem.vatRate = 0.00;
}
if (chkVateIncluded.Checked)
{
objSelectionofItem.vatIncluded = true;
}
else
{
objSelectionofItem.vatIncluded = false;
}
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.UpdateCategory4(objSelectionofItem, m_selectionItemOrder);
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = "Item information is updated successfully. ";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult2.Message;
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CResult oResult = ValidateForm();
if (oResult.IsSuccess)
{
CCategory4 objSelectionOfItem = new CCategory4();
objSelectionOfItem.Category4Name = txtItemName.Text.Trim();
objSelectionOfItem.Category3ID = Int32.Parse(cmbFoodItem.SelectedValue.ToString());
objSelectionOfItem.Category4Description = txtDesc.Text.Trim();
if (rdoActive.Checked)
{
objSelectionOfItem.Category4OrderStatus=1;
}
else
{
objSelectionOfItem.Category4OrderStatus=0;
}
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objSelectionOfItem.Category4TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtTakeAwayPrice.Text.Trim().Equals(String.Empty))
{
objSelectionOfItem.Category4TakeAwayPrice = Double.Parse(txtTakeAwayPrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objSelectionOfItem.Category4BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
if (chkTable.Checked)
{
objSelectionOfItem.Category4ViewTable = 1;
}
if (chkBar.Checked)
{
objSelectionOfItem.Category4ViewBar = 1;
}
if (chkTakeAway.Checked)
{
objSelectionOfItem.Category4ViewTakeAway = 1;
}
if (chkUnlimited.Checked)
{
objSelectionOfItem.InitialItemQuantity = 0;
objSelectionOfItem.UnlimitStatus = 1;
}
else
{
objSelectionOfItem.UnlimitStatus = 0;
objSelectionOfItem.InitialItemQuantity = Convert.ToInt32("0"+txtStockQuantity.Text);
}
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.AddCategory4(objSelectionOfItem);
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = " The product has been saved successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult2.Message;
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
