public static string Insert(clsEDIShipMethod data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
List <clsEDIShipMethod> qShipMeth = GetEDIShipMethodTypesByidRequest(data.idRequest, data.idEDIShipMethodType);
if (qShipMeth.Count() < 1)
{
tblEDIShipMethod oNewRow = new tblEDIShipMethod()
{
idEDIShipMethodType = data.idEDIShipMethodType,
idRequest = data.idRequest,
ActiveFlag = data.ActiveFlag,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblEDIShipMethod>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idEDIShipMethod;
data.idRequest = newID;
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string InsertEDISpecialist(clsEDISpecialist data)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
tblEDISpecialist oNewRow = new tblEDISpecialist()
{
email = data.email,
idEmployee = data.idEmployee,
CreatedBy = data.CreatedBy,
CreatedOn = DateTime.Now,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login
};
o.GetTable <tblEDISpecialist>().InsertOnSubmit(oNewRow);
o.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertVendorType(ClsVendorType data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblVendorType oNewRow = new tblVendorType()
{
idVendorType = (Int32)data.idVendorType,
VendorType = data.VendorType,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblVendorType>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertServices(ClsDiscoveryRequestSvcs data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestService oNewRow = new tblDiscoveryRequestService()
{
idRequest = (Int32)data.idRequest,
idShippingSvc = (Int32)data.idShippingSvc,
volume = (Int32)data.volume,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestService>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idRequestSvc;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertITBA(ClsITBA data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblITBA oNewRow = new tblITBA()
{
ITBAemail = data.ITBAEmail,
idEmployee = data.idEmployee,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login
};
puroTouchContext.GetTable <tblITBA>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertFileUpload(ClsFileUpload data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestUpload oNewRow = new tblDiscoveryRequestUpload()
{
idRequest = (Int32)data.idRequest,
UploadDate = data.UploadDate,
Description = data.Description,
FilePath = data.FilePath,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
ActiveFlag = data.ActiveFlag
};
if (oNewRow.idRequest != 0)
{
puroTouchContext.GetTable <tblDiscoveryRequestUpload>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idFileUpload;
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertShippingProduct(ClsShippingProducts data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblShippingProduct oNewRow = new tblShippingProduct()
{
ShippingProduct = data.ShippingProduct,
idShippingSvc = data.idShippingSvc,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblShippingProduct>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertTargetDate(ClsTargetDates data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblDiscoveryRequestTargetDate oNewRow = new tblDiscoveryRequestTargetDate()
{
idRequest = (Int32)data.idRequest,
TargetDate = (DateTime)data.TargetDate,
ChangeReason = data.ChangeReason,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestTargetDate>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string UpdateEDIOnboardingPhase(ClsEDIOnboardingPhase data)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
if (data.idEDIOnboardingPhase > 0)
{
var query = from qdata in o.GetTable <tblEDIOnboardingPhase>()
where qdata.idEDIOnboardingPhase == data.idEDIOnboardingPhase
select qdata;
foreach (tblEDIOnboardingPhase updRow in query)
{
updRow.idEDIOnboardingPhase = data.idEDIOnboardingPhase;
updRow.EDIOnboardingPhaseType = data.EDIOnboardingPhaseType;
updRow.ActiveFlag = data.ActiveFlag;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = DateTime.Now;
}
o.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idEDIOnboardingPhase + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertEDI(ClsDiscoveryRequestEDI data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestEDI oNewRow = new tblDiscoveryRequestEDI()
{
idRequest = (Int32)data.idRequest,
Solution = data.Solution,
FileFormat = data.FileFormat,
CommunicationMethod = data.CommunicationMethod,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable<tblDiscoveryRequestEDI>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idDREDI;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return errMsg;
}
public string DeleteEDI(int idRequest)
{
string errMsg = "";
try
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
var deleteEDI = from details in puroTouchContext.GetTable<tblDiscoveryRequestEDI>()
where details.idRequest == idRequest
select details;
foreach (var idRequestEDI in deleteEDI)
{
puroTouchContext.GetTable<tblDiscoveryRequestEDI>().DeleteOnSubmit(idRequestEDI);
}
try
{
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return errMsg;
}
public string InsertEDISolution(ClsEDISolution data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblEDISolution oNewRow = new tblEDISolution()
{
Solution = data.Solution,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblEDISolution>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertSolutionType(ClsSolutionType data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
ClsSolutionType oNewRow = new ClsSolutionType()
{
SolutionType = data.SolutionType,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <ClsSolutionType>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static List <ClsFileType> GetFileTypes(bool bNonCourierEDI)
{
List <ClsFileType> qFileTypes = new List <ClsFileType>();
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
if (bNonCourierEDI)
{
qFileTypes = o.GetTable <tblFileType>()
.Where(p => p.ActiveFlag == true)
.Select(p => new ClsFileType()
{
idFileType = p.idFileType, FileType = p.FileType, NonCourierEDI = p.NonCourierEDI, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
}
else
{
qFileTypes = o.GetTable <tblFileType>()
.Where(p => p.ActiveFlag == true && p.NonCourierEDI == false)
.Select(p => new ClsFileType()
{
idFileType = p.idFileType, FileType = p.FileType, NonCourierEDI = p.NonCourierEDI, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
}
return(qFileTypes);
}
public static string Update(clsContact data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
var contact = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == data.idContact).FirstOrDefault();
if (contact != null)
{
contact.Name = data.Name;
contact.Title = data.Title;
contact.Phone = data.Phone;
contact.Email = data.Email;
contact.UpdatedBy = data.UpdatedBy;
contact.UpdatedOn = data.UpdatedOn;
}
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(clsContact data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblContact oNewRow = new tblContact()
{
idContactType = data.idContactType,
idRequest = data.idRequest,
Name = data.Name,
Title = data.Title,
Phone = data.Phone,
Email = data.Email,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idContact;
data.idRequest = newID;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(clsExceptionLogging data, out long newID)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblExceptionLogging oNewRow = new tblExceptionLogging()
{
ExceptionMsg = data.ExceptionMsg,
Method = data.Method,
ExceptionType = data.ExceptionType,
ExceptionSource = data.ExceptionSource,
ExceptionURL = data.ExceptionURL,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn,
};
o.GetTable <tblExceptionLogging>().InsertOnSubmit(oNewRow);
o.SubmitChanges();
newID = oNewRow.Logid;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertEquipment(ClsDiscoveryRequestEquip data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestEquipment oNewRow = new tblDiscoveryRequestEquipment()
{
idRequest = (Int32)data.idRequest,
EquipmentDesc = data.EquipmentDesc,
number = (Int32)data.number,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestEquipment>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idDREquipment;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static List <clsEDISpecialist> GetEDISpecialistView()
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <clsEDISpecialist> qEDISpecialisth = o.GetTable <vw_EDISpecialist>()
.Select(p => new clsEDISpecialist()
{
ActiveDirectoryName = p.ActiveDirectoryName, Name = p.Name, idEDISpecialist = p.idEDISpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
return(qEDISpecialisth);
}
public static List <clsCollectionSpecialist> GetCollectionSpecialist()
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <clsCollectionSpecialist> qEDISpecialisth = o.GetTable <tblCollectionSpecialist>()
.Select(p => new clsCollectionSpecialist()
{
idCollectionSpecialist = p.idCollectionSpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
return(qEDISpecialisth);
}
public static clsEDITransactionType GetOneEDITransactionType(int idEDITranscationType)
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
clsEDITransactionType qEDITransType = o.GetTable <tblEDITranscationType>()
.Select(p => new clsEDITransactionType()
{
idEDITranscationType = p.idEDITranscationType, EDITranscationType = p.EDITranscationType, Category = p.Category, CategoryID = p.CategoryID, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.Where(f => f.idEDITranscationType == idEDITranscationType)
.FirstOrDefault();
return(qEDITransType);
}
public static ClsContactType GetContactsTypeByID(int idContactType)
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
ClsContactType qContactType = o.GetTable <tblContactType>()
.Where(p => p.ActiveFlag == true && p.idContactType == idContactType)
.Select(p => new ClsContactType()
{
idContactType = p.idContactType, ContactType = p.ContactType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.FirstOrDefault();
return(qContactType);
}
public static List <clsEDITransactionType> GetEDITransactionTypes(int idEDITranscationType)
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <clsEDITransactionType> qShipMeth = o.GetTable <tblEDITranscationType>()
.Select(p => new clsEDITransactionType()
{
idEDITranscationType = p.idEDITranscationType, EDITranscationType = p.EDITranscationType, Category = p.Category, CategoryID = p.CategoryID, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.Where(f => f.idEDITranscationType == idEDITranscationType)
.ToList();
return(qShipMeth);
}
public List <clsvwDiscoveryRequest> getallRequests()
{
PuroTouchSQLDataContext puroDB = new PuroTouchSQLDataContext();
List <clsvwDiscoveryRequest> lst = new List <clsvwDiscoveryRequest>();
lst = (from d in puroDB.vw_DiscoveryRequests
select new clsvwDiscoveryRequest
{
idRequest = d.idRequest,
SalesRepName = d.SalesRepName
}).ToList();
return(lst);
}
public static clsEDISpecialist GetEDISpecialistByIDView(int idEDISpecialist)
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
clsEDISpecialist qEDISpecialisth = o.GetTable <vw_EDISpecialist>()
.Where(p => p.idEDISpecialist == idEDISpecialist)
.Select(p => new clsEDISpecialist()
{
ActiveDirectoryName = p.ActiveDirectoryName, Name = p.Name, idEDISpecialist = p.idEDISpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.FirstOrDefault();
return(qEDISpecialisth);
}
public static List <ClsEDIOnboardingPhase> GetEDIOnboardingPhase()
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <ClsEDIOnboardingPhase> qEDISpecialisth = o.GetTable <tblEDIOnboardingPhase>()
.Where(p => p.idEDIOnboardingPhase != 0)
.Select(p => new ClsEDIOnboardingPhase()
{
idEDIOnboardingPhase = p.idEDIOnboardingPhase, EDIOnboardingPhaseType = p.EDIOnboardingPhaseType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
return(qEDISpecialisth);
}
public static List <clsEDIShipMethod> GetEDIShipMethodTypesByidRequest(int idRequest)
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <clsEDIShipMethod> qShipMeth = o.GetTable <tblEDIShipMethod>()
.Where(p => p.idRequest == idRequest)
.Select(p => new clsEDIShipMethod()
{
idEDIShipMethod = p.idEDIShipMethod, idRequest = p.idRequest, MethodType = p.tblEDIShipMethodType.MethodType, idEDIShipMethodType = p.idEDIShipMethodType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
return(qShipMeth);
}
public static List <ClsCommunicationMethod> GetCommunicationMethods()
{
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
List <ClsCommunicationMethod> qCommMeth = o.GetTable <tblCommunicationMethod>()
.Where(p => p.ActiveFlag == true)
.Select(p => new ClsCommunicationMethod()
{
idCommunicationMethod = p.idCommunicationMethod, CommunicationMethod = p.CommunicationMethod, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn
})
.ToList();
return(qCommMeth);
}
public List <ClsUserRoles> GetListClsAppUsers(string appname)
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
List <ClsUserRoles> oAppUserlist = (from data in puroTouchContext.GetTable <vw_UserRole>()
where data.ApplicationName == appname
orderby data.UserName
select new ClsUserRoles
{
UserName = data.UserName,
ActiveDirectoryName = data.ActiveDirectoryName,
RoleName = data.RoleName
}).ToList();
return(oAppUserlist);
}
public ClsUserRoles GetAppUserWithPassword(string appname, string username)
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
ClsUserRoles oAppUser = (from data in puroTouchContext.GetTable <vw_UserRole>()
where data.ApplicationName == appname
where data.ActiveDirectoryName == username
orderby data.UserName
select new ClsUserRoles
{
UserName = data.UserName,
ActiveDirectoryName = data.ActiveDirectoryName,
RoleName = data.RoleName,
EncryptedPassword = data.EncryptedPassword
}).SingleOrDefault <ClsUserRoles>();
return(oAppUser);
}
