public Factory(string server, string port, string user, string pass, string dbname)
{
string ConnectionString = "Server=" + server + "; Port=" + port + "; User Id=" + user + "; Password="******"; Database=" + dbname + ";";
NpgsqlConnection = new NpgsqlConnection(ConnectionString);
SqlConnection = new SqlConnection(NpgsqlConnection);
OpenConnection();
RepositoryBusiness_Trip = new RepositoryBusiness_Trip(SqlConnection);
RepositoryChair = new RepositoryChair(SqlConnection);
RepositoryContract = new RepositoryContract(SqlConnection);
RepositoryDegree = new RepositoryDegree(SqlConnection);
RepositoryEmployee_Sheet = new RepositoryEmployee_Sheet(SqlConnection);
RepositoryOrder = new RepositoryOrder(SqlConnection);
RepositoryPositions = new RepositoryPositions(SqlConnection);
RepositorySick_List = new RepositorySick_List(SqlConnection);
RepositoryStaff = new RepositoryStaff(SqlConnection);
RepositoryStaff_Degree = new RepositoryStaff_Degree(SqlConnection);
RepositoryStaff_Title = new RepositoryStaff_Title(SqlConnection);
RepositoryTime_Sheet = new RepositoryTime_Sheet(SqlConnection);
RepositoryTitle = new RepositoryTitle(SqlConnection);
//RepositoryTransfer_Training = new RepositoryTransfer_Training(SqlConnection);
RepositoryVacations = new RepositoryVacations(SqlConnection);
reg = new Registration(SqlConnection);
log = new Login(SqlConnection);
}
public EntityContract Insert(int FK_OrdenID, string Folio, string URL)
{
var objRepository = new RepositoryContract();
EntityContract data = new EntityContract()
{
PK_ContractID = 0,
Fk_OrderID = FK_OrdenID,
Folio = Folio,
Ruta = URL,
Status = true,
CreateDate = DateTime.UtcNow.ToLocalTime(),
ModifyDate = DateTime.UtcNow.ToLocalTime(),
};
data = objRepository.Insert(data);
return(data);
}
// a través del constructor
public StudentController(RepositoryContract <student> repository)
{
this.repository = repository;
}
