public int UpdateClientes(ClientesDTO clientesDTO)
{
int rsta;
try
{
strSET = ConfiguracionParametrosUPDATE(clientesDTO);
strPLSQL = "UPDATE CUSTOMER " +
strSET + " " + strWhereUpdate;
OracleServerHelper OrclConection = new OracleServerHelper();
rsta = OrclConection.ExecuteSql(strPLSQL, Lstparameters);
}
catch (Exception ex)
{
rsta = 0;
Common.CreateTrace.WriteLog(Common.CreateTrace.LogLevel.Error, "ERROR EN DAL Clientes: UPDATE");
Common.CreateTrace.WriteLog(Common.CreateTrace.LogLevel.Error, " :: " + ex.Message);
}
return(rsta);
}
public long InsertarCliente(ClientesDTO ac_cliente)
{
long lb_respuesta;
lb_respuesta = 0;
try
{
string ls_sql;
OracleServerHelper losh_conection;
DataSet lds_datos;
ls_sql = "SELECT * FROM CUSTOMER WHERE USUARIO = '" + ac_cliente.User.ToString() + "'";
losh_conection = new OracleServerHelper();
lds_datos = losh_conection.ExecuteSqlToDataSet(ls_sql, new List <OracleParameter>());
if (lds_datos != null && lds_datos.Tables[0].Rows.Count > 0)
{
throw new Exception("Ya existe un usuario con el LOGIN ingresado");
}
else
{
DataSet dsAffected;
long tmpID = 0;
int ll_affected;
int tmprsta;
ls_sql = "INSERT INTO CUSTOMER (CUSTID,FNAME,LNAME,PHONENUMBER,EMAIL,PASSWORD,IDSTATUS,";
ls_sql += "ADDRESS,CITY,COUNTRY,USUARIO,IDTYPEIDENT) VALUES(" + ac_cliente.CustID.ToString();
ls_sql += ",'" + ac_cliente.FName + "','" + ac_cliente.LName + "',";
ls_sql += ac_cliente.PhoneNumber == null ? "NULL," : "'" + ac_cliente.PhoneNumber + "',";
ls_sql += ac_cliente.Email == null ? "NULL," : "'" + ac_cliente.Email + "',";
ls_sql += "'" + ac_cliente.Password + "',1,'" + ac_cliente.Address + "',";
ls_sql += "'" + ac_cliente.City + "','" + ac_cliente.Country + "',";
ls_sql += "'" + ac_cliente.User + "'," + ac_cliente.CodTypeIdent + ")";
tmprsta = losh_conection.ExecuteSql(ls_sql, new List <OracleParameter>());
if (tmprsta > 0)
{
ls_sql = "SELECT MAX(ID) FROM Customer";
dsAffected = losh_conection.ExecuteSqlToDataSet(ls_sql, new List <OracleParameter>());
if (dsAffected != null && dsAffected.Tables[0].Rows.Count > 0)
{
foreach (DataRow dataRowClientes in dsAffected.Tables[0].Rows)
{
tmpID = Convert.ToInt32(dataRowClientes["MAX(ID)"]);
}
}
else
{
tmpID = 0;
}
if (tmpID != 0)
{
if (ac_cliente.LCreditCard != null)
{
if (ac_cliente.LCreditCard.Count > 0)
{
foreach (CreditCardDTO lcc_creditCard in ac_cliente.LCreditCard)
{
ls_sql = "INSERT INTO CUSTOMERCREDITCARDS(CREDITCARDNUMBER,IDCUSTOMER,IDCREDITCARDTYPE,";
ls_sql += "FVENCE,CODESECURITY,CARDNAME) VALUES(" + lcc_creditCard.Number + ",";
ls_sql += tmpID.ToString() + "," + lcc_creditCard.Type + ",";
ls_sql += "'" + lcc_creditCard.ExpirationDate + "'," + lcc_creditCard.SecurityCode + ",";
ls_sql += "'" + lcc_creditCard.CardName + "')";
ll_affected = losh_conection.ExecuteSql(ls_sql, new List <OracleParameter>());
if (ll_affected <= 0)
{
throw new Exception("Error ingresando tarjeta de credito");
}
}
lb_respuesta = tmpID;
}
else
{
lb_respuesta = tmpID;
}
}
else
{
lb_respuesta = tmpID;
}
}
else
{
lb_respuesta = tmpID;
}
}
else
{
lb_respuesta = tmpID;
}
}
}
catch (Exception ae_e)
{
lb_respuesta = 0;
Common.CreateTrace.WriteLog(Common.CreateTrace.LogLevel.Error, "ERROR EN DAL Clientes:InsertarCliente");
Common.CreateTrace.WriteLog(Common.CreateTrace.LogLevel.Error, " :: " + ae_e.Message);
throw ae_e;
}
return(lb_respuesta);
}
