public IList<AccountTypeRelation> Select(AccountTypeRelation data)
{
IList<AccountTypeRelation> datos = new List<AccountTypeRelation>();
datos = GetHsql(data).List<AccountTypeRelation>();
if (!Factory.IsTransactional)
Factory.Commit();
return datos;
}
public override Boolean Equals(object obj)
{
if ((obj == null) || (obj.GetType() != this.GetType()))
{
return(false);
}
AccountTypeRelation castObj = (AccountTypeRelation)obj;
return((castObj != null) &&
(this.RowID == castObj.RowID));
}
public void DeleteAccountTypeRelation(AccountTypeRelation data) { Factory.DaoAccountTypeRelation().Delete(data); }
public void UpdateAccountTypeRelation(AccountTypeRelation data) { Factory.DaoAccountTypeRelation().Update(data); }
public AccountTypeRelation SaveAccountTypeRelation(AccountTypeRelation data) { return Factory.DaoAccountTypeRelation().Save(data); }
public IList<AccountTypeRelation> GetAccountTypeRelation(AccountTypeRelation data) { return Factory.DaoAccountTypeRelation().Select(data); }
private IList<Account> GetCustomers(string sWhere)
{
IList<Account> list = new List<Account>();
Account tmpData;
AccountTypeRelation tmpAccTypeRel;
try
{
Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString);
// CAA ??? CUST ???
Query = "select DISTINCT t.f200_rowid, t.f200_id, t.f200_nit, t.f200_razon_social, c.f015_contacto " +
" from dbo.t200_mm_terceros t JOIN t201_mm_clientes cli ON t.f200_rowid = cli.f201_rowid_tercero AND cli.f201_id_cia = " + CurCompany.ErpCode +
" LEFT OUTER JOIN t015_mm_contactos c ON t.f200_rowid_contacto = c.f015_rowid " +
" WHERE t.f200_ind_cliente = 1 AND t.f200_id_cia=" + CurCompany.ErpCode + " AND c.f015_id_cia = " + CurCompany.ErpCode;
ds = ReturnDataSet(Query, sWhere, "f200_ind_cliente", Command.Connection);
if (ds == null || ds.Tables.Count == 0)
return null;
//Company company = WType.GetDefaultCompany();
AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = AccntType.Customer });
Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active });
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Map Properties
tmpData = new Account();
tmpData.AccountCode = dr["f200_id"].ToString();
if (string.IsNullOrEmpty(tmpData.AccountCode))
continue;
tmpData.Company = CurCompany;
tmpData.ContactPerson = dr["f015_contacto"].ToString();
tmpData.Name = dr["f200_razon_social"].ToString();
//tmpData.Phone = dr["PHONE1"].ToString();
tmpData.UserDefine1 = dr["f200_nit"].ToString();
//tmpData.UserDefine2 = dr["USERDEF2"].ToString();
//Account Type
tmpAccTypeRel = new AccountTypeRelation();
tmpAccTypeRel.Account = tmpData;
tmpAccTypeRel.AccountType = accType;
tmpAccTypeRel.ErpCode = dr["f200_rowid"].ToString();
tmpAccTypeRel.Status = status;
tmpAccTypeRel.CreationDate = DateTime.Now;
tmpAccTypeRel.CreatedBy = WmsSetupValues.SystemUser;
tmpData.AccountTypes = new AccountTypeRelation[] { tmpAccTypeRel };
tmpData.IsFromErp = true;
tmpData.BaseType = accType;
//Asignacion de Lines
tmpData.AccountAddresses = GetCustomerAddress(tmpData, dr["f200_rowid"].ToString());
list.Add(tmpData);
}
//retornar la lista
return list;
}
catch (Exception ex)
{
ExceptionMngr.WriteEvent("GetCustomers", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
//throw;
return null;
}
}
private IList<Account> GetVendors(string sWhere)
{
IList<Account> list = new List<Account>();
Account tmpData;
AccountTypeRelation tmpAccTypeRel;
try
{
Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString);
Query = " select v.VEND_CODE, v.NAME, v.CONTCODE, IsNull(a.first_name+' '+a.last_name,a.name) as CONTNAME " +
" from VENDORS v LEFT OUTER JOIN ADDRESS a ON v.CONTCODE = a.ADDR_CODE WHERE v.ACTIVE ='T' ";
ds = ReturnDataSet(Query, sWhere, "VENDORS", Command.Connection);
if (ds == null || ds.Tables.Count == 0)
return null;
//Company company = WType.GetDefaultCompany();
AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = AccntType.Vendor });
Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active });
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Map Properties
tmpData = new Account();
tmpData.AccountCode = dr["VEND_CODE"].ToString();
if (string.IsNullOrEmpty(tmpData.AccountCode))
continue;
tmpData.Company = CurCompany;
tmpData.ContactPerson = dr["CONTNAME"].ToString();
tmpData.Name = dr["NAME"].ToString();
// tmpData.Phone = dr["PHNUMBR1"].ToString();
// tmpData.UserDefine1 = dr["f200_nit"].ToString();
// tmpData.UserDefine2 = dr["USERDEF2"].ToString();
//Account Type
tmpAccTypeRel = new AccountTypeRelation();
tmpAccTypeRel.Account = tmpData;
tmpAccTypeRel.AccountType = accType;
tmpAccTypeRel.ErpCode = dr["VEND_CODE"].ToString();
tmpAccTypeRel.Status = status;
tmpAccTypeRel.CreationDate = DateTime.Now;
tmpAccTypeRel.CreatedBy = WmsSetupValues.SystemUser;
tmpData.AccountTypes = new AccountTypeRelation[] { tmpAccTypeRel };
tmpData.IsFromErp = true;
tmpData.BaseType = accType;
//Asignacion de Lines.... Datos del contacto del vendor (proveedor)
// caa ??? info de ADDRESS ?
// tmpData.AccountAddresses = GetVendorAddress(tmpData, dr["f200_rowid"].ToString());
list.Add(tmpData);
}
//retornar la lista
return list;
}
catch (Exception ex)
{
ExceptionMngr.WriteEvent("GetVendors", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
//throw;
return null;
}
}
private IList<Account> GetCustomers(string sWhere)
{
IList<Account> list = new List<Account>();
Account tmpData;
AccountTypeRelation tmpAccTypeRel;
try
{
//Lamar los documents que necesita del Erp usando econnect
//TODO: Revisar obtener solo lo modificado last X days
ds = DynamicsGP_ec.GetDataSet(DynamicsGP_ec.RetreiveData("Customer", false, 2, 0, sWhere, true));
if (ds.Tables.Count == 0)
return null;
//Company company = WType.GetDefaultCompany();
AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = AccntType.Customer });
Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active });
//En el dataset, Tables: 1 - CustomerHeader, 2 - CustomerAddress
foreach (DataRow dr in ds.Tables[1].Rows)
{
//Map Properties
tmpData = new Account();
try
{
tmpData.AccountCode = dr["CUSTNMBR"].ToString();
if (string.IsNullOrEmpty(tmpData.AccountCode))
continue;
tmpData.Company = CurCompany;
tmpData.ContactPerson = dr["CNTCPRSN"].ToString();
tmpData.Name = dr["CUSTNAME"].ToString();
tmpData.Phone = dr["PHONE1"].ToString();
tmpData.UserDefine1 = dr["USERDEF1"].ToString();
tmpData.UserDefine2 = dr["USERDEF2"].ToString();
//Account Type
tmpAccTypeRel = new AccountTypeRelation();
tmpAccTypeRel.Account = tmpData;
tmpAccTypeRel.AccountType = accType;
tmpAccTypeRel.ErpCode = dr["CUSTNMBR"].ToString();
tmpAccTypeRel.Status = status;
tmpAccTypeRel.CreationDate = DateTime.Now;
tmpAccTypeRel.CreatedBy = WmsSetupValues.SystemUser;
tmpData.AccountTypes = new AccountTypeRelation[] { tmpAccTypeRel };
tmpData.IsFromErp = true;
tmpData.BaseType = accType;
//Asignacion de Lines
tmpData.AccountAddresses = GetCustomerAddress(tmpData,
ds.Tables[2].Select("CUSTNMBR='" + dr["CUSTNMBR"].ToString() + "'"));
list.Add(tmpData);
}
catch (Exception ex){
ExceptionMngr.WriteEvent("GetCustomers:" + tmpData.AccountCode + "-"+
tmpData.Name, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
}
}
//retornar la lista
return list;
}
catch (Exception ex)
{
ExceptionMngr.WriteEvent("GetCustomers", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
//throw;
return null;
}
}
public AccountTypeRelation SelectById(AccountTypeRelation data)
{
return (AccountTypeRelation)base.SelectById(data);
}
public Boolean Delete(AccountTypeRelation data)
{
return base.Delete(data);
}
public Boolean Update(AccountTypeRelation data)
{
return base.Update(data);
}
public AccountTypeRelation Save(AccountTypeRelation data)
{
return (AccountTypeRelation)base.Save(data);
}
private void ProcessErpAccounts(IList<Account> list)
{
if (list == null)
return;
DaoFactory Factory = new DaoFactory();
Account qAcc = null;
AccountAddress curLine;
AccountTypeRelation curAccType;
foreach (Account e in list)
{
try
{
qAcc = new Account();
qAcc.Company = e.Company;
qAcc.AccountCode = e.AccountCode;
qAcc.BaseType = e.BaseType;
//Evalua si la entidad ya existe
IList<Account> exList = Factory.DaoAccount().Select(qAcc);
e.ModDate = DateTime.Now;
e.ModifiedBy = WmsSetupValues.SystemUser;
//Si existe
if (exList.Count == 0)
{
e.CreationDate = DateTime.Now;
e.CreatedBy = WmsSetupValues.SystemUser;
Factory.DaoAccount().Save(e);
}
else
{
e.AccountID = exList.First().AccountID;
e.CreatedBy = exList.First().CreatedBy;
e.CreationDate = exList.First().CreationDate;
//Preservar
e.UserDefine1 = exList.First().UserDefine1; //Shipping Mails
//Evaluar los Account Types
int i = 0;
foreach (AccountTypeRelation line in e.AccountTypes)
{
curAccType = new AccountTypeRelation();
curAccType.Account = e;
curAccType.ErpCode = line.ErpCode;
curAccType.AccountType = line.AccountType;
IList<AccountTypeRelation> listLines = Factory.DaoAccountTypeRelation().Select(curAccType);
if (listLines.Count > 0)
{
e.AccountTypes[i].ModDate = DateTime.Now;
e.AccountTypes[i].ModifiedBy = WmsSetupValues.SystemUser;
e.AccountTypes[i].CreationDate = listLines.First().CreationDate;
e.AccountTypes[i].CreatedBy = listLines.First().CreatedBy;
e.AccountTypes[i].RowID = listLines.First().RowID;
}
else
{
e.AccountTypes[i].CreationDate = DateTime.Now;
e.AccountTypes[i].CreatedBy = WmsSetupValues.SystemUser;
}
i++;
}
//Evaluar los document Lines
i = 0;
foreach (AccountAddress line in e.AccountAddresses)
{
curLine = new AccountAddress();
curLine.Account = e;
curLine.ErpCode = line.ErpCode;
IList<AccountAddress> listLines = Factory.DaoAccountAddress().Select(curLine);
if (listLines.Count > 0)
{
e.AccountAddresses[i].ModDate = DateTime.Now;
e.AccountAddresses[i].ModifiedBy = WmsSetupValues.SystemUser;
e.AccountAddresses[i].AddressID = listLines.First().AddressID;
e.AccountAddresses[i].CreationDate = listLines.First().CreationDate;
e.AccountAddresses[i].CreatedBy = listLines.First().CreatedBy;
}
else
{
e.AccountAddresses[i].CreationDate = DateTime.Now;
e.AccountAddresses[i].CreatedBy = WmsSetupValues.SystemUser;
}
i++;
}
Factory.DaoAccount().Update(e);
}
}
catch (Exception ex)
{
Factory.Rollback();
ExceptionMngr.WriteEvent("ProcessErpAccounts:" + qAcc.Name, ListValues.EventType.Fatal, ex, null, ListValues.ErrorCategory.Business);
////throw;
}
}
}
private IList<Account> GetVendors(string sWhere)
{
IList<Account> list = new List<Account>();
Account tmpData;
AccountTypeRelation tmpAccTypeRel;
try
{
Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString);
Query = GetErpQuery("VENDORS");
ds = ReturnDataSet(Query, sWhere, "VENDORS", Command.Connection);
if (ds == null || ds.Tables.Count == 0)
return null;
//Company company = WType.GetDefaultCompany();
AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = AccntType.Vendor });
Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active });
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Map Properties
tmpData = new Account();
try
{
tmpData.AccountCode = dr["f200_id"].ToString();
if (string.IsNullOrEmpty(tmpData.AccountCode))
continue;
tmpData.Company = CurCompany;
tmpData.ContactPerson = dr["f015_contacto"].ToString();
tmpData.Name = dr["f200_razon_social"].ToString();
//tmpData.Phone = dr["PHNUMBR1"].ToString();
tmpData.UserDefine1 = dr["f200_nit"].ToString();
tmpData.UserDefine2 = dr["f202_id_sucursal"].ToString();
//Account Type
tmpAccTypeRel = new AccountTypeRelation();
tmpAccTypeRel.Account = tmpData;
tmpAccTypeRel.AccountType = accType;
tmpAccTypeRel.ErpCode = dr["f200_rowid"].ToString();
tmpAccTypeRel.Status = status;
tmpAccTypeRel.CreationDate = DateTime.Now;
tmpAccTypeRel.CreatedBy = WmsSetupValues.SystemUser;
tmpData.AccountTypes = new AccountTypeRelation[] { tmpAccTypeRel };
tmpData.IsFromErp = true;
tmpData.BaseType = accType;
//Asignacion de Lines.... Datos del contacto del vendor (proveedor)
tmpData.AccountAddresses = GetVendorAddress(tmpData, dr["f200_rowid"].ToString());
list.Add(tmpData);
}
catch (Exception ex)
{
ExceptionMngr.WriteEvent("GetVendors:" + tmpData.AccountCode + "-" +
tmpData.Name, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
}
}
//retornar la lista
return list;
}
catch (Exception ex)
{
ExceptionMngr.WriteEvent("GetVendors", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection);
//throw;
return null;
}
}