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)); }