public List <VE_UserCompany> getUserNameByCompanyCode(string CompanyCode, int paymentAuthId)
{
VE_UserCompany _veUserCompany = null;
List <VE_UserCompany> _lstUserCompanies = new List <VE_UserCompany>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_CompanyCode", CompanyCode);
parameters.Add("_PaymentAuthId", paymentAuthId);
var rows = _database.QuerySP("sps_getUserNameByCompanyCode", parameters);
foreach (var row in rows)
{
_veUserCompany = new VE_UserCompany();
_veUserCompany.userName = row["UserName"];
_veUserCompany.email = row["Email"];
_veUserCompany.firstName = row["FirstName"];
_veUserCompany.lastName = row["LastName"];
_veUserCompany.authorize = string.IsNullOrEmpty(row["Authorize"]) ? 0 : int.Parse(row["Authorize"]);
_veUserCompany.amountTotal = string.IsNullOrEmpty(row["AmountTotal"]) ? 0 : decimal.Parse(row["AmountTotal"]);
_veUserCompany.quantityAuth = string.IsNullOrEmpty(row["quantityAuth"]) ? 0 : int.Parse(row["quantityAuth"]);
_lstUserCompanies.Add(_veUserCompany);
}
return(_lstUserCompanies);
}
public List <VE_UserCompany> getUserCompanies(string userName)
{
VE_UserCompany _veUserCompany = null;
List <VE_UserCompany> _lstUserCompanies = new List <VE_UserCompany>();
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "_userName", userName }
};
var rows = _database.QuerySP("sps_getUserCompanies", parameters);
foreach (var row in rows)
{
_veUserCompany = new VE_UserCompany();
_veUserCompany.email = row["Email"];
_veUserCompany.companyName = row["CompanyName"];
_veUserCompany.companyCode = row["CompanyCode"];
_veUserCompany.companyRuc = row["CompanyRuc"];
_veUserCompany.quantityAuth = string.IsNullOrEmpty(row["quantityAuth"]) ? 0 : int.Parse(row["quantityAuth"]);
_veUserCompany.authorize = string.IsNullOrEmpty(row["Authorize"]) ? 0 : int.Parse(row["Authorize"]);
_lstUserCompanies.Add(_veUserCompany);
}
return(_lstUserCompanies);
}
public BE_Json DeleteUserCompany(VE_UserCompany _VeUserCompany)
{
//BL_Usuario _blUsuario = new BL_Usuario();
//_blUsuario.connectionString = AppConfig.DbConnection;
//return _blUsuario.DeleteUserCompany(_VeUserCompany);
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Usuario _blUsuario = new BL_Usuario();
_blUsuario.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blUsuario.DeleteUserCompany(_VeUserCompany));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public List <BE_UserCompany> getUserCompany()
{
BE_UserCompany _VeUserCompany = null;
List <BE_UserCompany> _lstUserCompany = new List <BE_UserCompany>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
var rows = _database.QuerySP("sps_getUserCompany", parameters);
foreach (var row in rows)
{
_VeUserCompany = new VE_UserCompany();
_VeUserCompany.userId = row["UserId"];
_VeUserCompany.companyCode = row["CompanyCode"];
_lstUserCompany.Add(_VeUserCompany);
}
return(_lstUserCompany);
}
public VE_UserCompany createUserCompany(VE_UserCompany _VeUserCompany)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_userId", _VeUserCompany.userId);
parameters.Add("_companyCode", _VeUserCompany.companyCode);
parameters.Add("_userAudit", _VeUserCompany.userAudit);
filasAfectadas = _database.ExecuteSP("spi_insertUserCompany", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(_VeUserCompany);
}
return(null);
}
public VE_UserCompany DeleteUserCompany(VE_UserCompany _VeUserCompany)
{
_database = new MySQLDatabase(connectionString);
return(new DA_User(_database).deleteUserCompany(_VeUserCompany));
}
