internal static void Add(Rbr_Db pDb, VirtualSwitchDto pVirtualSwitch)
{
VirtualSwitchRow _virtualSwitchRow = MapToVirtualSwitchRow(pVirtualSwitch);
pDb.VirtualSwitchCollection.Insert(_virtualSwitchRow);
pVirtualSwitch.VirtualSwitchId = _virtualSwitchRow.Virtual_switch_id;
}
internal static PersonDto GetByLogin(Rbr_Db pDb, string pLogin)
{
PersonRow _personRow = pDb.PersonCollection.GetByLogin(pLogin);
if (_personRow == null)
{
return(null);
}
ContactInfoDto _contactInfo = null;
CustomerSupportGroupDto _customerSupportGroup = null;
VirtualSwitchDto _virtualSwitch = null;
if (!_personRow.IsContact_info_idNull)
{
_contactInfo = ContactInfoManager.Get(pDb, _personRow.Contact_info_id);
}
if (!_personRow.IsGroup_idNull)
{
_customerSupportGroup = CustomerSupportManager.GetCustomerSupportGroup(pDb, _personRow.Group_id);
}
if (!_personRow.IsVirtual_switch_idNull)
{
_virtualSwitch = VirtualSwitchManager.Get(pDb, _personRow.Virtual_switch_id);
}
return(mapToPerson(_personRow, _contactInfo, _customerSupportGroup, _virtualSwitch));
}
public static Result Add(VirtualSwitchDto pVirtualSwitch)
{
var _result = new Result();
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pVirtualSwitch)) {
try {
//1. REQUIRED set Contact Info
if (pVirtualSwitch.ContactInfo.ContactInfoId == 0)
{
ContactInfoManager.Add(_db, pVirtualSwitch.ContactInfo);
}
VirtualSwitchManager.Add(_db, pVirtualSwitch);
_tx.Commit();
}
catch (Exception _ex) {
if (pVirtualSwitch.ContactInfo != null)
{
pVirtualSwitch.ContactInfo.ContactInfoId = 0;
}
_result.Success = false;
_result.ErrorMessage = _ex.Message;
TimokLogger.Instance.LogRbr(LogSeverity.Error, "VirtualSwitchController.Add", string.Format("Exception:\r\n{0}", _ex));
}
}
}
return(_result);
}
internal static void Delete(Rbr_Db pDb, VirtualSwitchDto pVirtualSwitch)
{
if (pVirtualSwitch.VirtualSwitchId == AppConstants.DefaultVirtualSwitchId)
{
throw new Exception("Cannot Delete Default Virtual Switch");
}
pDb.VirtualSwitchCollection.DeleteByPrimaryKey(pVirtualSwitch.VirtualSwitchId);
}
internal static VirtualSwitchDto MapToVirtualSwitch(VirtualSwitchRow pVirtualSwitchRow, ContactInfoDto pContactInfo)
{
if (pVirtualSwitchRow == null)
{
return(null);
}
var _virtualSwitch = new VirtualSwitchDto();
_virtualSwitch.VirtualSwitchId = pVirtualSwitchRow.Virtual_switch_id;
_virtualSwitch.Name = pVirtualSwitchRow.Name;
_virtualSwitch.Status = pVirtualSwitchRow.SwitchStatus;
_virtualSwitch.ContactInfo = pContactInfo;
return(_virtualSwitch);
}
internal static VirtualSwitchRow MapToVirtualSwitchRow(VirtualSwitchDto pVirtualSwitch)
{
if (pVirtualSwitch == null)
{
return(null);
}
var _virtualSwitchRow = new VirtualSwitchRow();
_virtualSwitchRow.Virtual_switch_id = pVirtualSwitch.VirtualSwitchId;
_virtualSwitchRow.Name = pVirtualSwitch.Name;
_virtualSwitchRow.SwitchStatus = pVirtualSwitch.Status;
if (pVirtualSwitch.ContactInfo != null)
{
_virtualSwitchRow.Contact_info_id = pVirtualSwitch.ContactInfoId;
}
return(_virtualSwitchRow);
}
internal static PersonDto[] GetByVirtualSwitchId(Rbr_Db pDb, int pVirtualSwitchId)
{
var _list = new ArrayList();
VirtualSwitchDto _virtualSwitch = VirtualSwitchManager.Get(pDb, pVirtualSwitchId);
PersonRow[] _personRows = pDb.PersonCollection.GetByVirtual_switch_id(pVirtualSwitchId);
foreach (PersonRow _personRow in _personRows)
{
ContactInfoDto _contactInfo = null;
if (!_personRow.IsContact_info_idNull)
{
_contactInfo = ContactInfoManager.Get(pDb, _personRow.Contact_info_id);
}
_list.Add(mapToPerson(_personRow, _contactInfo, null, _virtualSwitch));
}
if (_list.Count > 1)
{
_list.Sort(new GenericComparer(PersonDto.Name_PropName, ListSortDirection.Ascending));
}
return((PersonDto[])_list.ToArray(typeof(PersonDto)));
}
public static Result Delete(VirtualSwitchDto pVirtualSwitch)
{
var _result = new Result();
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pVirtualSwitch)) {
try {
if (pVirtualSwitch.VirtualSwitchId == AppConstants.DefaultVirtualSwitchId)
{
throw new Exception("Cannot delete Default Virtual Switch");
}
VirtualSwitchManager.Delete(_db, pVirtualSwitch);
_tx.Commit();
}
catch (Exception _ex) {
_result.Success = false;
_result.ErrorMessage = _ex.Message;
TimokLogger.Instance.LogRbr(LogSeverity.Error, "VirtualSwitchController.Delete", string.Format("Exception:\r\n{0}", _ex));
}
}
}
return(_result);
}
static PersonDto mapToPerson(PersonRow pPersonRow, ContactInfoDto pContactInfo, CustomerSupportGroupDto pCustomerSupportGroup, VirtualSwitchDto pVirtualSwitch)
{
if (pPersonRow == null)
{
return(null);
}
var _person = new PersonDto();
_person.PersonId = pPersonRow.Person_id;
_person.Name = pPersonRow.Name;
_person.Login = pPersonRow.Login;
_person.Password = pPersonRow.Password;
_person.AccessScope = pPersonRow.AccessScope;
_person.PermissionType = pPersonRow.PermissionType;
_person.RegistrationStatus = pPersonRow.RegistrationStatus;
_person.Status = pPersonRow.PersonStatus;
_person.Salt = pPersonRow.Salt;
if (!pPersonRow.IsPartner_idNull)
{
_person.PartnerId = pPersonRow.Partner_id;
}
if (!pPersonRow.IsRetail_acct_idNull)
{
_person.RetailAcctId = pPersonRow.Retail_acct_id;
}
if (pCustomerSupportGroup != null)
{
_person.CustomerSupportGroup = pCustomerSupportGroup;
}
if (pVirtualSwitch != null)
{
_person.VirtualSwitch = pVirtualSwitch;
}
if (pContactInfo != null)
{
_person.ContactInfo = pContactInfo;
}
return(_person);
}
internal static void Update(Rbr_Db pDb, VirtualSwitchDto pVirtualSwitch)
{
VirtualSwitchRow _virtualSwitchRow = MapToVirtualSwitchRow(pVirtualSwitch);
pDb.VirtualSwitchCollection.Update(_virtualSwitchRow);
}
