private CCat4Rank ReaderToCat4Rank(IDataReader oReader)
{
CCat4Rank oItem = new CCat4Rank();
if (oReader["cat4_id"] != null)
{
oItem.Category4ID = Int32.Parse(oReader["cat4_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());
}
if (oReader["cat4_order"] != null)
{
oItem.Category4Order = Int32.Parse(oReader["cat4_order"].ToString());
}
return(oItem);
}
private CResult GetChildCat4ByCat3(int inCat2ID)
{
CResult oResult = new CResult();
List <CCat4Rank> oTempList = new List <CCat4Rank>();
try
{
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetChildCat4ByCat3), inCat2ID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
CCat4Rank oCat2 = ReaderToCat4Rank(oReader);
oTempList.Add(oCat2);
}
oReader.Close();
oResult.Data = oTempList;
oResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
}
return(oResult);
}
private void UpdateCat4Rank(CCat4Rank inList, int inCat2Order, int inCat3Order)
{
CCat4Rank oTempCat3Rank = inList;
CResult oResult = CalculateCat4Rank(inCat2Order, inCat3Order, oTempCat3Rank.Category4Order);
if (oResult.IsSuccess && oResult.Data != null)
{
Int64 iTempRank = (Int64)oResult.Data;
String sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCat4Rank), iTempRank, oTempCat3Rank.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
private CResult GetCategory2Order(int inCat2ID)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.GetCategory23Order), inCat2ID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
// int iTempInt = Int32.Parse(oReader["cat2_order"].ToString());
CCat4Rank oTempCat4Rank = ReaderToCat4Rank2(oReader);
oResult.Data = oTempCat4Rank;
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private CCat4Rank ReaderToCat4Rank(IDataReader oReader)
{
CCat4Rank oItem = new CCat4Rank();
if (oReader["cat4_id"] != null)
oItem.Category4ID = Int32.Parse(oReader["cat4_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());
if (oReader["cat4_order"] != null)
oItem.Category4Order = Int32.Parse(oReader["cat4_order"].ToString());
return oItem;
}
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);
}
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 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;
}
private void UpdateCat4Rank(CCat4Rank inList, int inCat2Order, int inCat3Order)
{
CCat4Rank oTempCat3Rank = inList;
CResult oResult = CalculateCat4Rank(inCat2Order, inCat3Order, oTempCat3Rank.Category4Order);
if (oResult.IsSuccess && oResult.Data != null)
{
Int64 iTempRank = (Int64)oResult.Data;
String sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCat4Rank), iTempRank, oTempCat3Rank.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
}
}
