public void DeleteMerchant(int id)
{
MerchantTable merchant = merchantEntities.MerchantTables.Where(e => e.ID == id).FirstOrDefault();
if (merchant != null)
{
merchantEntities.MerchantTables.Remove(merchant);
}
merchantEntities.SaveChanges();
}
public MerchantTable updateMerchantStoreIdAndDesignation(int merchant_id, int store_id, String designation)
{
MerchantTable merchant = merchantEntities.MerchantTables.Where(e => e.ID == merchant_id).FirstOrDefault();
if (merchant != null)
{
merchant.StoreID = store_id;
merchant.Designation = designation;
}
merchantEntities.SaveChanges();
return(merchant);
}
public MerchantTable addNewMerchant(MerchantTable merchant)
{
if (merchant != null)
{
merchantEntities.MerchantTables.Add(merchant);
merchantEntities.SaveChanges();
return(merchant);
}
else
{
return(null);
}
}
public Boolean isExist(String contact_numb)
{
MerchantTable merchant = merchantEntities.MerchantTables.Where(e => e.ContactNo == contact_numb).FirstOrDefault();
if (merchant != null)
{
return(true);
}
else
{
return(false);
}
}
public MerchantTable login(String contactNo, String password)
{
MerchantTable merchant = merchantEntities.MerchantTables.Where(e => e.ContactNo == contactNo && e.Password == password).FirstOrDefault();
if (merchant != null)
{
return(merchant);
}
else
{
return(null);
}
}
public MerchantTable GetMerchent(int id)
{
MerchantTable merchant = merchantEntities.MerchantTables.FirstOrDefault(e => e.ID == id);
if (merchant != null)
{
return(merchant);
}
else
{
return(null);
}
}
// Use this for initialization
public ServerMerchantTables()
{
functionName = "Merchant Tables";
// Database tables name
tableName = "merchant_tables";
functionTitle = "Merchant Table Configuration";
loadButtonLabel = "Load Merchant Tables";
notLoadedText = "No Tables loaded.";
// Init
dataRegister = new Dictionary<int, MerchantTable> ();
editingDisplay = new MerchantTable ();
originalDisplay = new MerchantTable ();
}
public MerchantTable updateMerchant(int id, MerchantTable merchant)
{
MerchantTable entity = merchantEntities.MerchantTables.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
entity.Fname = merchant.Fname;
entity.Lname = merchant.Lname;
entity.Password = merchant.Password;
entity.ContactNo = merchant.ContactNo;
entity.Address = merchant.Address;
}
merchantEntities.SaveChanges();
return(entity);
}
// Edit or Create
public override void DrawEditor(Rect box, bool newItem)
{
// Setup the layout
Rect pos = box;
pos.x += ImagePack.innerMargin;
pos.y += ImagePack.innerMargin;
pos.width -= ImagePack.innerMargin;
pos.height = ImagePack.fieldHeight;
if (!linkedTablesLoaded) {
LoadItemList();
linkedTablesLoaded = true;
}
// Draw the content database info
//pos.y += ImagePack.fieldHeight;
if (newItem) {
ImagePack.DrawLabel (pos.x, pos.y, "Create a new Merchant Table");
pos.y += ImagePack.fieldHeight;
}
editingDisplay.name = ImagePack.DrawField (pos, "Name:", editingDisplay.name, 0.75f);
pos.width /= 2;
pos.y += 1.5f * ImagePack.fieldHeight;
ImagePack.DrawLabel (pos.x, pos.y, "Table Items");
pos.y += 1.5f * ImagePack.fieldHeight;
if (editingDisplay.tableItems.Count == 0) {
editingDisplay.tableItems.Add (new MerchantTableItemEntry (-1, -1));
}
for (int i = 0; i < editingDisplay.tableItems.Count; i++) {
editingDisplay.tableItems [i].count = ImagePack.DrawField (pos, "Count:", editingDisplay.tableItems [i].count);
pos.x += pos.width;
int selectedItem = GetPositionOfItem (editingDisplay.tableItems [i].itemID);
selectedItem = ImagePack.DrawSelector (pos, "Item " + (i + 1) + ":", selectedItem, itemsList);
editingDisplay.tableItems [i].itemID = itemIds [selectedItem];
pos.x -= pos.width;
pos.y += ImagePack.fieldHeight;
editingDisplay.tableItems [i].refreshTime = ImagePack.DrawField (pos, "Refresh Time:", editingDisplay.tableItems [i].refreshTime);
pos.x += pos.width;
if (ImagePack.DrawButton (pos.x, pos.y, "Remove Item")) {
if (editingDisplay.tableItems[i].id > 0)
editingDisplay.itemsToBeDeleted.Add(editingDisplay.tableItems[i].id);
editingDisplay.tableItems.RemoveAt(i);
}
pos.x -= pos.width;
pos.y += ImagePack.fieldHeight;
}
if (ImagePack.DrawButton (pos.x, pos.y, "Add Item")) {
editingDisplay.tableItems.Add (new MerchantTableItemEntry (-1, -1));
}
pos.width *= 2;
pos.y += 1.4f * ImagePack.fieldHeight;
// Save data
pos.x -= ImagePack.innerMargin;
pos.width /= 3;
if (ImagePack.DrawButton (pos.x, pos.y, "Save Data")) {
if (newItem)
InsertEntry ();
else
UpdateEntry ();
state = State.Loaded;
}
// Delete data
if (!newItem) {
pos.x += pos.width;
if (ImagePack.DrawButton (pos.x, pos.y, "Delete Data")) {
DeleteEntry ();
newSelectedDisplay = 0;
state = State.Loaded;
}
}
// Cancel editing
pos.x += pos.width;
if (ImagePack.DrawButton (pos.x, pos.y, "Cancel")) {
editingDisplay = originalDisplay.Clone ();
if (newItem)
state = State.New;
else
state = State.Loaded;
}
if (resultTimeout != -1 && resultTimeout > Time.realtimeSinceStartup) {
pos.y += ImagePack.fieldHeight;
ImagePack.DrawText (pos, result);
}
if (!newItem)
EnableScrollBar (pos.y - box.y + ImagePack.fieldHeight + 28);
else
EnableScrollBar (pos.y - box.y + ImagePack.fieldHeight);
}
public override void CreateNewData()
{
editingDisplay = new MerchantTable ();
originalDisplay = new MerchantTable ();
selectedDisplay = -1;
}
void LoadMerchantTableItems(MerchantTable merchantTable)
{
// Read all entries from the table
string query = "SELECT * FROM " + "merchant_item" + " where tableID = " + merchantTable.id;
// If there is a row, clear it.
if (rows != null)
rows.Clear ();
// Load data
rows = DatabasePack.LoadData (DatabasePack.contentDatabasePrefix, query);
//Debug.Log("#Rows:"+rows.Count);
// Read all the data
if ((rows != null) && (rows.Count > 0)) {
foreach (Dictionary<string,string> data in rows) {
MerchantTableItemEntry entry = new MerchantTableItemEntry ();
entry.id = int.Parse (data ["id"]);
entry.count = int.Parse (data ["count"]);
entry.itemID = int.Parse (data ["itemID"]);
entry.refreshTime = int.Parse (data ["refreshTime"]);
merchantTable.tableItems.Add (entry);
}
}
}
// Load Database Data
public override void Load()
{
if (!dataLoaded) {
// Clean old data
dataRegister.Clear ();
displayKeys.Clear ();
// Read all entries from the table
string query = "SELECT * FROM " + tableName;
// If there is a row, clear it.
if (rows != null)
rows.Clear ();
// Load data
rows = DatabasePack.LoadData (DatabasePack.contentDatabasePrefix, query);
//Debug.Log("#Rows:"+rows.Count);
// Read all the data
if ((rows != null) && (rows.Count > 0)) {
foreach (Dictionary<string,string> data in rows) {
//foreach(string key in data.Keys)
// Debug.Log("Name[" + key + "]:" + data[key]);
//return;
MerchantTable display = new MerchantTable ();
display.id = int.Parse (data ["id"]);
display.name = data ["name"];
display.isLoaded = true;
//Debug.Log("Name:" + display.name + "=[" + display.id + "]");
dataRegister.Add (display.id, display);
displayKeys.Add (display.id);
}
LoadSelectList ();
}
dataLoaded = true;
foreach (MerchantTable merchantTable in dataRegister.Values) {
LoadMerchantTableItems (merchantTable);
}
}
}
// Draw the loaded list
public override void DrawLoaded(Rect box)
{
// Setup the layout
Rect pos = box;
pos.x += ImagePack.innerMargin;
pos.y += ImagePack.innerMargin;
pos.width -= ImagePack.innerMargin;
pos.height = ImagePack.fieldHeight;
if (dataRegister.Count <= 0) {
pos.y += ImagePack.fieldHeight;
ImagePack.DrawLabel (pos.x, pos.y, "You must create a Merchant Table before edit it.");
return;
}
// Draw the content database info
ImagePack.DrawLabel (pos.x, pos.y, "Merchant Table Configuration");
if (newItemCreated) {
newItemCreated = false;
LoadSelectList ();
newSelectedDisplay = displayKeys.Count - 1;
}
// Draw data Editor
if (newSelectedDisplay != selectedDisplay) {
selectedDisplay = newSelectedDisplay;
int displayKey = displayKeys [selectedDisplay];
editingDisplay = dataRegister [displayKey];
originalDisplay = editingDisplay.Clone ();
}
//if (!displayList.showList) {
pos.y += ImagePack.fieldHeight;
pos.x -= ImagePack.innerMargin;
pos.y -= ImagePack.innerMargin;
pos.width += ImagePack.innerMargin;
DrawEditor (pos, false);
pos.y -= ImagePack.fieldHeight;
//pos.x += ImagePack.innerMargin;
pos.y += ImagePack.innerMargin;
pos.width -= ImagePack.innerMargin;
//}
if (state != State.Loaded) {
// Draw combobox
pos.width /= 2;
pos.x += pos.width;
newSelectedDisplay = ImagePack.DrawCombobox (pos, "", selectedDisplay, displayList);
pos.x -= pos.width;
pos.width *= 2;
}
}
public List <Message> LoadMany(ISqlConnectionInfo connection, SqlQueryParameters parameters)
{
IDatabase database = connection.Database;
if (database == null)
{
throw new ArgumentNullException("database", "Error initializing database connection.");
}
if (parameters == null)
{
throw new ArgumentNullException("parameters");
}
string sqlCmdText = string.Empty;
try
{
sqlCmdText = "SELECT {0} " +
MessageTable.GetColumnNames("[m]") +
(this.Depth > 0 ? "," + ServiceTable.GetColumnNames("[m_s]") : string.Empty) +
(this.Depth > 1 ? "," + ApplicationTable.GetColumnNames("[m_s_a]") : string.Empty) +
(this.Depth > 1 ? "," + ProductTable.GetColumnNames("[m_s_p]") : string.Empty) +
(this.Depth > 1 ? "," + MerchantTable.GetColumnNames("[m_s_m]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceTypeTable.GetColumnNames("[m_s_st]") : string.Empty) +
(this.Depth > 1 ? "," + UserSessionTypeTable.GetColumnNames("[m_s_ust]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_s_c]") : string.Empty) +
(this.Depth > 1 ? "," + LanguageTable.GetColumnNames("[m_s_l]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceConfigurationTable.GetColumnNames("[m_s_sc]") : string.Empty) +
(this.Depth > 1 ? "," + TemplateTable.GetColumnNames("[m_s_t]") : string.Empty) +
(this.Depth > 0 ? "," + CustomerTable.GetColumnNames("[m_c]") : string.Empty) +
(this.Depth > 1 ? "," + UserTable.GetColumnNames("[m_c_u]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceTable.GetColumnNames("[m_c_s]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_c_c]") : string.Empty) +
(this.Depth > 1 ? "," + LanguageTable.GetColumnNames("[m_c_l]") : string.Empty) +
(this.Depth > 1 ? "," + MobileOperatorTable.GetColumnNames("[m_c_mo]") : string.Empty) +
(this.Depth > 0 ? "," + MobileOperatorTable.GetColumnNames("[m_mo]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_mo_c]") : string.Empty) +
" FROM [stats].[Message] AS [m] ";
if (this.Depth > 0)
{
sqlCmdText += "INNER JOIN [core].[Service] AS [m_s] ON [m].[ServiceID] = [m_s].[ServiceID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Application] AS [m_s_a] ON [m_s].[ApplicationID] = [m_s_a].[ApplicationID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Product] AS [m_s_p] ON [m_s].[ProductID] = [m_s_p].[ProductID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Merchant] AS [m_s_m] ON [m_s].[MerchantID] = [m_s_m].[MerchantID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[ServiceType] AS [m_s_st] ON [m_s].[ServiceTypeID] = [m_s_st].[ServiceTypeID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[UserSessionType] AS [m_s_ust] ON [m_s].[UserSessionTypeID] = [m_s_ust].[UserSessionTypeID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Country] AS [m_s_c] ON [m_s].[FallbackCountryID] = [m_s_c].[CountryID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Language] AS [m_s_l] ON [m_s].[FallbackLanguageID] = [m_s_l].[LanguageID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[ServiceConfiguration] AS [m_s_sc] ON [m_s].[ServiceConfigurationID] = [m_s_sc].[ServiceConfigurationID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Template] AS [m_s_t] ON [m_s].[TemplateID] = [m_s_t].[TemplateID] ";
}
if (this.Depth > 0)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Customer] AS [m_c] ON [m].[CustomerID] = [m_c].[CustomerID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[User] AS [m_c_u] ON [m_c].[UserID] = [m_c_u].[UserID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Service] AS [m_c_s] ON [m_c].[ServiceID] = [m_c_s].[ServiceID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Country] AS [m_c_c] ON [m_c].[CountryID] = [m_c_c].[CountryID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Language] AS [m_c_l] ON [m_c].[LanguageID] = [m_c_l].[LanguageID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[MobileOperator] AS [m_c_mo] ON [m_c].[MobileOperatorID] = [m_c_mo].[MobileOperatorID] ";
}
if (this.Depth > 0)
{
sqlCmdText += "LEFT OUTER JOIN [core].[MobileOperator] AS [m_mo] ON [m].[MobileOperatorID] = [m_mo].[MobileOperatorID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Country] AS [m_mo_c] ON [m_mo].[CountryID] = [m_mo_c].[CountryID] ";
}
sqlCmdText = parameters.BuildQuery(sqlCmdText);
SqlCommand sqlCmd = database.Add(sqlCmdText) as SqlCommand;
foreach (KeyValuePair <string, object> argument in parameters.Arguments)
{
sqlCmd.Parameters.AddWithValue("@" + argument.Key, argument.Value);
}
SqlDataReader sqlReader = database.Add(sqlCmd) as SqlDataReader;
if (!sqlReader.HasRows || !sqlReader.Read())
{
IMessageBuilder builder = new DbLogMessageBuilder(new LogErrorCode("m", "customloadmany", "notfound"), "Message list could not be loaded using custom logic as no items were found.", sqlCmdText, this, connection, parameters);
if (this.Logger.IsDebugEnabled)
{
this.Logger.Debug(builder.ToString());
}
sqlReader.Close();
return(new List <Message>());
}
SqlQuery query = new SqlQuery(sqlReader);
MessageTable mTable = new MessageTable(query);
ServiceTable m_sTable = (this.Depth > 0) ? new ServiceTable(query) : null;
ApplicationTable m_s_aTable = (this.Depth > 1) ? new ApplicationTable(query) : null;
ProductTable m_s_pTable = (this.Depth > 1) ? new ProductTable(query) : null;
MerchantTable m_s_mTable = (this.Depth > 1) ? new MerchantTable(query) : null;
ServiceTypeTable m_s_stTable = (this.Depth > 1) ? new ServiceTypeTable(query) : null;
UserSessionTypeTable m_s_ustTable = (this.Depth > 1) ? new UserSessionTypeTable(query) : null;
CountryTable m_s_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
LanguageTable m_s_lTable = (this.Depth > 1) ? new LanguageTable(query) : null;
ServiceConfigurationTable m_s_scTable = (this.Depth > 1) ? new ServiceConfigurationTable(query) : null;
TemplateTable m_s_tTable = (this.Depth > 1) ? new TemplateTable(query) : null;
CustomerTable m_cTable = (this.Depth > 0) ? new CustomerTable(query) : null;
UserTable m_c_uTable = (this.Depth > 1) ? new UserTable(query) : null;
ServiceTable m_c_sTable = (this.Depth > 1) ? new ServiceTable(query) : null;
CountryTable m_c_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
LanguageTable m_c_lTable = (this.Depth > 1) ? new LanguageTable(query) : null;
MobileOperatorTable m_c_moTable = (this.Depth > 1) ? new MobileOperatorTable(query) : null;
MobileOperatorTable m_moTable = (this.Depth > 0) ? new MobileOperatorTable(query) : null;
CountryTable m_mo_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
List <Message> result = new List <Message>();
do
{
Application m_s_aObject = (this.Depth > 1) ? m_s_aTable.CreateInstance() : null;
Product m_s_pObject = (this.Depth > 1) ? m_s_pTable.CreateInstance() : null;
Merchant m_s_mObject = (this.Depth > 1) ? m_s_mTable.CreateInstance() : null;
ServiceType m_s_stObject = (this.Depth > 1) ? m_s_stTable.CreateInstance() : null;
UserSessionType m_s_ustObject = (this.Depth > 1) ? m_s_ustTable.CreateInstance() : null;
Country m_s_cObject = (this.Depth > 1) ? m_s_cTable.CreateInstance() : null;
Language m_s_lObject = (this.Depth > 1) ? m_s_lTable.CreateInstance() : null;
ServiceConfiguration m_s_scObject = (this.Depth > 1) ? m_s_scTable.CreateInstance() : null;
Template m_s_tObject = (this.Depth > 1) ? m_s_tTable.CreateInstance() : null;
Service m_sObject = (this.Depth > 0) ? m_sTable.CreateInstance(m_s_aObject, m_s_pObject, m_s_mObject, m_s_stObject, m_s_ustObject, m_s_cObject, m_s_lObject, m_s_scObject, m_s_tObject) : null;
User m_c_uObject = (this.Depth > 1) ? m_c_uTable.CreateInstance() : null;
Service m_c_sObject = (this.Depth > 1) ? m_c_sTable.CreateInstance() : null;
Country m_c_cObject = (this.Depth > 1) ? m_c_cTable.CreateInstance() : null;
Language m_c_lObject = (this.Depth > 1) ? m_c_lTable.CreateInstance() : null;
MobileOperator m_c_moObject = (this.Depth > 1) ? m_c_moTable.CreateInstance() : null;
Customer m_cObject = (this.Depth > 0) ? m_cTable.CreateInstance(m_c_uObject, m_c_sObject, m_c_cObject, m_c_lObject, m_c_moObject) : null;
Country m_mo_cObject = (this.Depth > 1) ? m_mo_cTable.CreateInstance() : null;
MobileOperator m_moObject = (this.Depth > 0) ? m_moTable.CreateInstance(m_mo_cObject) : null;
Message mObject = (this.Depth > -1) ? mTable.CreateInstance(m_sObject, m_cObject, m_moObject) : null;
result.Add(mObject);
} while (sqlReader.Read());
sqlReader.Close();
return(result);
}
catch (Exception ex)
{
database.HandleException(ex);
IMessageBuilder builder = new DbLogMessageBuilder(new LogErrorCode("m", "customloadmany", "exception"), "Message list could not be loaded using custom logic. See exception for details.", sqlCmdText, ex, this, connection, parameters);
if (this.Logger.IsErrorEnabled)
{
this.Logger.Error(builder.ToString(), ex);
}
throw new DataOperationException(DataOperation.Load, "Message", "Exception while loading (custom/many) Message object from database. See inner exception for details.", ex);
}
}
protected override Message LoadInternal(ISqlConnectionInfo connection, int id)
{
IDatabase database = connection.Database;
if (database == null)
{
throw new ArgumentNullException("database", "Error initializing database connection.");
}
string sqlCmdText = string.Empty;
try
{
sqlCmdText = "SELECT " +
MessageTable.GetColumnNames("[m]") +
(this.Depth > 0 ? "," + ServiceTable.GetColumnNames("[m_s]") : string.Empty) +
(this.Depth > 1 ? "," + ApplicationTable.GetColumnNames("[m_s_a]") : string.Empty) +
(this.Depth > 1 ? "," + ProductTable.GetColumnNames("[m_s_p]") : string.Empty) +
(this.Depth > 1 ? "," + MerchantTable.GetColumnNames("[m_s_m]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceTypeTable.GetColumnNames("[m_s_st]") : string.Empty) +
(this.Depth > 1 ? "," + UserSessionTypeTable.GetColumnNames("[m_s_ust]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_s_c]") : string.Empty) +
(this.Depth > 1 ? "," + LanguageTable.GetColumnNames("[m_s_l]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceConfigurationTable.GetColumnNames("[m_s_sc]") : string.Empty) +
(this.Depth > 1 ? "," + TemplateTable.GetColumnNames("[m_s_t]") : string.Empty) +
(this.Depth > 0 ? "," + CustomerTable.GetColumnNames("[m_c]") : string.Empty) +
(this.Depth > 1 ? "," + UserTable.GetColumnNames("[m_c_u]") : string.Empty) +
(this.Depth > 1 ? "," + ServiceTable.GetColumnNames("[m_c_s]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_c_c]") : string.Empty) +
(this.Depth > 1 ? "," + LanguageTable.GetColumnNames("[m_c_l]") : string.Empty) +
(this.Depth > 1 ? "," + MobileOperatorTable.GetColumnNames("[m_c_mo]") : string.Empty) +
(this.Depth > 0 ? "," + MobileOperatorTable.GetColumnNames("[m_mo]") : string.Empty) +
(this.Depth > 1 ? "," + CountryTable.GetColumnNames("[m_mo_c]") : string.Empty) +
" FROM [stats].[Message] AS [m] ";
if (this.Depth > 0)
{
sqlCmdText += "INNER JOIN [core].[Service] AS [m_s] ON [m].[ServiceID] = [m_s].[ServiceID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Application] AS [m_s_a] ON [m_s].[ApplicationID] = [m_s_a].[ApplicationID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Product] AS [m_s_p] ON [m_s].[ProductID] = [m_s_p].[ProductID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Merchant] AS [m_s_m] ON [m_s].[MerchantID] = [m_s_m].[MerchantID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[ServiceType] AS [m_s_st] ON [m_s].[ServiceTypeID] = [m_s_st].[ServiceTypeID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[UserSessionType] AS [m_s_ust] ON [m_s].[UserSessionTypeID] = [m_s_ust].[UserSessionTypeID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Country] AS [m_s_c] ON [m_s].[FallbackCountryID] = [m_s_c].[CountryID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Language] AS [m_s_l] ON [m_s].[FallbackLanguageID] = [m_s_l].[LanguageID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[ServiceConfiguration] AS [m_s_sc] ON [m_s].[ServiceConfigurationID] = [m_s_sc].[ServiceConfigurationID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "INNER JOIN [core].[Template] AS [m_s_t] ON [m_s].[TemplateID] = [m_s_t].[TemplateID] ";
}
if (this.Depth > 0)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Customer] AS [m_c] ON [m].[CustomerID] = [m_c].[CustomerID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[User] AS [m_c_u] ON [m_c].[UserID] = [m_c_u].[UserID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Service] AS [m_c_s] ON [m_c].[ServiceID] = [m_c_s].[ServiceID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Country] AS [m_c_c] ON [m_c].[CountryID] = [m_c_c].[CountryID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Language] AS [m_c_l] ON [m_c].[LanguageID] = [m_c_l].[LanguageID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[MobileOperator] AS [m_c_mo] ON [m_c].[MobileOperatorID] = [m_c_mo].[MobileOperatorID] ";
}
if (this.Depth > 0)
{
sqlCmdText += "LEFT OUTER JOIN [core].[MobileOperator] AS [m_mo] ON [m].[MobileOperatorID] = [m_mo].[MobileOperatorID] ";
}
if (this.Depth > 1)
{
sqlCmdText += "LEFT OUTER JOIN [core].[Country] AS [m_mo_c] ON [m_mo].[CountryID] = [m_mo_c].[CountryID] ";
}
sqlCmdText += "WHERE [m].[MessageID] = @MessageID;";
SqlCommand sqlCmd = database.Add(sqlCmdText) as SqlCommand;
sqlCmd.Parameters.AddWithValue("@MessageID", id);
SqlDataReader sqlReader = database.Add(sqlCmd) as SqlDataReader;
if (!sqlReader.HasRows || !sqlReader.Read())
{
IMessageBuilder builder = new DbLogMessageBuilder(new LogErrorCode("m", "loadinternal", "notfound"), "Message could not be loaded by id as it was not found.", sqlCmdText, this, connection, id);
if (this.Logger.IsWarnEnabled)
{
this.Logger.Warn(builder.ToString());
}
sqlReader.Close();
return(null);
}
SqlQuery query = new SqlQuery(sqlReader);
MessageTable mTable = new MessageTable(query);
ServiceTable m_sTable = (this.Depth > 0) ? new ServiceTable(query) : null;
ApplicationTable m_s_aTable = (this.Depth > 1) ? new ApplicationTable(query) : null;
ProductTable m_s_pTable = (this.Depth > 1) ? new ProductTable(query) : null;
MerchantTable m_s_mTable = (this.Depth > 1) ? new MerchantTable(query) : null;
ServiceTypeTable m_s_stTable = (this.Depth > 1) ? new ServiceTypeTable(query) : null;
UserSessionTypeTable m_s_ustTable = (this.Depth > 1) ? new UserSessionTypeTable(query) : null;
CountryTable m_s_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
LanguageTable m_s_lTable = (this.Depth > 1) ? new LanguageTable(query) : null;
ServiceConfigurationTable m_s_scTable = (this.Depth > 1) ? new ServiceConfigurationTable(query) : null;
TemplateTable m_s_tTable = (this.Depth > 1) ? new TemplateTable(query) : null;
CustomerTable m_cTable = (this.Depth > 0) ? new CustomerTable(query) : null;
UserTable m_c_uTable = (this.Depth > 1) ? new UserTable(query) : null;
ServiceTable m_c_sTable = (this.Depth > 1) ? new ServiceTable(query) : null;
CountryTable m_c_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
LanguageTable m_c_lTable = (this.Depth > 1) ? new LanguageTable(query) : null;
MobileOperatorTable m_c_moTable = (this.Depth > 1) ? new MobileOperatorTable(query) : null;
MobileOperatorTable m_moTable = (this.Depth > 0) ? new MobileOperatorTable(query) : null;
CountryTable m_mo_cTable = (this.Depth > 1) ? new CountryTable(query) : null;
Application m_s_aObject = (this.Depth > 1) ? m_s_aTable.CreateInstance() : null;
Product m_s_pObject = (this.Depth > 1) ? m_s_pTable.CreateInstance() : null;
Merchant m_s_mObject = (this.Depth > 1) ? m_s_mTable.CreateInstance() : null;
ServiceType m_s_stObject = (this.Depth > 1) ? m_s_stTable.CreateInstance() : null;
UserSessionType m_s_ustObject = (this.Depth > 1) ? m_s_ustTable.CreateInstance() : null;
Country m_s_cObject = (this.Depth > 1) ? m_s_cTable.CreateInstance() : null;
Language m_s_lObject = (this.Depth > 1) ? m_s_lTable.CreateInstance() : null;
ServiceConfiguration m_s_scObject = (this.Depth > 1) ? m_s_scTable.CreateInstance() : null;
Template m_s_tObject = (this.Depth > 1) ? m_s_tTable.CreateInstance() : null;
Service m_sObject = (this.Depth > 0) ? m_sTable.CreateInstance(m_s_aObject, m_s_pObject, m_s_mObject, m_s_stObject, m_s_ustObject, m_s_cObject, m_s_lObject, m_s_scObject, m_s_tObject) : null;
User m_c_uObject = (this.Depth > 1) ? m_c_uTable.CreateInstance() : null;
Service m_c_sObject = (this.Depth > 1) ? m_c_sTable.CreateInstance() : null;
Country m_c_cObject = (this.Depth > 1) ? m_c_cTable.CreateInstance() : null;
Language m_c_lObject = (this.Depth > 1) ? m_c_lTable.CreateInstance() : null;
MobileOperator m_c_moObject = (this.Depth > 1) ? m_c_moTable.CreateInstance() : null;
Customer m_cObject = (this.Depth > 0) ? m_cTable.CreateInstance(m_c_uObject, m_c_sObject, m_c_cObject, m_c_lObject, m_c_moObject) : null;
Country m_mo_cObject = (this.Depth > 1) ? m_mo_cTable.CreateInstance() : null;
MobileOperator m_moObject = (this.Depth > 0) ? m_moTable.CreateInstance(m_mo_cObject) : null;
Message mObject = mTable.CreateInstance(m_sObject, m_cObject, m_moObject);
sqlReader.Close();
return(mObject);
}
catch (Exception ex)
{
database.HandleException(ex);
IMessageBuilder builder = new DbLogMessageBuilder(new LogErrorCode("m", "loadinternal", "exception"), "Message could not be loaded by id. See exception for details.", sqlCmdText, ex, this, connection, id);
if (this.Logger.IsErrorEnabled)
{
this.Logger.Error(builder.ToString(), ex);
}
throw new DataOperationException(DataOperation.Load, "Message", "Exception while loading Message object from database. See inner exception for details.", ex);
}
}
