int IBoxFashionCommunication.InsertLoginCustomer(Security_LoginCustomer oLogin)
{
Business.LoginCustomerBusiness objLogin = null;
try
{
objLogin = new Business.LoginCustomerBusiness();
return(objLogin.InsertLoginCustomer(oLogin));
}
finally
{
if (objLogin != null)
{
objLogin.Dispose();
objLogin = null;
}
}
}
public int InsertLoginCustomer(Security_LoginCustomer oLogin)
{
return(_loginCustomerData.InsertLoginCustomer(oLogin));
}
public int InsertLoginCustomer(Security_LoginCustomer oLogin)
{
StringBuilder oQuery = null;
Hashtable oParam = null;
DataSet oAccesodataset = null;
try
{
oQuery = new StringBuilder();
oParam = new Hashtable();
oAccesodataset = new DataSet();
oQuery.Append("call sp_insert_logincustomer(:password,:last_login,:is_superuser,:loginCustomer,:firtsName,:secondName,:lastdName,:fullName,:email,:number_identification,:is_staff,:is_active,:date_joined)");
oParam.Add(":password", oLogin.password);
if (oLogin.last_login != DateTime.MinValue)
{
oParam.Add(":last_login", oLogin.last_login);
}
else
{
oParam.Add(":last_login", DBNull.Value);
}
oParam.Add(":is_superuser", oLogin.is_superuser);
if (oLogin.loginCustomer != null)
{
oParam.Add(":loginCustomer", oLogin.loginCustomer);
}
oParam.Add(":firtsName", oLogin.firtsName);
oParam.Add(":secondName", oLogin.secondName);
oParam.Add(":lastdName", oLogin.lastdName);
oParam.Add(":fullName", oLogin.fullName);
oParam.Add(":email", oLogin.email);
oParam.Add(":number_identification", oLogin.number_identification);
oParam.Add(":is_staff", oLogin.is_staff);
oParam.Add(":is_active", oLogin.is_active);
if (oLogin.date_joined != DateTime.MinValue)
{
oParam.Add(":date_joined", oLogin.date_joined);
}
else
{
oParam.Add(":date_joined", DBNull.Value);
}
oAccesodataset = base.PostGresDataProvider.RecordSet(oQuery.ToString(), oParam);
return(int.MinValue);
}
finally
{
if (oQuery != null)
{
oQuery = null;
}
if (oParam != null)
{
oParam = null;
}
if (oAccesodataset != null)
{
oAccesodataset.Dispose();
oAccesodataset = null;
}
}
}
