private CResult GetChildCat3(int p_inCat2ID)
{
CResult objResult = new CResult();
List <CCat3Rank> oTempList = new List <CCat3Rank>();
try
{
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetChildCat3ByCat2), p_inCat2ID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
CCat3Rank oCat2 = ReaderToCat3Rank(oReader);
oTempList.Add(oCat2);
}
oReader.Close();
objResult.Data = oTempList;
objResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
}
return(objResult);
}
private void UpdateCat3Rank(CCat3Rank inList, int inCat2Order, int inCat3Order)
{
CCat3Rank oTempCat3Rank = inList;
CResult oResult = CalculateCat3Rank(inCat2Order, inCat3Order);
if (oResult.IsSuccess && oResult.Data != null)
{
Int64 iTempRank = (Int64)oResult.Data;
String sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCat3Rank), iTempRank, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
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);
}
private CCat3Rank ReaderToCat3Rank(IDataReader oReader)
{
CCat3Rank oItem = new CCat3Rank();
if (oReader["cat3_id"] != null)
{
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
}
if (oReader["cat3_order"] != null)
{
oItem.Category3Order = Int32.Parse(oReader["cat3_order"].ToString());
}
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);
}
public RMS.Common.ObjectModel.CResult Cat3UpdateOrderUp(RMS.Common.ObjectModel.CCategory3 oCat, RMS.Common.ObjectModel.CCategory3 oCat2)
{
CResult oResult = new CResult();
try
{
int iTempCat2Order = 0;
CCat3Rank oTempList = new CCat3Rank();
CCat3Rank oTempList2 = new CCat3Rank();
CResult oResult4 = GetCategory2Order(oCat.Category2ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
iTempCat2Order = (int)oResult4.Data;
}
else
{
return(oResult);
}
CResult oResult2 = GetOrderCandidateSingle(oCat);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (CCat3Rank)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateSingle(oCat2);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (CCat3Rank)oResult3.Data;
}
int i = 0;
this.OpenConnectionWithTransection();
UpdateCat3Rank(oTempList, iTempCat2Order, oCat2.Category3Order);
List <CCat4Rank> oTempCat4List = oTempList.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat2.Category3Order);
}
UpdateCat3Rank(oTempList2, iTempCat2Order, oCat.Category3Order);
oTempCat4List = oTempList2.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat.Category3Order);
}
CCommonConstants oConstants = ConfigManager.GetConfig <CCommonConstants>();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oConstants.MaxOrderChange, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat2.Category3Order, oCat.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat.Category3Order, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
oResult.IsSuccess = true;
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult Cat3Update(RMS.Common.ObjectModel.CCategory3 objFoodItem, int inCatOrder)
{
CResult objResult = new CResult();
try
{
bool bTempFlag = CheckCat3ForUpdate(objFoodItem);
if (bTempFlag)
{
objResult.Message = "Category exists with this name.";
}
else
{
List <CCat3Rank> oTempList = new List <CCat3Rank>();
List <CCat3Rank> oTempList2 = new List <CCat3Rank>();
int iTempCat2Order = 0;
CResult oResult4 = GetCategory2Order(objFoodItem.Category2ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
iTempCat2Order = (int)oResult4.Data;
}
else
{
return(objResult);
}
CResult oResult2 = GetOrderCandidate(objFoodItem);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (List <CCat3Rank>)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateLower(objFoodItem, inCatOrder);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (List <CCat3Rank>)oResult3.Data;
}
this.OpenConnectionWithTransection();
string sqlCommand = "";
int iTempInt = 0;
int iTempInt2 = 0;
int iTempInt3 = 0;
int counter = 0;
for (counter = 0; counter < oTempList.Count; counter++)
{
CCat3Rank oTempCat3Rank = oTempList[counter];
if (oTempCat3Rank.Category3ID == objFoodItem.Category3ID)
{
iTempInt2 = objFoodItem.Category3Order;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, objFoodItem.Category3Order);
}
}
else
{
iTempInt2 = objFoodItem.Category3Order + 1 + iTempInt3;
iTempInt3 = iTempInt3 + 1;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), iTempInt2, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
objFoodItem.Category3Name = objFoodItem.Category3Name.Replace("''", "'");
objFoodItem.Category3Name = objFoodItem.Category3Name.Replace("'", "''");
objFoodItem.Category3Description = objFoodItem.Category3Description.Replace("''", "'");
objFoodItem.Category3Description = objFoodItem.Category3Description.Replace("'", "''");
sqlCommand = string.Format(SqlQueries.GetQuery(Query.UpdateCategory3), objFoodItem.Category3Name, objFoodItem.Category2ID, objFoodItem.Category3Description, objFoodItem.Category3TablePrice, objFoodItem.Category3TakeAwayPrice, objFoodItem.Category3BarPrice, objFoodItem.Category3OrderStatus, objFoodItem.Category3Order, objFoodItem.Category3ViewTable, objFoodItem.Category3ViewBar, objFoodItem.Category3ViewTakeAway, objFoodItem.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks, objFoodItem.InitialItemQuantity, objFoodItem.UnlimitStatus, objFoodItem.ItemSellingIn, objFoodItem.vatIncluded, objFoodItem.vatRate,
objFoodItem.TableCost, objFoodItem.TakeAwayCost, objFoodItem.BarCost, objFoodItem.PrintArea);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = "";
iTempInt3 = 1;
for (counter = 0; counter < oTempList2.Count; counter++)
{
CCat3Rank oTempCat3Rank = oTempList2[counter];
if (oTempCat3Rank.Category3ID == objFoodItem.Category3ID)
{
iTempInt2 = objFoodItem.Category3Order;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, objFoodItem.Category3Order);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, objFoodItem.Category3Order);
}
}
else
{
iTempInt2 = inCatOrder + iTempInt3 - 1;
iTempInt3 = iTempInt3 + 1;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), iTempInt2, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
this.CommitTransection();
objResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in Cat3Update()", LogLevel.Error, "Database");
throw new Exception("Exception occure at Cat3Update()", ex);
}
finally
{
this.CloseConnection();
}
return(objResult);
}
private CCat3Rank ReaderToCat3Rank(IDataReader oReader)
{
CCat3Rank oItem = new CCat3Rank();
if (oReader["cat3_id"] != null)
oItem.Category3ID = Int32.Parse(oReader["cat3_id"].ToString());
if (oReader["cat2_order"] != null)
oItem.Category2Order = Int32.Parse(oReader["cat2_order"].ToString());
if (oReader["cat3_order"] != null)
oItem.Category3Order = Int32.Parse(oReader["cat3_order"].ToString());
return oItem;
}
public RMS.Common.ObjectModel.CResult Cat3UpdateOrderUp(RMS.Common.ObjectModel.CCategory3 oCat, RMS.Common.ObjectModel.CCategory3 oCat2)
{
CResult oResult = new CResult();
try
{
int iTempCat2Order = 0;
CCat3Rank oTempList = new CCat3Rank();
CCat3Rank oTempList2 = new CCat3Rank();
CResult oResult4 = GetCategory2Order(oCat.Category2ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
iTempCat2Order = (int)oResult4.Data;
}
else
{
return oResult;
}
CResult oResult2 = GetOrderCandidateSingle(oCat);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (CCat3Rank)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateSingle(oCat2);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (CCat3Rank)oResult3.Data;
}
int i = 0;
this.OpenConnectionWithTransection();
UpdateCat3Rank(oTempList, iTempCat2Order, oCat2.Category3Order);
List<CCat4Rank> oTempCat4List = oTempList.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat2.Category3Order);
}
UpdateCat3Rank(oTempList2, iTempCat2Order, oCat.Category3Order);
oTempCat4List = oTempList2.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat.Category3Order);
}
CCommonConstants oConstants = ConfigManager.GetConfig<CCommonConstants>();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oConstants.MaxOrderChange, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat2.Category3Order, oCat.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat.Category3Order, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
oResult.IsSuccess = true;
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return oResult;
}
private void UpdateCat3Rank(CCat3Rank inList, int inCat2Order, int inCat3Order)
{
CCat3Rank oTempCat3Rank = inList;
CResult oResult = CalculateCat3Rank(inCat2Order, inCat3Order);
if (oResult.IsSuccess && oResult.Data != null)
{
Int64 iTempRank = (Int64)oResult.Data;
String sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCat3Rank), iTempRank, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
private CResult GetOrderCandidateSingle(CCategory3 oCat)
{
CResult oResult = new CResult();
try
{
List<int> iTempList = new List<int>();
this.OpenConnection();
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;
}
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;
}
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;
}
public CResult UpdateAllRank()
{
CResult oResult = new CResult();
try
{
this.OpenConnectionWithTransection();
string sSql = SqlQueries.GetQuery(Query.DeleteAllCat3Rank);
this.ExecuteNonQuery(sSql);
sSql = SqlQueries.GetQuery(Query.DeleteAllCat4Rank);
this.ExecuteNonQuery(sSql);
List <CCat3Rank> oTempCat3List = new List <CCat3Rank>();
List <CCat4Rank> oTempCat4List = new List <CCat4Rank>();
sSql = SqlQueries.GetQuery(Query.GetAllCat3Rank);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
CCat3Rank oCat = ReaderToCat3Rank(oReader);
oTempCat3List.Add(oCat);
}
}
oReader.Close();
sSql = SqlQueries.GetQuery(Query.GetAllCat4Rank);
oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
CCat4Rank oCat = ReaderToCat4Rank(oReader);
oTempCat4List.Add(oCat);
}
}
oReader.Close();
int i = 0;
for (i = 0; i < oTempCat3List.Count; i++)
{
CCat3Rank oTempCat3Rank = oTempCat3List[i];
CResult oResult2 = CalculateCat3Rank(oTempCat3Rank.Category2Order, oTempCat3Rank.Category3Order);
if (oResult2.IsSuccess && oResult2.Data != null)
{
Int64 iTempRank = (Int64)oResult2.Data;
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCat3Rank), iTempRank, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
for (i = 0; i < oTempCat4List.Count; i++)
{
CCat4Rank oTempCat4Rank = oTempCat4List[i];
CResult oResult3 = CalculateCat4Rank(oTempCat4Rank.Category2Order, oTempCat4Rank.Category3Order, oTempCat4Rank.Category4Order);
if (oResult3.IsSuccess && oResult3.Data != null)
{
Int64 iTempRank = (Int64)oResult3.Data;
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCat4Rank), iTempRank, oTempCat4Rank.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
this.CommitTransection();
oResult.IsSuccess = true;
}
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);
}
