public IEnumerable <Bank> GetOrganizationBanks()
{
try {
BankLibrary lib = new BankLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
return(lib.GetOrganizationBank());
}
catch (Exception ex) {
string details = string.Format("Method: {1} {0} Message: {2} {0} Stack Trace: {3}", System.Environment.NewLine, "GetOrganizationBanks", ex.Message, ex.StackTrace.ToString());
smART.Common.MessageLogger.Instance.LogMessage(ex, details, Common.Priority.High, 0, System.Diagnostics.TraceEventType.Error, "Service Error", "Service");
return(null);
}
}
public void PUTBankBalance(int id, decimal value)
{
try {
BankLibrary lib = new BankLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
Bank bank = lib.GetByID(id.ToString());
bank.Closing_Balance = value;
bank.Last_Updated_Date = DateTime.Now;
lib.UpdateBalance(b => b.ID == bank.ID, bank);
}
catch (Exception ex) {
string details = string.Format("Method: {1} {0} Message: {2} {0} Stack Trace: {3}", System.Environment.NewLine, "UpdateBankBalance", ex.Message, ex.StackTrace.ToString());
smART.Common.MessageLogger.Instance.LogMessage(ex, details, Common.Priority.High, 0, System.Diagnostics.TraceEventType.Error, "Service Error", "Service");
}
}
protected override void SaveChildEntities(string[] childEntityList, Party entity)
{
foreach (string ChildEntity in childEntityList)
{
switch (ChildEntity)
{
#region /* Case Statements - All child grids */
case "AddressBook":
if (Session[ChildEntity] != null)
{
ILibrary <AddressBook> contactLibrary = new AddressBookLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <AddressBook> resultList = (IList <AddressBook>)Session[ChildEntity];
//if (resultList.Count() == 1 || resultList.Count(o => o.Primary_Flag == true) <= 0)
// resultList.FirstOrDefault().Primary_Flag = true;
foreach (AddressBook contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Bank":
if (Session[ChildEntity] != null)
{
ILibrary <Bank> contactLibrary = new BankLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bank> resultList = (IList <Bank>)Session[ChildEntity];
foreach (Bank contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Bin":
if (Session[ChildEntity] != null)
{
ILibrary <Bin> contactLibrary = new BinLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bin> resultList = (IList <Bin>)Session[ChildEntity];
foreach (Bin contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Contact":
if (Session[ChildEntity] != null)
{
ILibrary <Contact> contactLibrary = new ContactLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Contact> resultList = (IList <Contact>)Session[ChildEntity];
foreach (Contact contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
case "Note":
if (Session[ChildEntity] != null)
{
ILibrary <Note> contactLibrary = new NoteLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Note> resultList = (IList <Note>)Session[ChildEntity];
foreach (Note contact in resultList)
{
contact.Party = new Party()
{
ID = entity.ID
};
contactLibrary.Add(contact);
}
}
break;
#endregion
}
}
}
protected override void DeleteChildEntities(string[] childEntityList, string parentID)
{
foreach (string ChildEntity in childEntityList)
{
switch (ChildEntity)
{
#region /* Case Statements - All child grids */
case "AddressBook":
if (Convert.ToInt32(parentID) > 0)
{
AddressBookLibrary library = new AddressBookLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <AddressBook> resultList = library.GetAllByParentID(Convert.ToInt32(parentID));
foreach (AddressBook entity in resultList)
{
library.Delete(entity.ID.ToString());
}
}
break;
case "Bank":
if (Convert.ToInt32(parentID) > 0)
{
BankLibrary library = new BankLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bank> resultList = library.GetAllByParentID(Convert.ToInt32(parentID));
foreach (Bank entity in resultList)
{
library.Delete(entity.ID.ToString());
}
}
break;
case "Bin":
if (Convert.ToInt32(parentID) > 0)
{
BinLibrary lib = new BinLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Bin> resultList = lib.GetAllByParentID(Convert.ToInt32(parentID));
foreach (Bin bin in resultList)
{
lib.Delete(bin.ID.ToString());
}
}
break;
case "Contact":
if (Convert.ToInt32(parentID) > 0)
{
ContactLibrary lib = new ContactLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Contact> resultList = lib.GetAllByParentID(Convert.ToInt32(parentID));
foreach (Contact contact in resultList)
{
lib.Delete(contact.ID.ToString());
}
}
break;
case "Note":
if (Convert.ToInt32(parentID) > 0)
{
NoteLibrary lib = new NoteLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <Note> resultList = lib.GetAllByParentID(Convert.ToInt32(parentID));
foreach (Note note in resultList)
{
lib.Delete(note.ID.ToString());
}
}
break;
#endregion
}
}
}
