public Decimal GetAverageTurnOverMonthGreaterThanDateByCustomer(DateTime date, CustomerObject customer)
{
TurnOverObjectCollection turnOvers;
Decimal turnOver = 0;
try
{
if (customer == null)
turnOvers = new TurnOverDataService().GetByGreaterThanDate(date);
else
turnOvers = new TurnOverDataService().GetByCustomerGreaterThanDate(customer, date);
for (int i = 0; i < turnOvers.Count; i++)
{
turnOver += turnOvers[i].TurnOver;
}
decimal months = Math.Round(Convert.ToDecimal(System.DateTime.Now.Subtract(date).TotalDays) / Convert.ToDecimal(30.5), 0);
turnOver = turnOver / months;
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOver;
}
public static CustomerObject CustomerRowToObject(DataRow customer)
{
CustomerObject obj = new CustomerObject();
try
{
if (customer != null)
{
if (RowFunctions.GetValueFromRowToGuid(customer, CustomerObject.CUS_ID, false, DataRowVersion.Current) != Guid.Empty)
{
obj.CusID = RowFunctions.GetValueFromRowToGuid(customer, CustomerObject.CUS_ID, true, DataRowVersion.Current);
obj.TasID = RowFunctions.GetValueFromRowToInteger(customer, CustomerObject.TAS_ID, true, DataRowVersion.Current);
obj.Name = RowFunctions.GetValueFromRowToString(customer, CustomerObject.NAME, true, DataRowVersion.Current);
obj.Name2 = RowFunctions.GetValueFromRowToString(customer, CustomerObject.NAME2, true, DataRowVersion.Current);
obj.Street = RowFunctions.GetValueFromRowToString(customer, CustomerObject.STREET, true, DataRowVersion.Current);
obj.HouseNumber = RowFunctions.GetValueFromRowToString(customer, CustomerObject.HOUSE_NUMBER, true, DataRowVersion.Current);
obj.Zipcode = RowFunctions.GetValueFromRowToString(customer, CustomerObject.ZIPCODE, true, DataRowVersion.Current);
obj.Town = RowFunctions.GetValueFromRowToString(customer, CustomerObject.TOWN, true, DataRowVersion.Current);
obj.Country = RowFunctions.GetValueFromRowToString(customer, CustomerObject.COUNTRY, true, DataRowVersion.Current);
obj.Vat = RowFunctions.GetValueFromRowToString(customer, CustomerObject.VAT, true, DataRowVersion.Current);
obj.Phone = RowFunctions.GetValueFromRowToString(customer, CustomerObject.PHONE, true, DataRowVersion.Current);
obj.Language = RowFunctions.GetValueFromRowToString(customer, CustomerObject.LANGUAGE, true, DataRowVersion.Current);
obj.Currency = RowFunctions.GetValueFromRowToString(customer, CustomerObject.CURRENCY, true, DataRowVersion.Current);
}
return obj;
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return obj;
}
public void Remove(CustomerObject value)
{
try
{
List.Remove(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public int Add(CustomerObject value)
{
try
{
return(List.Add(value));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Called by CustomerObject when it changes
internal void CustomerObjectChanged(CustomerObject customer)
{
try
{
int index = List.IndexOf(customer);
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Methods.
object IBindingList.AddNew()
{
try
{
CustomerObject customer = new CustomerObject();
List.Add(customer);
return(customer);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public Decimal GetAverageTurnOverMonthByYearByCustomer(int year, CustomerObject customer)
{
Decimal turnOver;
try
{
turnOver = new TurnOverDataService().GetAverageTurnOverMonthByYearByCustomer(customer, year);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOver;
}
protected override void OnRemoveComplete(int index, object value)
{
try
{
CustomerObject customer = (CustomerObject)value;
customer.Parent = this;
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemDeleted, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public TurnOver(CustomerObject customer)
{
try
{
InitializeComponent();
_blTurnover = new BL.External.TAS.TurnOver.TurnOver();
_customer = customer;
FillControls();
AddSerie(1, System.DateTime.Now.Year);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Remove(CustomerObject customer)
{
try
{
CheckTransaction();
new CustomerDataService(Transaction).Remove(customer);
if (IsOwner) Transaction.Commit();
}
catch (Exception exception1)
{
if (IsOwner) Transaction.Rollback();
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (IsOwner) Connection.Close();
}
}
protected override void OnSetComplete(int index, object oldValue, object newValue)
{
try
{
if (oldValue != newValue)
{
CustomerObject oldCustomer = (CustomerObject)oldValue;
CustomerObject newCustomer = (CustomerObject)newValue;
oldCustomer.Parent = null;
newCustomer.Parent = this;
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemAdded, index));
}
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public Customer(PROF_IT.Common.Enumerations.TypeForm typeForm, CustomerObject customer)
{
try
{
InitializeComponent();
_customer = customer;
_typeForm = typeForm;
if (_typeForm == PROF_IT.Common.Enumerations.TypeForm.NewForm)
{
throw new NotImplementedException();
}
else
{
InitializePropertyForm();
}
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public Customer(PROF_IT.Common.Enumerations.TypeForm typeForm, CustomerObject customer)
{
try
{
InitializeComponent();
_customer = customer;
_typeForm = typeForm;
if (_typeForm == PROF_IT.Common.Enumerations.TypeForm.NewForm)
{
throw new NotImplementedException();
}
else
{
InitializePropertyForm();
}
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public static CustomerObject CustomerRowToObject(DataRow customer)
{
CustomerObject obj = new CustomerObject();
try
{
if (customer != null)
{
if (RowFunctions.GetValueFromRowToGuid(customer, CustomerObject.CUS_ID, false, DataRowVersion.Current) != Guid.Empty)
{
obj.CusID = RowFunctions.GetValueFromRowToGuid(customer, CustomerObject.CUS_ID, true, DataRowVersion.Current);
obj.TasID = RowFunctions.GetValueFromRowToInteger(customer, CustomerObject.TAS_ID, true, DataRowVersion.Current);
obj.Name = RowFunctions.GetValueFromRowToString(customer, CustomerObject.NAME, true, DataRowVersion.Current);
obj.Name2 = RowFunctions.GetValueFromRowToString(customer, CustomerObject.NAME2, true, DataRowVersion.Current);
obj.Street = RowFunctions.GetValueFromRowToString(customer, CustomerObject.STREET, true, DataRowVersion.Current);
obj.HouseNumber = RowFunctions.GetValueFromRowToString(customer, CustomerObject.HOUSE_NUMBER, true, DataRowVersion.Current);
obj.Zipcode = RowFunctions.GetValueFromRowToString(customer, CustomerObject.ZIPCODE, true, DataRowVersion.Current);
obj.Town = RowFunctions.GetValueFromRowToString(customer, CustomerObject.TOWN, true, DataRowVersion.Current);
obj.Country = RowFunctions.GetValueFromRowToString(customer, CustomerObject.COUNTRY, true, DataRowVersion.Current);
obj.Vat = RowFunctions.GetValueFromRowToString(customer, CustomerObject.VAT, true, DataRowVersion.Current);
obj.Phone = RowFunctions.GetValueFromRowToString(customer, CustomerObject.PHONE, true, DataRowVersion.Current);
obj.Language = RowFunctions.GetValueFromRowToString(customer, CustomerObject.LANGUAGE, true, DataRowVersion.Current);
obj.Currency = RowFunctions.GetValueFromRowToString(customer, CustomerObject.CURRENCY, true, DataRowVersion.Current);
}
return(obj);
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return(obj);
}
public void Save(CustomerObject customer)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Customer_SAVE",
CreateParameter("@cusID", SqlDbType.UniqueIdentifier, customer.CusID, ParameterDirection.InputOutput),
CreateParameter("@tasID", SqlDbType.Int, customer.TasID),
CreateParameter("@Name", SqlDbType.NChar, customer.Name),
CreateParameter("@Name2", SqlDbType.NChar, customer.Name2),
CreateParameter("@Street", SqlDbType.NChar, customer.Street),
CreateParameter("@HouseNumber", SqlDbType.NChar, customer.HouseNumber),
CreateParameter("@Zipcode", SqlDbType.NChar, customer.Zipcode),
CreateParameter("@Town", SqlDbType.NChar, customer.Town),
CreateParameter("@Country", SqlDbType.NChar, customer.Country),
CreateParameter("@VAT", SqlDbType.NChar, customer.Vat),
CreateParameter("@Phone", SqlDbType.NChar, customer.Phone),
CreateParameter("@Language", SqlDbType.NChar, customer.Language),
CreateParameter("@Currency", SqlDbType.NChar, customer.Currency)
);
customer.CusID = (Guid)cmd.Parameters["cusID"].Value;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
void IEditableObject.EndEdit()
{
try
{
if (inTxn)
{
_loadedTask = this.Task;
_loadedEmployee = this.Employee;
_loadedSupplier = this.Supplier;
_loadedCustomer = this.Customer;
_loadedUnknown = this.Unknown;
_loadedAssignee = this.Assignee;
_loadedReporter = this.Reporter;
inTxn = false;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public Decimal GetAverageTurnOverMonthByYearByCustomer(CustomerObject customer, int year)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
Decimal turnOver = new Decimal();
try
{
if (customer == null) //Average All
return GetAverageTurnOverMonthByYear(year);
else // Average Customer
{
turnOvers = GetByCustomerByYear(customer, year);
for (int i = 0; i < turnOvers.Count; i++)
{
turnOver += turnOvers[i].TurnOver;
}
int months = 1;
if (year != System.DateTime.Now.Year)
months = 12;
else
months = System.DateTime.Now.Month;
turnOver = turnOver / months;
}
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return turnOver;
}
public Decimal GetTurnOverByYearByCustomer(CustomerObject customer, int year)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
Decimal turnOver = new Decimal();
SqlCommand cmd = null;
DataTable dt;
try
{
string query = "SELECT SUM(Turnover) "
+ " FROM [TIS].[dbo].[TurnOverCustomer]"
+ " WHERE tas_TNR_ID = " + customer.TasID + " AND Date >= '" + year + "0101' AND Date <= '" + year + "1231'";
cmd = new SqlCommand(query);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@TNR_ID", customer.TasID));
cmd.Parameters.Add(new SqlParameter("@YEAR", year));
dt = this.ExecuteNonQuery(cmd, false).Tables[0];
if (dt.Rows[0][0].ToString() == "")
turnOver = 0;
else
turnOver = Convert.ToDecimal(dt.Rows[0][0].ToString());
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return turnOver;
}
public TurnOverObjectCollection GetByCustomerGreaterThanDate(CustomerObject customer, DateTime date)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByCustomerGreaterThanDate");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TNR_ID", customer.TasID));
cmd.Parameters.Add(new SqlParameter("@DATE", date));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return AddZeroTurnOvers(turnOvers);
}
public TurnOverObjectCollection GetByYear(int year, CustomerObject customer)
{
TurnOverObjectCollection turnOvers;
try
{
if (customer == null)
turnOvers = new TurnOverDataService().GetByYear(year);
else
turnOvers = new TurnOverDataService().GetByCustomerByYear(customer, year);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOvers;
}
public Decimal GetTurnOverByYearByCustomer(CustomerObject customer, int year)
{
Decimal turnOver = 0;
try
{
if (customer != null)
{
turnOver = new TurnOverDataService().GetTurnOverByYearByCustomer(customer, year);
}
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOver;
}
public TurnOverObjectCollection GetByCustomer(CustomerObject customer)
{
TurnOverObjectCollection turnOvers;
try
{
turnOvers = new TurnOverDataService().GetByCustomer(customer);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOvers;
}
public TurnOverObjectCollection GetByCustomerGreaterThanDate(DateTime date, CustomerObject customer)
{
TurnOverObjectCollection turnOvers;
try
{
if (customer == null)
turnOvers = new TurnOverDataService().GetByGreaterThanDate(date);
else
turnOvers = new TurnOverDataService().GetByCustomerGreaterThanDate(customer, date);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return turnOvers;
}
public int Add(CustomerObject value)
{
try
{
return List.Add(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Methods.
object IBindingList.AddNew()
{
try
{
CustomerObject customer = new CustomerObject();
List.Add(customer);
return customer;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public bool Remove(CustomerObject customer)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Customer_DELETE",
CreateParameter("@cusID", SqlDbType.UniqueIdentifier, customer.CusID, ParameterDirection.Input)
);
return true;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
public void Remove(CustomerObject value)
{
try
{
List.Remove(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Called by CustomerObject when it changes
internal void CustomerObjectChanged(CustomerObject customer)
{
try
{
int index = List.IndexOf(customer);
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
