1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data;
using System.Configuration;
using SH.Model;
namespace SH.DAL
{
public class ActeProvider
{
public ActeProvider() { }
#region Basics Select, Delete, Update, Insert
public ActeEntity Select(int id)
{
ActeEntity obj = new ActeEntity();
IDataReader dr = null;
DBFactory db = DBFactory.GetInstance();
db.Command.CommandType = CommandType.Text;
obj = null;
try
{
dr = db.ExecuteReader("SELECT * FROM [ACTE] WHERE [ACT_ID] = " + id.ToString());
if (dr.Read())
{
obj = this.LoadFromReader(dr);
}
}
finally
{
if (dr != null) dr.Dispose();
}
return obj;
}
private ActeEntity LoadFromReader(IDataReader reader)
{
ActeEntity obj = new ActeEntity();
if (reader != null && !reader.IsClosed)
{
TimeSpan ts = new TimeSpan();
obj.Id = Convert.ToInt32(reader["ACT_ID"]);
obj.LieuId = Convert.ToInt32(reader["LIEU_ID"]);
obj.HebId = Convert.ToInt32(reader["HEB_ID"]);
obj.TieId = Convert.ToInt32(reader["TIE_ID"]);
obj.Version = Convert.ToInt32(reader["ACT_VERSION"]);
obj.Reference = Convert.ToString(reader["ACT_REF"]);
obj.DateDebut = Convert.ToDateTime(reader["ACT_DATE_DEBUT"]);
obj.DateFin = Convert.ToDateTime(reader["ACT_DATE_FIN"]);
obj.DateReservation = Convert.ToDateTime(reader["ACT_DATE_DE_CREATION"]);
obj.HebNom = Convert.ToString(reader["HEB_NOM"]);
obj.LieuNom = Convert.ToString(reader["LIEU_NOM_FR"]);
obj.TieNom = Convert.ToString(reader["TIE_NOM"]);
obj.ActMontant = Convert.ToDecimal(reader["ACT_MONTANT"]);
obj.NbNarticipants = Convert.ToInt32(reader["ACT_PARTICIPANT"]);
obj.Langue = Convert.ToString(reader["LANGUE"]);
}
return obj;
} |
Partager