public override void DataBind()
{
if (_bound)
{
return;
}
_bound = true;
Display = false;
if (_source != "")
{
Control ctrl = Page.FindControl(_source);
if (ctrl != null)
{
CustomDataSource dataSrc = ctrl as CustomDataSource;
if (ctrl != null)
{
Display = !dataSrc.HasData;
}
}
}
base.DataBind();
}
public void CustomDataSource_Constructor_CreateEmptyDictionary()
{
var source = new CustomDataSource();
Assert.IsNotNull(source.Data);
Assert.AreEqual(0, source.Data.Count);
}
public override void ViewDidLoad()
{
base.ViewDidLoad();
NavigationItem.BackBarButtonItem = new UIBarButtonItem("Back", UIBarButtonItemStyle.Plain, null);
var source = new CustomDataSource(this, this.TableView, new NSString("TodoListViewCell"));
TableView.Source = source;
var set = this.CreateBindingSet <HomeView, ViewModels.HomeViewModel>();
set.Bind(source)
.For(x => x.SelectionChangedCommand)
.To(vm => vm.SelectItem);
set.Bind(source)
.For(x => x.ItemsSource)
.To(vm => vm.TodoLists);
set.Bind(NavigationItem)
.For(x => x.Title)
.To(vm => vm.Title);
set.Bind(AddButton)
.To(vm => vm.AddNewItem);
set.Apply();
}
/// <summary>
/// InsertMachine
/// </summary>
/// <returns>Liste supports</returns>
public int InsertMachine(Machine s)
{
int result = -1;
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
result = maDataSource.ExecuterDML(REQUETE_AJOUTER_MACHINE, true, s.Code, s.Nom, s.Historique, s.Caracteristiques, s.DateSortie);
maDataSource.CommitGlobalTransaction();
}
catch (Exception ex)
{
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
}
return result;
}
private FilterArgs GetSql(FilterArgs args)
{
#region CS
//RemoteDataHelper rdh = null;
//if (args != null && !string.IsNullOrEmpty(args.ClassName.Trim()))
//{
// if (args.DataSource.Type == CustomDataSourceTypeEnum.TemplateTable)
// args.DataSource.SQL = CustomDataSource.GetATableName();
// if (_context.ReportState == ReportStates.WebBrowse)
// {
// rdh = DefaultConfigs.GetRemoteHelper();
// args = rdh.GetSql(_context.UserToken, _context.TaskID, _context.SubID, _context.FilterArgs);
// }
// else
// {
// rdh = new RemoteDataHelper();
// ClientReportContext.Login = _login;
// rdh.GetSql(args);
// }
//}
#endregion
var rdHelper = new RemoteDataHelper();
//return rdHelper.GetSql(_login.UserToken, _login.TaskID, _login.SubID, args);
if (args.DataSource.Type == CustomDataSourceTypeEnum.TemplateTable)
{
//args.DataSource.SQL = CustomDataSource.GetATableNameWithTaskId(_login.TaskID);
args.DataSource.SQL = CustomDataSource.GetATableName();
}
ClientReportContext.Login = _login;
rdHelper.GetSql(args);
return(args);
}
private void GetSql()
{
if (_context.ReportState == ReportStates.OutU8)
{
return;
}
RemoteDataHelper rdh = null;
if (_context.FilterArgs != null && !string.IsNullOrEmpty(_context.FilterArgs.ClassName.Trim()))
{
if (_context.FilterArgs.DataSource.Type == CustomDataSourceTypeEnum.TemplateTable)
{
//_context.FilterArgs.DataSource.SQL = CustomDataSource.GetATableName();
_context.FilterArgs.DataSource.SQL = CustomDataSource.GetATableNameWithTaskId(_context.TaskID);
}
if (_context.ReportState == ReportStates.WebBrowse)
{
rdh = DefaultConfigs.GetRemoteHelper();
_context.FilterArgs = rdh.GetSql(_context.UserToken, _context.TaskID, _context.SubID, _context.FilterArgs);
}
else
{
rdh = new RemoteDataHelper();
rdh.GetSql(_context.FilterArgs);
}
}
}
public IHttpActionResult PostCustomDataSource([FromBody] CustomDataSource ds)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (db.CustomDataSources.Count(t => t.Name.Trim() == ds.Name.Trim()) == 0)
{
CustomDataSource cds = new CustomDataSource()
{
CreatedBy = db.Members.FirstOrDefault(d => d.Email == User.Identity.Name),
DateCreated = DateTime.Now,
HtmlTemplate = ds.HtmlTemplate,
Name = ds.Name,
Query = ds.Query
};
db.CustomDataSources.Add(cds);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = cds.ID }, cds));
}
else
{
return(BadRequest("Data source with same name exist."));
}
}
/// <summary>
/// 数据转移到临时表的基础服务类构造函数
/// </summary>
/// <param name="rdf">UFIDA.U8.UAP.Services.ReportData.ReportDataFacade类型,主要是使用其提供的UFDataCnnString</param>
/// <param name="customDataSource">通过此参数将临时表名称返回调用者</param>
public Base2TempTable(
ReportDataFacade rdf,
CustomDataSource customDataSource)
{
this._loginInfor = rdf._U8LoginInfor;
this._customDataSource = customDataSource;
}
private IDataSource AddDataSource(DataSource settings)
{
lock (_syncRoot)
{
IDataSource dataSource;
if (!string.IsNullOrEmpty(settings.LogFileFolderPath))
{
dataSource = new FolderDataSource(_taskScheduler, _logSourceFactory, _filesystem, settings);
}
else if (!string.IsNullOrEmpty(settings.File))
{
dataSource = new FileDataSource(_logSourceFactory, _taskScheduler, settings, _maximumWaitTime);
}
else if (settings.CustomDataSourceConfiguration != null)
{
dataSource = new CustomDataSource(_logSourceFactory, _taskScheduler, settings, _maximumWaitTime);
}
else
{
if (settings.DisplayName == null)
{
settings.DisplayName = "Merged Data Source";
}
dataSource = new MergedDataSource(_taskScheduler, settings, _maximumWaitTime);
}
_dataSources.Add(dataSource);
_dataSourceIds.Add(dataSource.Id);
_bookmarks.AddDataSource(dataSource);
return(dataSource);
}
}
/// <summary>
/// Get a CustomDataSource: filtered, ordered
/// ex: secondFilter = "it.SectionID = @SectionId"
/// </summary>
public CustomDataSource <TEntity> BindData(string sidx, string sord, int page, int rows, bool search, string filters, string secondFilter = "")
{
var serializer = new JavaScriptSerializer();
var filtersTemp = (!search || string.IsNullOrEmpty(filters)) ? null : serializer.Deserialize <Filters>(filters);
ObjectContext objectContext = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)Context).ObjectContext;
ObjectSet <TEntity> objectSet = objectContext.CreateObjectSet <TEntity>();
ObjectQuery <TEntity> filteredQuery = filtersTemp == null ? objectSet : filtersTemp.FilterObjectSet(objectSet);
filteredQuery.MergeOption = MergeOption.NoTracking; // we don't want to update the data
if (!string.IsNullOrEmpty(secondFilter))
{
filteredQuery = filteredQuery.Where(secondFilter);
}
var totalRecords = filteredQuery.Count();
var pagedQuery = filteredQuery.Skip("it." + sidx + " " + sord, "@skip", new ObjectParameter("skip", (page - 1) * rows))
.Top("@limit", new ObjectParameter("limit", rows));
var customDataSource = new CustomDataSource <TEntity>(pagedQuery.ToList(), totalRecords);
return(customDataSource);
}
public CustomDataSource <PersonDto> BindData(string sidx, string sord, int page, int rows, bool search, string filters)
{
CustomDataSource <Person> personList = Uow.PersonRepository.BindData(sidx, sord, page, rows, search, filters);
var customDataSource = new CustomDataSource <PersonDto>(personList.RecordList.Select(FromEntityToModel).ToList(),
personList.TotalRecords);
return(customDataSource);
}
public CustomDataSource<PersonDto> BindData(string sidx, string sord, int page, int rows, bool search, string filters)
{
CustomDataSource<Person> personList = Uow.PersonRepository.BindData(sidx, sord, page, rows, search, filters);
var customDataSource = new CustomDataSource<PersonDto>(personList.RecordList.Select(FromEntityToModel).ToList(),
personList.TotalRecords);
return customDataSource;
}
/// <summary>
/// ObtenirProprietaire
/// </summary>
/// <returns>Le proprietaire</returns>
public Proprietaire ObtenirProprietaire(string pLogin)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
maDataSource.ExecuterDML(REQUETE_HISTORIQUE_CONNEXION, false, pLogin);
return maDataSource.ExecuterRequete<Proprietaire>(REQUETE_OBTENIR_PROPRIETAIRE, new ProprietaireRowMapper(), false, pLogin);
}
public bool Delete(int id)
{
using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString))
{
CustomDataSource item = (from t in dc.CustomDataSources where t.ID == id select t).SingleOrDefault <CustomDataSource>();
dc.CustomDataSources.DeleteOnSubmit(item);
dc.SubmitChanges();
return(true);
}
}
public void CustomDataSource_GetValue_ReturnsValuesFromDictionary()
{
var source = new CustomDataSource();
source.Data["key1"] = "value1";
source.Data["key2"] = "value2";
Assert.AreEqual("value1", source.GetValue("key1"));
Assert.AreEqual("value2", source.GetValue("key2"));
Assert.IsNull(source.GetValue("key3"));
}
public void CascadeSettingsContainer_AddSource_AddsToSourcesAndReturnsInstance()
{
var source = new CustomDataSource();
var container = new CascadeSettingsContainer();
var source1 = container.AddSource(source);
Assert.True(container.Sources.Contains(source));
Assert.Equal(source, source1);
}
public override void DataBind()
{
if (_bound)
{
return;
}
_bound = true;
CustomDataSource dataSrc = null;
if (!String.IsNullOrWhiteSpace(source))
{
Control ctrl = Page.FindControl(source);
if (ctrl != null)
{
dataSrc = ctrl as CustomDataSource;
}
}
else
{
dataSrc = this.Parent as CustomDataSource;
}
if (dataSrc != null)
{
DataTable ds = dataSrc.Data as DataTable;
Visible = false;
if (ds != null && dataSrc.HasData)
{
int pageId = (int)ControlUtils.GetBoundedDataField(this.NamingContainer, "PageId");
for (int i = 0; i < ds.Rows.Count; i++)
{
DataRow p = ds.Rows[i];
if ((int)p["PageId"] == pageId && i < ds.Rows.Count - 1)
{
Visible = true;
p = ds.Rows[i + 1];
this.Title = p["Title"].ToString();
this.FullURL = p["FullURL"].ToString();
this.PageId = (int)p["PageId"];
break;
}
}
}
}
base.DataBind();
}
public void BaseSettingValue_Value_ReturnsEffectiveValue()
{
var definition = new IntegerSettingDefinition("key1", "desc", 0);
var source = new CustomDataSource();
var container = new CascadeSettingsContainer();
container.AddSource(source);
var settingValue = new SettingValue <int>(container, definition);
source.Data["key1"] = "100";
Assert.Equal(100, settingValue.Value);
}
public void BaseSettingValue_Value_RaisesExceptionIfNotConvertible()
{
var definition = new IntegerSettingDefinition("key1", "desc", 0);
var source = new CustomDataSource();
var container = new CascadeSettingsContainer();
container.AddSource(source);
var settingValue = new SettingValue <int>(container, definition);
source.Data["key1"] = "text";
Assert.Throws <InvalidOperationException>(() => settingValue.Value);
}
public ActionResult BindData(string sidx, string sord, int page, int rows, bool search, string filters)
{
BindDataParam = new BindDataParamDto {
Sidx = sidx, Sord = sord, Page = page, Rows = rows, Filters = filters
};
Response.Cache.SetCacheability(HttpCacheability.ServerAndPrivate);
Response.Cache.SetMaxAge(new TimeSpan(0));
CustomDataSource <PersonDto> dataSource = personBl.BindData(sidx, sord, page, rows, search, filters);
// to be able to use ToString() below which is NOT exist in the LINQ to Entity
// we should include in queryDetails only the properies which we will use below
var queryDetails = (from item in dataSource.RecordList
select new { item.Id, item.FirstName, item.LastName, item.Age }).ToList();
var retult = new
{
total = (dataSource.TotalRecords + rows - 1) / rows,
page,
records = dataSource.TotalRecords,
rows = (from item in queryDetails
select new[] {
item.Id + "",
item.FirstName,
item.LastName,
item.Age + ""
}).ToList()
};
// calculate MD5 from the returned data and use it as ETag
var serializer = new JavaScriptSerializer();
var str = serializer.Serialize(retult);
byte[] inputBytes = Encoding.ASCII.GetBytes(str);
byte[] hash = MD5.Create().ComputeHash(inputBytes);
string newETag = Convert.ToBase64String(hash);
Response.Cache.SetETag(newETag);
// compare ETag of the data which already has the client with ETag of response
string incomingEtag = Request.Headers["If-None-Match"];
if (String.Compare(incomingEtag, newETag, StringComparison.Ordinal) == 0)
{
// we don't need return the data which the client already have
Response.SuppressContent = true;
Response.StatusCode = (int)HttpStatusCode.NotModified;
return(null);
}
return(Json(retult, JsonRequestBehavior.AllowGet));
}
public bool Update(int id, string name, string query, string template, long memberid)
{
using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString))
{
CustomDataSource item = (from t in dc.CustomDataSources where t.ID == id select t).SingleOrDefault <CustomDataSource>();
item.Name = name;
item.Query = query;
item.HtmlTemplate = template;
item.ModifiedBy = memberid;
item.DateModified = DateTime.Now;
dc.SubmitChanges();
return(true);
}
}
public IHttpActionResult DeleteCustomDataSource(int id)
{
CustomDataSource customDataSource = db.CustomDataSources.Find(id);
if (customDataSource == null)
{
return(NotFound());
}
db.CustomDataSources.Remove(customDataSource);
db.SaveChanges();
return(Ok(customDataSource));
}
private string GetTempTableName()
{
if (!string.IsNullOrEmpty(this._customDataSource.SQL) &&
this._customDataSource.SQL.StartsWith("tempdb..[me_"))
{
this._tempTableName = this._customDataSource.SQL;
}
else
{
//this._tempTableName = CustomDataSource.GetATableName();
this._tempTableName = CustomDataSource.GetATableNameWithTaskId(_loginInfor.TaskID);
}
return(this._tempTableName);
}
public bool Add(string name, string query, string template, long memberid)
{
using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString))
{
CustomDataSource item = new CustomDataSource();
item.Name = name;
item.Query = query;
item.HtmlTemplate = template;
item.DateCreated = DateTime.Now;
item.CreatedBy = memberid;
dc.CustomDataSources.InsertOnSubmit(item);
dc.SubmitChanges();
return(true);
}
}
public IHttpActionResult GetCustomDataSource(int id)
{
if (id == 0)
{
return(Ok(new CustomDataSource()));
}
CustomDataSource customDataSource = db.CustomDataSources.Find(id);
if (customDataSource == null)
{
return(NotFound());
}
return(Ok(customDataSource));
}
public string LoadContent(string name)
{
if (CacheManager.Get <string>(name) != null)
{
return(CacheManager.Get <string>(name));
}
else
{
CustomDataSource cds = GetByName(name);
if (cds != null)
{
if (cds.Query.Trim() == string.Empty)
{
CacheManager.Add(name, cds.HtmlTemplate.Trim(), DateTime.Now.AddDays(2));
return(CacheManager.Get <string>(name));
}
else
{
using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString))
{
dc.Connection.Open();
SqlCommand comm = new SqlCommand(string.Format("{0} FOR XML RAW , ROOT('DataSource'), Elements;", cds.Query), dc.Connection as SqlConnection);
XmlReader reader = comm.ExecuteXmlReader();
if (reader.Read())
{
string data = string.Format("<xsl:stylesheet version=\"1.0\" xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\" xmlns:msxsl=\"urn:schemas-microsoft-com:xslt\" exclude-result-prefixes=\"msxsl\"> <xsl:output method=\"xml\" omit-xml-declaration=\"yes\" /> {0} </xsl:stylesheet>", cds.HtmlTemplate.Trim());
// Load the style sheet.
XslCompiledTransform xslt = new XslCompiledTransform();
XmlReader xmlread = XmlReader.Create(new StringReader(data));
xslt.Load(xmlread);
// Execute the transform and output the results to a file.
StringBuilder builder = new StringBuilder();
XmlWriter xmlOutput = XmlWriter.Create(builder);
xslt.Transform(reader, xmlOutput);
CacheManager.Add(name, builder.ToString(), DateTime.Now.AddDays(2));
return(CacheManager.Get <string>(name));
}
}
}
}
}
return(string.Empty);
}
/// <summary>
/// ObtenirProprietaire
/// </summary>
/// <returns>Le proprietaire</returns>
public int UpdateProprietaire(Proprietaire p, string pPasswordHash)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
if (String.IsNullOrEmpty(pPasswordHash))
{
return maDataSource.ExecuterDML(REQUETE_MODIFIER_PROPRIETAIRE, false, p.Login, p.Nom, p.Prenom, p.Adresse, p.CP, p.Ville, p.Code);
}
else
{
return maDataSource.ExecuterDML(REQUETE_MODIFIER_PROPRIETAIRE_ET_PASSWORD, false, p.Login, p.Nom, p.Prenom, p.Adresse, p.CP, p.Ville, pPasswordHash, p.Code);
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="rdf">传给父类Base2TempTable的构造函数的参数</param>
/// <param name="customDataSource">自定义数据源对象,其作用主要产生和传输临时表名称</param>
/// <param name="dataSourceId">数据引擎中数据源的标识</param>
/// <param name="functionName">数据引擎中数据源的查询函数</param>
/// <param name="filterSrv">过滤条件信息对象</param>
public U8DataEngine2TempTable(
ReportDataFacade rdf,
CustomDataSource customDataSource,
string dataSourceId,
string functionName,
FilterSrv filterSrv,
string extendingDataSourceTempDBName)
: base(rdf, customDataSource)
{
this._filterSrv = filterSrv;
this._u8DataEngineHelper = new U8DataEngineHelper(
dataSourceId,
functionName,
customDataSource.FilterString,
rdf._U8LoginInfor,
extendingDataSourceTempDBName);
this._u8DataEngineHelper.ReadConfigurate();
}
public IHttpActionResult PutCustomDataSource(int id, [FromBody] CustomDataSource ds)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (string.IsNullOrEmpty(ds.Name) || string.IsNullOrEmpty(ds.HtmlTemplate))
{
return(BadRequest("Either name or html template is missing"));
}
try
{
CustomDataSource cds = db.CustomDataSources.FirstOrDefault(t => t.ID == id);
if (cds != null)
{
cds.HtmlTemplate = ds.HtmlTemplate;
cds.Name = ds.Name;
cds.Query = ds.Query;
cds.ModifiedBy = db.Members.FirstOrDefault(d => d.Email == User.Identity.Name);
cds.DateModified = DateTime.Now;
db.Entry(cds).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return(BadRequest("Unable to find data source with this id."));
}
}
catch (DbUpdateConcurrencyException)
{
if (!CustomDataSourceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok());
}
public override void ViewDidLoad()
{
base.ViewDidLoad();
NavigationItem.BackBarButtonItem = new UIBarButtonItem("Back", UIBarButtonItemStyle.Plain, null);
this.Title = "Todo List Info";
UpdateDescriptionStyle();
var save = new UIBarButtonItem(UIBarButtonSystemItem.Save);
var options = new UIBarButtonItem(UIImage.FromBundle("ic_more"), UIBarButtonItemStyle.Done, null);
this.NavigationItem.RightBarButtonItems = new UIBarButtonItem[] { options, save };
var source = new CustomDataSource(this, TableView, new NSString("ToDoItemCell"));
TableView.Source = source;
var set = this.CreateBindingSet <ListInfoView, ViewModels.ListInfoViewModel>();
set.Bind(NavigationItem)
.For(x => x.Title)
.To(vm => vm.Title);
set.Bind(source)
.For(x => x.ItemsSource)
.To(vm => vm.Items);
set.Bind(source)
.For(x => x.SelectionChangedCommand)
.To(vm => vm.CompleteItem);
set.Bind(TitleTextField)
.To(vm => vm.ListTitle);
set.Bind(DescrptionTextView)
.To(vm => vm.ListDescription);
set.Bind(AddButton)
.To(vm => vm.AddNewItem);
set.Bind(save)
.To(vm => vm.SaveList);
set.Bind(options)
.To(vm => vm.ShowOptions);
set.Apply();
}
///// <summary>
///// SupprimerFilm (et exemplaires associés)
///// </summary>
///// <param name="pCode">pCode</param>
//public int SupprimerFilm(Guid pCode)
//{
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début SupprimerFilm");
// CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
// int result = -1;
// try
// {
// maDataSource.StartGlobalTransaction();
// result = maDataSource.ExecuterDML(REQUETE_SUPPRIMER_FILM, false, pCode);
// result = maDataSource.ExecuterDML(REQUETE_SUPPRIMER_EXEMPLAIRE, false, pCode);
// if (result.Equals(1))
// {
// result = maDataSource.ExecuterDML(REQUETE_SUPPRIMER_MEDIA, false, pCode);
// }
// }
// catch (Exception ex)
// {
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
// maDataSource.RollBackGlobalTransaction();
// throw ex;
// }
// finally
// {
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin SupprimerFilm");
// }
// return result;
//}
/// <summary>
/// UpdateFilm
/// </summary>
/// <param name="f">Film</param>
/// <returns></returns>
public int UpdateFilm(Film f)
{
int result = -1;
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
result = maDataSource.ExecuterDML(REQUETE_MODIFICATION_FILM, false, f.Duree,
f.Synopsys, f.Realisateur, f.Acteurs, f.Code);
if (result == 1)
{
result = maDataSource.ExecuterDML(REQUETE_MODIFICATION_MEDIA, false, f.Titre,
f.LeGenre.Code, f.DateSortie, f.Photo, f.UrlFiche, f.PEGI, f.Note, f.Code);
}
if (result == 1)
{
maDataSource.CommitGlobalTransaction();
}
else
{
maDataSource.RollBackGlobalTransaction();
}
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement du film OK");
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin UpdateFilm");
}
return result;
}
/// <summary>
/// ObtenirJeuComplet
/// </summary>
/// <param name="pCode"></param>
/// <returns></returns>
public Jeu ObtenirJeuComplet(Guid pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
Jeu leJeu = maDataSource.ExecuterRequete<Jeu>(REQUETE_OBTENIR_JEU, new JeuRowMapper(), false, pCode);
return leJeu;
}
/// <summary>
/// AjouterEmprunt
/// </summary>
/// <param name="pCodeFilm"></param>
/// <param name="pCodeProprietaire"></param>
/// <param name="pCodeSupport"></param>
/// <param name="pNom"></param>
/// <param name="pPrenom"></param>
public void AjouterEmprunt(Guid pCodeFilm, Guid pCodeProprietaire, String pCodeSupport, Emprunteur pEmprunteur)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début AjouterEmprunt");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
Guid codeEmprunteur;
if (!String.IsNullOrEmpty(pEmprunteur.Nom))
{
codeEmprunteur = Guid.Empty;
}
else
{
codeEmprunteur = pEmprunteur.Code;
ProprietaireDAO proprietaireDAO = new ProprietaireDAO();
Proprietaire p = proprietaireDAO.ObtenirListeProprietaires().Find(item=>item.Code==codeEmprunteur);
pEmprunteur.Nom = p.Nom;
pEmprunteur.Prenom = p.Prenom;
}
maDataSource.ExecuterDML(REQUETE_AJOUTER_EMPRUNT, true, pCodeProprietaire, pCodeFilm, pCodeSupport, codeEmprunteur, pEmprunteur.Nom, pEmprunteur.Prenom, DateTime.Now);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'emprunt OK");
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin AjouterEmprunt");
}
}
/// <summary>
/// UpdateEmprunt
/// </summary>
/// <param name="pCodeFilm"></param>
/// <param name="pCodeProprietaire"></param>
/// <param name="pCodeSupport"></param>
/// <returns></returns>
public int UpdateEmprunt(Guid pCodeFilm, Guid pCodeProprietaire, String pCodeSupport)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_CLORE_EMPRUNT, false, DateTime.Now, pCodeFilm, pCodeProprietaire, pCodeSupport);
}
/// <summary>
/// ObtenirListeFilms
/// </summary>
/// <returns>Liste films</returns>
public List<Proprietaire> ObtenirListeProprietaires()
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterRequeteList<Proprietaire>(REQUETE_OBTENIR_LISTE_PROPRIETAIRES, new ProprietaireRowMapper(), false, null);
}
/// <summary>
/// UpdateFilm
/// </summary>
/// <returns>Liste films</returns>
public int UpdateFilm(Film f)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_MODIFICATION_FILM, false, f.Titre, f.Duree,
f.LeGenre.Code, f.DateSortie, f.Synopsys, f.Jaquette, f.Realisateur, f.Acteurs, f.Note, f.Code);
}
/// <summary>
/// UpdateGenre
/// </summary>
/// <returns>Liste Genres</returns>
public int UpdateGenre(Genre s, string pOldCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_MODIFICATION_GENRE, false, s.Code, s.Libelle, pOldCode);
}
/// <summary>
/// ObtenirListeJeux
/// </summary>
/// <returns>Liste jeux</returns>
public List<Jeu> ObtenirListeJeux()
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterRequeteList<Jeu>(REQUETE_OBTENIR_LISTE_JEUX, new JeuRowMapper(), false, null);
}
/// <summary>
/// ObtenirGenre
/// </summary>
/// <returns>Genre</returns>
public Genre ObtenirGenre(string pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterRequete<Genre>(REQUETE_OBTENIR_GENRE, new GenreRowMapper(), false, pCode);
}
/// <summary>
/// CreerJeuEtSouhait
/// </summary>
/// <param name="pJeu">pJeu</param>
/// <param name="pCodeProprietaire">pCodeProprietaire</param>
/// <returns></returns>
public Jeu CreerJeuEtSouhait(Jeu pJeu, Guid pCodeProprietaire)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début CreerJeuEtSouhait");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
pJeu.Code = Guid.NewGuid();
//TODO : échec
Jeu jeuExistant = maDataSource.ExecuterRequete<Jeu>(REQUETE_EXISTE_JEU, new JeuRowMapper(), false, pJeu.Titre, pJeu.LaMachine.Code);
if (jeuExistant == null)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le jeu n'existe pas, on l'ajoute");
if (!String.IsNullOrEmpty(pJeu.Developpeur.Nom))
{
pJeu.Developpeur = CreerDeveloppeur(maDataSource, pJeu.Developpeur.Nom);
}
else
{
pJeu.Developpeur = new Developpeur();
}
if (!String.IsNullOrEmpty(pJeu.Editeur.Nom))
{
pJeu.Editeur = CreerEditeur(maDataSource, pJeu.Editeur.Nom);
}
else
{
pJeu.Editeur = new Editeur();
}
maDataSource.ExecuterDML(REQUETE_AJOUTER_JEU, true, pJeu.Code, pJeu.Titre,
pJeu.LeGenre.Code, pJeu.DateSortie, pJeu.Synopsys, pJeu.Photo, pJeu.Developpeur.Code, pJeu.Editeur.Code, pJeu.LaMachine.Code, 1, pJeu.Note);
}
else
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le jeu existe déjà");
pJeu.Code = jeuExistant.Code;
}
maDataSource.ExecuterDML(REQUETE_AJOUTER_SOUHAIT_ACHAT, true, pCodeProprietaire, pJeu.Code, null, DateTime.Now);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'exemplaire OK");
return pJeu;
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin CreerJeuEtSouhait");
}
}
/// <summary>
/// AjouterSouhait
/// </summary>
/// <param name="pCodeFilm">pCodeFilm</param>
/// <param name="pCodeSupport">pCodeSupport</param>
/// <param name="pCodeProprietaire">pCodeProprietaire</param>
public void AjouterSouhait(Guid pCodeFilm, string pCodeSupport, Guid pCodeProprietaire)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début AjouterSouhait");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
maDataSource.ExecuterDML(REQUETE_AJOUTER_SOUHAIT, true, pCodeProprietaire, pCodeFilm, pCodeSupport);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'exemplaire OK");
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin AjouterSouhait");
}
}
/// <summary>
/// ObtenirFilm
/// </summary>
/// <param name="pCode">code film</param>
/// <returns>Le film trouvé en base</returns>
public Film ObtenirFilmComplet(Guid pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
Film leFilm = maDataSource.ExecuterRequete<Film>(REQUETE_OBTENIR_FILM, new FilmRowMapper(), false, pCode);
List<Exemplaire> listeExpl = maDataSource.ExecuterRequeteList<Exemplaire>(REQUETE_OBTENIR_LISTE_EXEMPLAIRES_FILM, new ExemplaireFilmRowMapper(), false, pCode);
List<Exemplaire> listeSouhaits = maDataSource.ExecuterRequeteList<Exemplaire>(REQUETE_OBTENIR_LISTE_SOUHAITS_FILM, new ExemplaireFilmRowMapper(), false, pCode);
//On associe le film à chaque exemplaire
foreach (Exemplaire expl in listeExpl) {
expl.LeMedia = leFilm;
}
//On associe le film à chaque exemplaire
foreach (Exemplaire expl in listeSouhaits)
{
expl.LeMedia = leFilm;
}
leFilm.ListeExemplaire = listeExpl;
leFilm.ListeSouhaits = listeSouhaits;
return leFilm;
}
/// <summary>
/// ObtenirFilm
/// </summary>
/// <param name="pCode">code film</param>
/// <returns>Le film trouvé en base</returns>
public Film ObtenirFilm(Guid pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
Film leFilm = maDataSource.ExecuterRequete<Film>(REQUETE_OBTENIR_FILM, new FilmRowMapper(), false, pCode);
return leFilm;
}
/// <summary>
/// InsertGenre
/// </summary>
/// <returns>Liste Genres</returns>
public int InsertGenre(Genre s)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_AJOUTER_GENRE, false, s.Code, s.Libelle);
}
/// <summary>
/// ModifierExemplaire
/// </summary>
/// <param name="pCodeFilm"></param>
/// <param name="pCodeProprietaire"></param>
/// <param name="pCodeSupport"></param>
/// <param name="dateAcquisition"></param>
public void ModifierExemplaire(Guid pCodeFilm, Guid pCodeProprietaire, String pCodeSupport, String pOldCodeSupport, DateTime dateAcquisition)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début ModifierExemplaire");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
maDataSource.ExecuterDML(REQUETE_MODIFIER_EXEMPLAIRE, true, pCodeSupport, dateAcquisition, pCodeProprietaire, pCodeFilm, pOldCodeSupport);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'exemplaire OK");
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin ModifierExemplaire");
}
}
/// <summary>
/// DeleteGenre
/// </summary>
/// <returns>Liste Genres</returns>
public int DeleteGenre(string pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_SUPPRESSION_GENRE, false, pCode);
}
/// <summary>
/// SupprimerSouhait
/// </summary>
/// <param name="pCodeFilm"></param>
/// <param name="pCodeProprietaire"></param>
/// <param name="pCodeSupport"></param>
public void SupprimerSouhait(Guid pCodeFilm, Guid pCodeProprietaire, String pCodeSupport)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
maDataSource.ExecuterDML(REQUETE_SUPPRIMER_SOUHAIT, false, pCodeFilm, pCodeProprietaire, pCodeSupport);
}
///// <summary>
///// AjouterExemplaire
///// </summary>
///// <param name="pCodeFilm"></param>
///// <param name="pCodeSupport"></param>
///// <param name="pCodeProprietaire"></param>
//public void AjouterExemplaire(Guid pCodeFilm, string pCodeSupport, Guid pCodeProprietaire, DateTime pDateAcquisition)
//{
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début AjouterExemplaire");
// CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
// try
// {
// maDataSource.StartGlobalTransaction();
// maDataSource.ExecuterDML(REQUETE_AJOUTER_EXEMPLAIRE, true, pCodeProprietaire, pCodeFilm, pCodeSupport, DateTime.Now, pDateAcquisition);
// maDataSource.CommitGlobalTransaction();
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'exemplaire OK");
// }
// catch (Exception ex)
// {
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
// maDataSource.RollBackGlobalTransaction();
// throw ex;
// }
// finally
// {
// Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin AjouterExemplaire");
// }
//}
/// <summary>
/// ObtenirFilm
/// </summary>
/// <param name="pCode">code film</param>
/// <returns>Le film trouvé en base</returns>
public Film CreerFilmEtExemplaire(Film pFilm, string pCodeSupport, Guid pCodeProprietaire, DateTime pDateAcquisition, int pEtat)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début CreerFilmEtExemplaire");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
if (pFilm.Code.Equals(Guid.Empty)) {
pFilm.Code = Guid.NewGuid();
}
Film filmExistant = maDataSource.ExecuterRequete<Film>(REQUETE_EXISTE_FILM, new FilmRowMapper(), false, pFilm.Titre, pFilm.Realisateur);
if (filmExistant == null)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le film n'existe pas, on l'ajoute");
maDataSource.ExecuterDML(
REQUETE_AJOUTER_MEDIA, true,
pFilm.Code, Constantes.EnumTypeMedia.FILM, pFilm.Titre, pFilm.DateSortie, pFilm.Photo, pFilm.UrlFiche, pFilm.PEGI, pFilm.LeGenre.Code, pFilm.Note);
maDataSource.ExecuterDML(
REQUETE_AJOUTER_FILM, true, pFilm.Code, pFilm.Duree, pFilm.Synopsys, pFilm.Realisateur, pFilm.Acteurs);
}
else
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le film existe déjà");
pFilm.Code = filmExistant.Code;
}
maDataSource.ExecuterDML(REQUETE_AJOUTER_EXEMPLAIRE, true, pCodeProprietaire, pFilm.Code, pEtat, pCodeSupport, DateTime.Now, pDateAcquisition);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement de l'exemplaire OK");
return pFilm;
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin CreerFilmEtExemplaire");
}
}
/// <summary>
/// CreerDeveloppeur
/// </summary>
/// <param name="pDataSource"></param>
/// <param name="pNomDeveloppeur"></param>
/// <returns></returns>
private Developpeur CreerDeveloppeur(CustomDataSource pDataSource, string pNomDeveloppeur)
{
Developpeur developpeur = null;
if (!String.IsNullOrEmpty(pNomDeveloppeur))
{
Developpeur developpeurExistant = pDataSource.ExecuterRequete<Developpeur>(REQUETE_EXISTE_DEVELOPPEUR, new DeveloppeurRowMapper(), false, pNomDeveloppeur);
//Création du développeur
if (developpeurExistant == null)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le développeur n'existe pas, on l'ajoute");
developpeur = new Developpeur();
developpeur.Nom = pNomDeveloppeur;
developpeur.Code = Guid.NewGuid();
pDataSource.ExecuterDML(REQUETE_AJOUTER_DEVELOPPEUR, true, developpeur.Code, developpeur.Nom);
}
else
{
developpeur = developpeurExistant;
}
}
return developpeur;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="rdf">传给父类Base2TempTable的构造函数的参数</param>
/// <param name="customDataSource">自定义数据源的定义</param>
public CustomDataSource2TempTable(
ReportDataFacade rdf,
CustomDataSource customDataSource)
: base(rdf, customDataSource)
{
}
/// <summary>
/// SupprimerFilm (et exemplaires associés)
/// </summary>
/// <param name="pCode">pCode</param>
public void SupprimerFilm(Guid pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
maDataSource.ExecuterDML(REQUETE_SUPPRIMER_FILM, false, pCode);
}
/// <summary>
/// ListeSouhaitsProprietaire
/// </summary>
/// <param name="pCodeProprietaire">Le proprio</param>
/// <returns></returns>
public List<Emprunt> ListeEmpruntsProprietaire(Guid pCodeProprietaire)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début ListeEmpruntsProprietaire");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
List<Emprunt> listeEmprunts = maDataSource.ExecuterRequeteList<Emprunt>(REQUETE_OBTENIR_LISTE_EMPRUNTS_PROPRIETAIRE, new EmpruntFilmRowMapper(), false, pCodeProprietaire);
maDataSource.CommitGlobalTransaction();
return listeEmprunts;
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin ListeEmpruntsProprietaire");
}
}
public void CustomDataSource_Scope_User()
{
var source = new CustomDataSource();
Assert.AreEqual(SettingScopeEnum.User, source.Scope);
}
/// <summary>
/// CreerEditeur
/// </summary>
/// <param name="pDataSource"></param>
/// <param name="pNomEditeur"></param>
/// <returns></returns>
public Editeur CreerEditeur(CustomDataSource pDataSource, string pNomEditeur)
{
Editeur editeur = null;
if (!String.IsNullOrEmpty(pNomEditeur))
{
Editeur editeurExistant = pDataSource.ExecuterRequete<Editeur>(REQUETE_EXISTE_EDITEUR, new EditeurRowMapper(), false, pNomEditeur);
//Création de l'éditeur
if (editeurExistant == null)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "L'éditeur n'existe pas, on l'ajoute");
editeur = new Editeur();
editeur.Nom = pNomEditeur;
editeur.Code = Guid.NewGuid();
pDataSource.ExecuterDML(REQUETE_AJOUTER_EDITEUR, true, editeur.Code, editeur.Nom);
}
else
{
editeur = editeurExistant;
}
}
return editeur;
}
/// <summary>
/// CreerFilmEtSouhait
/// </summary>
/// <param name="pFilm">pFilm</param>
/// <param name="pCodeSupport">pCodeSupport</param>
/// <param name="pCodeProprietaire">pCodeProprietaire</param>
/// <returns></returns>
public Film CreerFilmEtSouhait(Film pFilm, string pCodeSupport, Guid pCodeProprietaire)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début CreerFilmEtSouhait");
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
pFilm.Code = Guid.NewGuid();
Film filmExistant = maDataSource.ExecuterRequete<Film>(REQUETE_EXISTE_FILM, new FilmRowMapper(), false, pFilm.Titre, pFilm.Realisateur);
if (filmExistant == null)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le film n'existe pas, on l'ajoute");
maDataSource.ExecuterDML(REQUETE_AJOUTER_FILM, true, pFilm.Code, pFilm.Titre, pFilm.Duree,
pFilm.LeGenre.Code, pFilm.DateSortie, pFilm.Synopsys, pFilm.Jaquette, pFilm.Realisateur,
pFilm.Acteurs, 1, pFilm.Note, pFilm.UrlFiche);
}
else
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Le film existe déjà");
pFilm.Code = filmExistant.Code;
}
maDataSource.ExecuterDML(REQUETE_AJOUTER_SOUHAIT, true, pCodeProprietaire, pFilm.Code, pCodeSupport);
maDataSource.CommitGlobalTransaction();
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement du souhait OK");
return pFilm;
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin CreerFilmEtSouhait");
}
}
/// <summary>
/// UpdateJeu
/// </summary>
/// <returns>int</returns>
public int UpdateJeu(Jeu pJeu)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Début UpdateJeu");
int result = -1;
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
try
{
maDataSource.StartGlobalTransaction();
pJeu.Developpeur = CreerDeveloppeur(maDataSource, pJeu.Developpeur.Nom);
pJeu.Editeur = CreerEditeur(maDataSource, pJeu.Editeur.Nom);
result = maDataSource.ExecuterDML(REQUETE_MODIFICATION_JEU, false, pJeu.LaMachine.Code,
pJeu.Synopsys, pJeu.Developpeur.Code, pJeu.Editeur.Code, pJeu.NbJoueurs, pJeu.Code);
if (result == 1)
{
result = maDataSource.ExecuterDML(REQUETE_MODIFICATION_MEDIA, false, pJeu.Titre,
pJeu.LeGenre.Code, pJeu.DateSortie, pJeu.Photo, pJeu.UrlFiche, pJeu.PEGI, pJeu.Note, pJeu.Code);
}
if (result == 1)
{
maDataSource.CommitGlobalTransaction();
}
else
{
maDataSource.RollBackGlobalTransaction();
}
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Enregistrement du jeu OK");
}
catch (Exception ex)
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Erreur = " + ex.Message);
maDataSource.RollBackGlobalTransaction();
throw ex;
}
finally
{
Log.MonitoringLogger().Info(KS_NOM_MODULE + "Fin UpdateJeu");
}
return result;
}
/// <summary>
/// ObtenirListeFilms
/// </summary>
/// <returns>Liste films</returns>
public List<Film> ObtenirListeFilms()
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterRequeteList<Film>(REQUETE_OBTENIR_LISTE_FILMS, new FilmRowMapper(), false, null);
}
/// <summary>
/// ObtenirProprietaire
/// </summary>
/// <returns>Le proprietaire</returns>
public int DeleteProprietaire(Guid pCode)
{
CustomDataSource maDataSource = new CustomDataSource(Properties.Settings.Default.CHAINE_CONNEXION);
return maDataSource.ExecuterDML(REQUETE_SUPPRIMER_PROPRIETAIRE, false, pCode);
}
public CustomTableView()
{
RegisterClassForCellReuse(typeof(CustomTableViewCell), MyCellId);
Source = new CustomDataSource();
}