/// <summary>
/// Load for the given parent.
/// </summary>
public static CustomerCompanySupportContract GetForCustomerCompany(
CustomerCompany parentObject )
{
DataRow row = AdoNetSqlHelper.ExecuteRow(
"GetCustomerCompanySupportContractByCustomerCompanyCrmReplicationUniqueID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@CrmReplicationUniqueID", parentObject.CrmReplicationUniqueID )
) );
if ( row == null )
{
return null;
}
else
{
CustomerCompanySupportContract o = new CustomerCompanySupportContract();
o.Load( row );
if ( o.IsEmpty )
{
return null;
}
else
{
return o;
}
}
}
// ------------------------------------------------------------------
/// <summary>
/// Load all.
/// </summary>
public static CustomerCompany[] GetCustomersWithUnbilledBillableTickets(
DateTime forMonth )
{
DateTime startDate = new DateTime( forMonth.Year, forMonth.Month, 1 );
DateTime endDate = startDate.AddMonths( 1 );
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetAllCustomerCompaniesWithUnbilledBillableTickets",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@StartDate", startDate ),
AdoNetSqlParamCollection.CreateParameter( "@EndDate", endDate )
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (CustomerCompany[])result.ToArray(
typeof( CustomerCompany ) );
}
}
}
/// <summary>
/// Get all distinct group names of all tickets of one customer.
/// </summary>
public static string[] GetDistinctGroupNamesForCustomerCompany(
CustomerCompany parentObject )
{
int companyID = 0;
if ( parentObject != null )
{
companyID = parentObject.ID;
}
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetDistinctGroupNamesByCustomerCompanyID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@CustomerCompanyID", companyID )
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
string v;
DBHelper.ReadField( out v, row[0] );
result.Add( v );
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (string[])result.ToArray(
typeof( string ) );
}
}
}
/// <summary>
/// Load all for the given parent.
/// </summary>
public static CustomerPerson[] GetForCompany(
CustomerCompany parentObject )
{
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetCustomerPersonByCustomerCompanyID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID )
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
CustomerPerson o = new CustomerPerson();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (CustomerPerson[])result.ToArray(
typeof( CustomerPerson ) );
}
}
}
private void newCustomerCompanyButton_Click(
object sender,
EventArgs e )
{
DBObjects.CustomerCompany company = new DBObjects.CustomerCompany();
CustomerCompanyEditForm form = new CustomerCompanyEditForm( company );
if ( form.ShowDialog( this ) == DialogResult.OK )
{
FillCustomerCompanyList();
SelectCustomerCompany( company );
}
}
private void newCustomerCompanyToolStripMenuItem_Click(
object sender,
EventArgs e )
{
DBObjects.CustomerCompany company = new DBObjects.CustomerCompany();
CustomerCompanyEditForm form = new CustomerCompanyEditForm( company );
form.Show( this );
}
/// <summary>
/// Load all for the given parent.
/// </summary>
public static Ticket[] GetForCustomerCompanyAssignedToUser(
CustomerCompany parentObject,
User user )
{
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetTicketsForCustomerCompanyAssignedToUser",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID ),
AdoNetSqlParamCollection.CreateParameter( "@UserSamName", user.SamName )
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
Ticket o = new Ticket();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (Ticket[])result.ToArray(
typeof( Ticket ) );
}
}
}
/// <summary>
/// Load all for the given parent.
/// </summary>
public static Ticket[] GetUnbilledBillableForCustomerCompany(
CustomerCompany parentObject,
DateTime forMonth )
{
DateTime startDate = new DateTime( forMonth.Year, forMonth.Month, 1 );
DateTime endDate = startDate.AddMonths( 1 );
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetUnbilledBillableTicketsByCustomerCompanyID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@CustomerCompanyID", parentObject.ID ),
AdoNetSqlParamCollection.CreateParameter( "@StartDate", startDate ),
AdoNetSqlParamCollection.CreateParameter( "@EndDate", endDate )
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
Ticket o = new Ticket();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (Ticket[])result.ToArray(
typeof( Ticket ) );
}
}
}
public static CustomerCompany GetByCrmReplicationUniqueID(
Guid crmReplicationUniqueID )
{
DataRow row = AdoNetSqlHelper.ExecuteRow(
"GetCustomerCompanyByCrmReplicationUniqueID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@CrmReplicationUniqueID", crmReplicationUniqueID )
) );
if ( row == null )
{
return null;
}
else
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( o.IsEmpty )
{
return null;
}
else
{
return o;
}
}
}
public static CustomerCompany GetForCrmAddress(
Crm.CrmAddress crmAddress )
{
DataRow row = AdoNetSqlHelper.ExecuteRow(
"GetCustomerCompanyFromCrmAddress",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@AddressID", crmAddress.ID )
) );
if ( row == null )
{
return null;
}
else
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( o.IsEmpty )
{
return null;
}
else
{
return o;
}
}
}
/// <summary>
/// Load all that have a ticket associated.
/// </summary>
/// <param name="getInfo"></param>
public static CustomerCompany[] Get(
CustomerCompanyGetInformation getInfo )
{
DataTable table = null;
if ( getInfo.CustomerGetType ==
CustomerCompanyGetType.CustomersWithTickets )
{
table = AdoNetSqlHelper.ExecuteTable(
"GetAllCustomerCompaniesWithTickets",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@FilterText", getInfo.IsFilterTextActive?getInfo.FilterText:string.Empty )
) );
}
else if ( getInfo.CustomerGetType ==
CustomerCompanyGetType.CustomersWithTicketsForOwn )
{
table = AdoNetSqlHelper.ExecuteTable(
"GetAllCustomerCompaniesWithTickets",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@FilterText", getInfo.IsFilterTextActive ? getInfo.FilterText : string.Empty ),
AdoNetSqlParamCollection.CreateParameter( "@UserSamName", getInfo.UserSamName )
) );
}
else if ( getInfo.CustomerGetType ==
CustomerCompanyGetType.AllCustomers )
{
table = AdoNetSqlHelper.ExecuteTable(
"GetAllCustomerCompanies",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@FilterText",
getInfo.IsFilterTextActive ? getInfo.FilterText : string.Empty )
) );
}
else
{
Debug.Assert( false );
}
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (CustomerCompany[])result.ToArray(
typeof( CustomerCompany ) );
}
}
}
/// <summary>
/// Load all that have a ticket associated.
/// </summary>
public static CustomerCompany[] GetAllWithTickets()
{
DataTable table = AdoNetSqlHelper.ExecuteTable(
"GetAllCustomerCompaniesWithTickets",
new AdoNetSqlParamCollection(
) );
if ( table == null )
{
return null;
}
else
{
ArrayList result = new ArrayList();
foreach ( DataRow row in table.Rows )
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( !o.IsEmpty )
{
result.Add( o );
}
}
if ( result.Count <= 0 )
{
return null;
}
else
{
return (CustomerCompany[])result.ToArray(
typeof( CustomerCompany ) );
}
}
}
/// <summary>
/// Load an object by a given ID.
/// </summary>
public static CustomerCompany GetByID(
int id )
{
DataRow row = AdoNetSqlHelper.ExecuteRow(
"GetCustomerCompanyByID",
new AdoNetSqlParamCollection(
AdoNetSqlParamCollection.CreateParameter( "@ID", id )
) );
if ( row == null )
{
return null;
}
else
{
CustomerCompany o = new CustomerCompany();
o.Load( row );
if ( o.IsEmpty )
{
return null;
}
else
{
return o;
}
}
}