using System.Data;
using System.Data.Common;
using Domain.Accounting.Entities;
using Infrastructure.Accounting.DataBases;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Threading.Tasks;
namespace Infrastructure.Accounting.Repositories
{
public class RepositorySociety
{
public void Save(Society society)
{
DbCommand oCommand = Connection.DataBase.GetStoredProcCommand("USP_GE_SOCIETY_REGISTER");
Connection.DataBase.AddInParameter(oCommand, "@SocietyId", DbType.Int32, society.SocietyId );
Connection.DataBase.AddInParameter(oCommand, "@Name", DbType.String, society.Name );
Connection.DataBase.AddInParameter(oCommand, "@Alias", DbType.String, society.Alias );
Connection.DataBase.AddInParameter(oCommand, "@numberSociety", DbType.String, society.numberSociety );
Connection.DataBase.AddInParameter(oCommand, "@isAccountPlan", DbType.Boolean, society.isAccountPlan );
Connection.DataBase.AddInParameter(oCommand, "@Identifier", DbType.Guid , society.Identifier );
Connection.DataBase.AddInParameter(oCommand, "@isDelete", DbType.Boolean, society.isDelete );
Connection.DataBase.AddInParameter(oCommand, "@Status", DbType.String, society.Status );
Connection.DataBase.AddInParameter(oCommand, "@userCreate", DbType.String, society.userCreate );
Connection.DataBase.AddInParameter(oCommand, "@userModify", DbType.String, society.userModify );
Connection.DataBase.AddInParameter(oCommand, "@DateCreate", DbType.DateTime, society.DateCreate );
Connection.DataBase.AddInParameter(oCommand, "@DateModify", DbType.DateTime, society.DateModify );
Connection.DataBase.AddOutParameter(oCommand, "@SocietyIdOutput", DbType.Int32, society.SocietyId);
Connection.DataBase.ExecuteNonQuery(oCommand);
}
public Society getSocietyById(int idSociety)
{
var oResult = Connection.DataBase.ExecuteSprocAccessor<Society>("USP_SOCIETY_GetById", idSociety);
return oResult.FirstOrDefault();
}
public Society getSocietyByIdEntity(int idEntity)
{
IList<Entity> entity = Connection.DataBase.ExecuteSprocAccessor<Entity>("USP_SOCIETY_GetByIdEntity", idEntity).ToList();
int idSociety = entity.FirstOrDefault().SocietyId;
return getSocietyById(idSociety);
}
}
}
Comentarios sobre la versión: 2.0 (1)