/// <summary>
/// GetForBoris
/// Calls [usp_select_Login_for_Boris]
/// </summary>
public static Login GetForBoris(System.Int32?clientId)
{
Rebound.GlobalTrader.DAL.LoginDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Login.GetForBoris(clientId);
if (objDetails == null)
{
return(null);
}
else
{
Login obj = new Login();
obj.LoginId = objDetails.LoginId;
obj.ClientNo = objDetails.ClientNo;
obj.ClientName = objDetails.ClientName;
obj.EmployeeName = objDetails.EmployeeName;
obj.FirstName = objDetails.FirstName;
obj.LastName = objDetails.LastName;
obj.EMail = objDetails.EMail;
obj.ClientCurrencyNo = objDetails.ClientCurrencyNo;
obj.ClientCurrencyCode = objDetails.ClientCurrencyCode;
obj.DivisionNo = objDetails.DivisionNo;
obj.DivisionName = objDetails.DivisionName;
obj.TeamNo = objDetails.TeamNo;
obj.TeamName = objDetails.TeamName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new LoginDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual LoginDetails GetLoginFromReader(DbDataReader reader)
{
LoginDetails login = new LoginDetails();
if (reader.HasRows)
{
login.LoginId = GetReaderValue_Int32(reader, "LoginId", 0); //From: [Table]
login.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
login.LoginName = GetReaderValue_String(reader, "LoginName", ""); //From: [Table]
login.EmployeeName = GetReaderValue_String(reader, "EmployeeName", ""); //From: [usp_selectAll_Audit_authorisation_for_SalesOrder]
login.FirstName = GetReaderValue_String(reader, "FirstName", ""); //From: [Table]
login.LastName = GetReaderValue_String(reader, "LastName", ""); //From: [Table]
login.AddressNo = GetReaderValue_NullableInt32(reader, "AddressNo", null); //From: [Table]
login.Title = GetReaderValue_String(reader, "Title", ""); //From: [Table]
login.Extension = GetReaderValue_String(reader, "Extension", ""); //From: [Table]
login.Telephone = GetReaderValue_String(reader, "Telephone", ""); //From: [Table]
login.Fax = GetReaderValue_String(reader, "Fax", ""); //From: [Table]
login.EMail = GetReaderValue_String(reader, "EMail", ""); //From: [Table]
login.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company]
login.HomeTelephone = GetReaderValue_String(reader, "HomeTelephone", ""); //From: [Table]
login.HomeFax = GetReaderValue_String(reader, "HomeFax", ""); //From: [Table]
login.HomeEmail = GetReaderValue_String(reader, "HomeEmail", ""); //From: [Table]
login.Mobile = GetReaderValue_String(reader, "Mobile", ""); //From: [Table]
login.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0); //From: [usp_select_Contact]
login.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [Table]
login.Salutation = GetReaderValue_String(reader, "Salutation", ""); //From: [Table]
login.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table]
login.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
login.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
login.KeyLogin = GetReaderValue_Boolean(reader, "KeyLogin", false); //From: [Table]
login.MailMessageAddressType = GetReaderValue_String(reader, "MailMessageAddressType", ""); //From: [usp_autosearch_Login_for_Mail]
login.MailMessageAddressSort = GetReaderValue_String(reader, "MailMessageAddressSort", ""); //From: [usp_autosearch_Login_for_Mail]
login.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_Credit]
login.TeamName = GetReaderValue_String(reader, "TeamName", ""); //From: [usp_select_Company]
login.ClientName = GetReaderValue_String(reader, "ClientName", ""); //From: [Table]
login.ClientCurrencyNo = GetReaderValue_NullableInt32(reader, "ClientCurrencyNo", null); //From: [usp_select_Login_by_Name]
login.ClientCurrencyCode = GetReaderValue_String(reader, "ClientCurrencyCode", ""); //From: [usp_select_Login_by_Name]
login.OpenShippingCost = GetReaderValue_Double(reader, "OpenShippingCost", 0); //From: [usp_select_Client_LastMonth_GP]
login.OpenFreightCharge = GetReaderValue_Double(reader, "OpenFreightCharge", 0); //From: [usp_select_Client_LastMonth_GP]
login.OpenLandedCost = GetReaderValue_Double(reader, "OpenLandedCost", 0); //From: [usp_select_Client_LastMonth_GP]
login.OpenSalesValue = GetReaderValue_Double(reader, "OpenSalesValue", 0); //From: [usp_select_Client_LastMonth_GP]
login.ShippedShippingCost = GetReaderValue_Double(reader, "ShippedShippingCost", 0); //From: [usp_select_Client_LastMonth_GP]
login.ShippedFreightCharge = GetReaderValue_Double(reader, "ShippedFreightCharge", 0); //From: [usp_select_Client_LastMonth_GP]
login.ShippedLandedCost = GetReaderValue_Double(reader, "ShippedLandedCost", 0); //From: [usp_select_Client_LastMonth_GP]
login.ShippedSalesValue = GetReaderValue_Double(reader, "ShippedSalesValue", 0); //From: [usp_select_Client_LastMonth_GP]
login.Administrator = GetReaderValue_NullableBoolean(reader, "Administrator", null); //From: [usp_selectAll_Login_for_Client_including_Disabled]
login.NumberOfSalesAccounts = GetReaderValue_NullableInt32(reader, "NumberOfSalesAccounts", null); //From: [usp_selectAll_Login_for_Client_including_Disabled]
login.Cost = GetReaderValue_NullableDouble(reader, "Cost", null); //From: [usp_selectAll_Login_Top_Salespersons]
login.Resale = GetReaderValue_NullableDouble(reader, "Resale", null); //From: [usp_selectAll_Login_Top_Salespersons]
login.GrossProfit = GetReaderValue_NullableDouble(reader, "GrossProfit", null); //From: [usp_selectAll_Login_Top_Salespersons]
login.Margin = GetReaderValue_NullableDouble(reader, "Margin", null); //From: [usp_selectAll_Login_Top_Salespersons]
login.NoOfOrders = GetReaderValue_NullableInt32(reader, "NoOfOrders", null); //From: [usp_selectAll_Login_Top_Salespersons]
login.NoOfCredits = GetReaderValue_NullableInt32(reader, "NoOfCredits", null); //From: [usp_selectAll_Login_Top_Salespersons]
}
return(login);
}
/// <summary>
/// GetByName
/// Calls [usp_select_Login_by_Name]
/// </summary>
public static Login GetByName(System.String loginName)
{
Rebound.GlobalTrader.DAL.LoginDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Login.GetByName(loginName);
if (objDetails == null)
{
return(null);
}
else
{
Login obj = new Login();
obj.LoginId = objDetails.LoginId;
obj.ClientNo = objDetails.ClientNo;
obj.LoginName = objDetails.LoginName;
obj.EmployeeName = objDetails.EmployeeName;
obj.EmployeePassword = objDetails.EmployeePassword;
obj.FirstName = objDetails.FirstName;
obj.LastName = objDetails.LastName;
obj.AddressNo = objDetails.AddressNo;
obj.Title = objDetails.Title;
obj.Extension = objDetails.Extension;
obj.Telephone = objDetails.Telephone;
obj.Fax = objDetails.Fax;
obj.EMail = objDetails.EMail;
obj.Notes = objDetails.Notes;
obj.HomeTelephone = objDetails.HomeTelephone;
obj.HomeFax = objDetails.HomeFax;
obj.HomeEmail = objDetails.HomeEmail;
obj.Mobile = objDetails.Mobile;
obj.DivisionNo = objDetails.DivisionNo;
obj.TeamNo = objDetails.TeamNo;
obj.Salutation = objDetails.Salutation;
obj.Inactive = objDetails.Inactive;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.KeyLogin = objDetails.KeyLogin;
obj.DivisionName = objDetails.DivisionName;
obj.TeamName = objDetails.TeamName;
obj.ClientName = objDetails.ClientName;
obj.ClientCurrencyNo = objDetails.ClientCurrencyNo;
obj.ClientCurrencyCode = objDetails.ClientCurrencyCode;
obj.ClientCode = objDetails.ClientCode;
obj.ClientLocalCurrencyCode = objDetails.ClientLocalCurrencyCode;
obj.ADLogin = objDetails.ADLogin;
obj.IsPOHub = objDetails.IsPOHub;
obj.POHubMailGroupId = objDetails.POHubMailGroupId;
obj.IsGlobalUser = objDetails.IsGlobalUser;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Get
/// Calls [usp_select_Login]
/// </summary>
public static Login Get(System.Int32?loginId)
{
Rebound.GlobalTrader.DAL.LoginDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Login.Get(loginId);
if (objDetails == null)
{
return(null);
}
else
{
Login obj = new Login();
obj.LoginId = objDetails.LoginId;
obj.ClientNo = objDetails.ClientNo;
obj.LoginName = objDetails.LoginName;
obj.EmployeeName = objDetails.EmployeeName;
obj.EmployeePassword = objDetails.EmployeePassword;
obj.FirstName = objDetails.FirstName;
obj.LastName = objDetails.LastName;
obj.AddressNo = objDetails.AddressNo;
obj.Title = objDetails.Title;
obj.Extension = objDetails.Extension;
obj.Telephone = objDetails.Telephone;
obj.Fax = objDetails.Fax;
obj.EMail = objDetails.EMail;
obj.Notes = objDetails.Notes;
obj.HomeTelephone = objDetails.HomeTelephone;
obj.HomeFax = objDetails.HomeFax;
obj.HomeEmail = objDetails.HomeEmail;
obj.Mobile = objDetails.Mobile;
obj.DivisionNo = objDetails.DivisionNo;
obj.TeamNo = objDetails.TeamNo;
obj.Salutation = objDetails.Salutation;
obj.Inactive = objDetails.Inactive;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.KeyLogin = objDetails.KeyLogin;
obj.DivisionName = objDetails.DivisionName;
obj.TeamName = objDetails.TeamName;
obj.PrinterNo = objDetails.PrinterNo;
obj.PrinterName = objDetails.PrinterName;
obj.LabelPathNo = objDetails.LabelPathNo;
obj.LabelPath = objDetails.LabelPath;
obj.ADLogin = objDetails.ADLogin;
obj.GroupAccess = objDetails.GroupAccess;
obj.IsPOHub = objDetails.IsPOHub;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetName
/// Calls [usp_select_Login_Name]
/// </summary>
public static Login GetName(System.Int32?loginId)
{
Rebound.GlobalTrader.DAL.LoginDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Login.GetName(loginId);
if (objDetails == null)
{
return(null);
}
else
{
Login obj = new Login();
obj.EmployeeName = objDetails.EmployeeName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetThisYearGP
/// Calls [usp_select_Login_ThisYear_GP]
/// </summary>
public static Login GetThisYearGP(System.Int32?loginId)
{
Rebound.GlobalTrader.DAL.LoginDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Login.GetThisYearGP(loginId);
if (objDetails == null)
{
return(null);
}
else
{
Login obj = new Login();
obj.OpenShippingCost = objDetails.OpenShippingCost;
obj.OpenFreightCharge = objDetails.OpenFreightCharge;
obj.OpenLandedCost = objDetails.OpenLandedCost;
obj.OpenSalesValue = objDetails.OpenSalesValue;
obj.ShippedShippingCost = objDetails.ShippedShippingCost;
obj.ShippedFreightCharge = objDetails.ShippedFreightCharge;
obj.ShippedLandedCost = objDetails.ShippedLandedCost;
obj.ShippedSalesValue = objDetails.ShippedSalesValue;
objDetails = null;
return(obj);
}
}