public DataTable GetAllNotices(ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_All_Notices", ref replay
);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetOrderListByUser(string UserId, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_Orders_By_UserId", ref replay,
UserId);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetTagList(string dayName, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_TagList", ref replay,
dayName);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetUserAddress(string userid, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_User_Addreess", ref replay,
userid);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetOrderByCustomer(string UserId, string CustomerId, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("admin_Get_All_Orders_By_DeleveryDate", ref replay,
UserId,
CustomerId);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetMenuDetails(string dayName, string tagName, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_MenuItems_By_Day_Tag", ref replay,
dayName,
tagName
);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetUserInfo(string email, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_User_Info", ref replay,
email,
msg_code,
msg);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}
public DataTable GetMyMessages(ChatParameters objChatParameters, ref string replay)
{
string msg_code = string.Empty;
string msg = string.Empty;
DataTable dTable = new DataTable();
try
{
objSqlProcManager = new SqlProcedureManager(connectionString);
dTable = objSqlProcManager.ExecuteDataTable("sp_Get_My_Messages", ref replay,
objChatParameters.SenderId,
objChatParameters.ReceiverId
);
}
catch (Exception errorException)
{
throw errorException;
}
return(dTable);
}