public IQueryable <TDataObject> GetMany()
{
var entities = Repository.Get(null, null, false);
var _objs = SFactory.ListMappingEntitiesToObjects(entities);
return(_objs);
}
public PaginationExtension <TDataObject> SearchPaginate(int pageSize, int page)
{
var entities = Repository.Get(null, x => x.OrderBy(r => r.CreatedDate), false);
var _objs = SFactory.ListMappingEntitiesToObjects(entities);
int Count = entities.Count();
_objs = _objs.Skip((page - 1) * pageSize).Take(pageSize);
int totalPages = (int)Math.Ceiling(Count / (double)pageSize);
int itemEnd = pageSize * page;
int itemStart = (itemEnd - pageSize) + 1;
if (itemEnd > Count)
{
itemEnd = Count;
}
var msg = string.Format("Showing {0} to {1} of {2} Records | Total Pages: {3}",
itemStart, itemEnd, Count, totalPages);
var extension = new PaginationExtension <TDataObject>();
extension.Summary = Count > 0 ? msg : string.Empty;
extension.TotalCount = Count;
extension.ReturnedList = _objs;
extension.StaticPagedList = new StaticPagedList <TDataObject>(_objs, page, pageSize, Count);
return(extension);
}
/// <summary>
/// Ejecuta una instruccion SQL nativa mediante una nueva session
/// </summary>
/// <param name="query"></param>
public void SQLNativeExecute(string query)
{
ISession sess = null;
ITransaction trans = null;
try
{
sess = SFactory.OpenSession();
trans = sess.BeginTransaction();
IDbCommand command = sess.Connection.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw new Exception(ex.Message);
}
finally
{
sess.Close();
}
}
public IList HQLSelect(string query)
{
ISession sess = SFactory.OpenSession();
ITransaction trans = sess.BeginTransaction();
IList results;
try
{
results = sess.CreateQuery(query).List();
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw new Exception(ex.Message);
}
finally
{
sess.Close();
}
return(results);
}
public TDataObject GetSingle(Guid id)
{
TEntity _entity = Repository.GetById(id);
var _obj = SFactory.SingleMappingEntityToObject(_entity);
return(_obj);
}
public string GetPlace(string token, int id, Culture culture = Culture.En, bool details = false)
{
if (!CheckToken(token))
{
return(null);
}
return(ToJson(SFactory.Create(HttpContext, DataManager.Places.GetPlace(id), culture, details)));
}
public string GetPlaces(string token, int?regionId = null, int offset = 0, int count = 20, string search = null, Culture culture = Culture.En, Order order = Order.Default, bool details = false)
{
if (!CheckToken(token))
{
return(null);
}
return(ToJson(SFactory.Create(HttpContext, DataManager.Places.GetPlaces(regionId, offset, count, search, culture, order: order), culture, details)));
}
public string GetUserBookmarks(string token, int userId, int offset = 0, int count = 20, string search = null, Culture culture = Culture.En, bool details = false)
{
if (!CheckToken(token))
{
return(null);
}
return(ToJson(SFactory.Create(HttpContext, DataManager.Routes.GetUserBookmarks(userId, offset, count, search, culture), culture, details)));
}
private void LesProjets_Load(object sender, EventArgs e)
{
ComboProjet.DisplayMember = "display";
ComboProjet.ValueMember = "value";
foreach (SBProjet P in SFactory.GetServiceProjet().GetProjects())
{
ComboProjet.Items.Add(new { display = P.Nom, value = P.Id });
}
}
public string GetRegion(string token, int id, Culture culture = Culture.En, bool details = false)
{
if (!CheckToken(token))
{
return(null);
}
var region = DataManager.Regions.GetRegion(id);
return(ToJson(SFactory.Create(HttpContext, region, culture, details)));
}
public string GetRegions(string token, int?countryId = null, int offset = 0, int count = 20, string search = null, Culture culture = Culture.En, Order order = Order.Default, bool details = false)
{
if (!CheckToken(token))
{
return(null);
}
var regions = DataManager.Regions.GetRegions(countryId, offset, count, culture, search, order);
return(ToJson(SFactory.Create(HttpContext, regions, culture, details)));
}
private void AddJalon_Load(object sender, EventArgs e)
{
ResponsableProjet.DisplayMember = "display";
ResponsableProjet.ValueMember = "value";
foreach (Bean.SBResponsable Res in SFactory.GetServiceResponsable().GetResponsables())
{
ResponsableProjet.Items.Add(new { display = Res.Trigramme, value = Res.Id });
}
}
private void ComboProjet_SelectedIndexChanged(object sender, EventArgs e)
{
SBProjet projet = SFactory.GetServiceProjet().GetById((ComboProjet.SelectedItem as dynamic).value);
this.Tag = projet.Id;
LabelIdPrj.Text = projet.Id;
LabelNomPrj.Text = projet.Nom;
LabelRespProjet.Text = SFactory.GetServiceResponsable().GetById(projet.Responsable).Trigramme;
LabelDebutPrj.Text = projet.Debut.ToShortDateString();
}
public TDataObject Create(TDataObject obj)
{
var entity = SFactory.SingleMappingObjectToEntity(obj);
entity.Id = Guid.NewGuid();
entity.CreatedDate = DateTime.Now;
Repository.Insert(entity: entity);
var _resp = SFactory.SingleMappingEntityToObject(entity);
return(_resp);
}
public Task <TDataObject> CreateAsync(TDataObject obj)
{
return(Task.Run(() =>
{
var entity = SFactory.SingleMappingObjectToEntity(obj);
entity.Id = Guid.NewGuid();
TEntity result = Repository.Insert(entity: entity);
var _resp = SFactory.SingleMappingEntityToObject(result);
return _resp;
}));
}
private void BtnValider_Click(object sender, EventArgs e)
{
if (checkBoxFonctionnel.Checked)
{
SFactory.GetServiceExigence().AddExigence(TextboxLabel.Text, 0, (comboBoxType.SelectedItem as dynamic).value, this.Owner.Tag.ToString());
}
else
{
SFactory.GetServiceExigence().AddExigence(TextboxLabel.Text, 1, -1, this.Owner.Tag.ToString());
}
this.Close();
}
private void BtnValider_Click(object sender, EventArgs e)
{
DateTime LaDate = new DateTime(CalendarJalon.SelectionRange.Start.Year, CalendarJalon.SelectionRange.Start.Month, CalendarJalon.SelectionRange.Start.Day);
if (TextBoxResponsable.Text != "")
{
int identifiant = SFactory.GetServiceResponsable().AddResposable(TextBoxResponsable.Text);
SFactory.GetServiceJalon().AddJalon(TextboxLabel.Text, LaDate, identifiant);
}
else
{
SFactory.GetServiceJalon().AddJalon(TextboxLabel.Text, LaDate, (ResponsableProjet.SelectedItem as dynamic).value);
}
}
private void BtnValider_Click(object sender, EventArgs e)
{
DateTime LaDate = new DateTime(CalendarProject.SelectionRange.Start.Year, CalendarProject.SelectionRange.Start.Month, CalendarProject.SelectionRange.Start.Day);
if (TextBoxResponsable.Text != "")
{
int identifiant = SFactory.GetServiceResponsable().AddResposable(TextBoxResponsable.Text);
SFactory.GetServiceProjet().UpdateProjet(IdProjet.Text, ProjectName.Text, identifiant, LaDate);
}
else
{
SFactory.GetServiceProjet().UpdateProjet(IdProjet.Text, ProjectName.Text, (ResponsableProjet.SelectedItem as dynamic).value, LaDate);
}
this.Close();
}
private void ModifProjet_Load(object sender, EventArgs e)
{
ResponsableProjet.DisplayMember = "display";
ResponsableProjet.ValueMember = "value";
foreach (Bean.SBResponsable Res in SFactory.GetServiceResponsable().GetResponsables())
{
ResponsableProjet.Items.Add(new { display = Res.Trigramme, value = Res.Id });
}
Bean.SBProjet P = SFactory.GetServiceProjet().GetById(this.Owner.Tag.ToString());
IdProjet.Text = P.Id;
ProjectName.Text = P.Nom;
CalendarProject.SetDate(P.Debut);
ResponsableProjet.SelectedIndex = ResponsableProjet.FindStringExact(SFactory.GetServiceResponsable().GetById(P.Responsable).Trigramme);
}
private void BtnValider_Click(object sender, EventArgs e)
{
DateTime LaDate = new DateTime(CalendarProject.SelectionRange.Start.Year, CalendarProject.SelectionRange.Start.Month, CalendarProject.SelectionRange.Start.Day);
if (TextBoxResponsable.Text != "")
{
int identifiant = SFactory.GetServiceResponsable().AddResposable(TextBoxResponsable.Text);
SFactory.GetServiceTache().AddTache(TextboxLabel.Text, richTextBox1.Text, -1, (comboBox1.SelectedItem as dynamic).value, Convert.ToInt32(numericUpDown1.Value), (comboBox2.SelectedItem as dynamic).value, 0, LaDate);
}
else
{
SFactory.GetServiceTache().AddTache(TextboxLabel.Text, richTextBox1.Text, (ResponsableProjet.SelectedItem as dynamic).value, (comboBox1.SelectedItem as dynamic).value, Convert.ToInt32(numericUpDown1.Value), (comboBox2.SelectedItem as dynamic).value, 0, LaDate);
}
this.Close();
}
static StringBuilder GetSpawnFactoryJson(SpawnFactory pFactory, ref StringBuilder pResources)
{
StringBuilder aFactoryComponents = new StringBuilder();
GSprite aSprite = new GSprite(pFactory.mDisplaySprite.rect, pFactory.mTextureGUID,
pFactory.mDisplaySprite.texture.height, (int)pFactory.mRenderLayer);
SaveAssetData(GetAssetFromGUID(pFactory.mTextureGUID, AssetMetaData.AssetType.TextureAsset), ref pResources);
aFactoryComponents.Append(aSprite.ToString() + ",\n");
GPolygonCollider aCollider = new GPolygonCollider(pFactory.mIsTrigger);
aFactoryComponents.Append(aCollider.ToString() + ",\n");
SFactory aFactory = new SFactory(pFactory.mEnemyGUID, pFactory.mPoolCount, pFactory.mSpawnTime);
SaveEnemyPrefab(GetAssetFromGUID(pFactory.mEnemyGUID, AssetMetaData.AssetType.PrefabAsset), ref pResources);
aFactoryComponents.Append(aFactory.ToString());
return(aFactoryComponents);
}
private void button9_Click(object sender, EventArgs e)
{
string message = "Voulez-vous vraiment supprimer cette exigence ?";
string caption = "Suppression";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
// Closes the parent form.
SFactory.GetServiceExigence().DeleteExigence((GridExigence.CurrentRow.DataBoundItem as SBExigences).Id);
}
}
private void AddExigence_Load(object sender, EventArgs e)
{
if (SFactory.GetServiceType().count() == 0)
{
SFactory.GetServiceType().AddTypeExigence("Données");
SFactory.GetServiceType().AddTypeExigence("Performances");
SFactory.GetServiceType().AddTypeExigence("Interfaces utilisateur");
SFactory.GetServiceType().AddTypeExigence("Qualité");
SFactory.GetServiceType().AddTypeExigence("Services");
}
comboBoxType.DisplayMember = "display";
comboBoxType.ValueMember = "value";
foreach (SBTypeExigence Type in SFactory.GetServiceType().GetType())
{
comboBoxType.Items.Add(new { display = Type.Label, value = Type.Id });
}
}
/// <summary>
/// Abre una sesión
/// </summary>
/// <returns>Código de session</returns>
///
public int OpenSession()
{
int pos = 0;
ISession sess = SFactory.OpenSession();
// Buscamos la primera posicion vacía
foreach (ISession session in Sessions)
{
if (session == null)
{
Sessions.RemoveAt(pos);
break;
}
pos++;
}
Sessions.Insert(pos, sess);
return(pos);
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
switch (tabControl1.SelectedTab.Name)
{
case "tabExigence":
if (this.Tag != null)
{
List <SBExigences> LesExigence = SFactory.GetServiceExigence().GetExigencesByProjet(this.Tag.ToString());
SourceExigence.DataSource = LesExigence;
GridExigence.DataSource = SourceExigence;
}
break;
case "tabJalon":
if (this.Tag != null)
{
List <SBJalon> LesJalons = SFactory.GetServiceJalon().GetJalons();
SourceJalon.DataSource = LesJalons;
GridJalon.DataSource = SourceJalon;
}
break;
case "tabTache":
if (this.Tag != null)
{
List <SBTache> LesTache = SFactory.GetServiceTache().GetTaches();
SourceTache.DataSource = LesTache;
GridTache.DataSource = SourceTache;
}
break;
}
}
/*public IList SQLNativeSelect(string query, Type type)
* {
* ISession sess = SFactory.OpenSession();
* ITransaction trans = sess.BeginTransaction();
* IList results = null;
*
* try
* {
* IQuery nHQ = sess.CreateSQLQuery(query)
* .SetResultTransformer(Transformers.AliasToBean(type));
*
* results = nHQ.List();
*
* trans.Commit();
* }
* catch (Exception ex)
* {
* if (trans != null) trans.Rollback();
* throw new Exception(ex.Message);
* }
* finally
* {
* sess.Close();
* }
*
* return results;
* }*/
/// <summary>
/// Ejecuta una consulta SQL nativa mediante una nueva session
/// </summary>
/// <param name="query"></param>
public IDataReader SQLNativeSelect(string query)
{
ISession sess = null;
ITransaction trans = null;
//System.Object values;
try
{
sess = SFactory.OpenSession();
trans = sess.BeginTransaction();
IDbCommand command = sess.Connection.CreateCommand();
command.CommandText = query;
IDataReader list = command.ExecuteReader();
trans.Commit();
//IDataRecord rec;
//rec.GetValues(values);
return(list);
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
sess.Close();
}
}
public void HQLExecute(string query, Type type)
{
ISession sess = SFactory.OpenSession();
ITransaction trans = sess.BeginTransaction();
try
{
IQuery nHQ = sess.CreateSQLQuery(query).AddEntity(type);
nHQ.UniqueResult();
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw new Exception(ex.Message);
}
finally
{
sess.Close();
}
}
private void BtnValider_Click(object sender, EventArgs e)
{
SFactory.GetServiceProjet().DeleteProjet(this.Owner.Tag.ToString());
this.Close();
}
