public double?ObtenirPrixSeance(int?id)
{
if (id != null)
{
double result = 0;
H15_PROJET_E03Entities dataContext = new H15_PROJET_E03Entities();
var query = from Seances in dataContext.Seances
where Seances.SeanceId == id
select Seances.Forfait.Prix;
string prixSeance = "";
foreach (var asfa in query)
{
prixSeance = asfa.ToString();
}
if (!double.TryParse(prixSeance, out result))
{
return(null);
}
return(result);
}
return(null);
}
// GET: Agents/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Agent agent = unitOfWork.AgentRepository.ObtenirAgentParID(id);
if (agent == null)
{
return(HttpNotFound());
}
ViewModels.AgentRapport rapport = new ViewModels.AgentRapport();
List <usp_ProduireRapportAgent_Result> lstRapport = new List <usp_ProduireRapportAgent_Result>();
H15_PROJET_E03Entities context = new H15_PROJET_E03Entities();
using (context)
{
var result = context.usp_ProduireRapportAgent(id, DateTime.Now.Year);
foreach (var item in result)
{
lstRapport.Add(item);
}
rapport.RapportAgent = lstRapport;
rapport.Agent = agent;
}
double?prixTotal = 0;
foreach (var item in rapport.RapportAgent)
{
Seance sea = unitOfWork.SeanceRepository.ObtenirSeanceparDate(item.DateSeance.Value);
prixTotal += unitOfWork.SeanceRepository.ObtenirCoutTotal(sea.SeanceId);
}
ViewBag.prixTotal = prixTotal;
return(View(rapport));
}
public ActionResult Rapport(int?id)
{
H15_PROJET_E03Entities context = new H15_PROJET_E03Entities();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Agence age = unitOfWork.AgenceRepository.ObtenirAgenceParID(id);
if (age == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <usp_ProduireRapportAgence_Result> lstResults = new List <usp_ProduireRapportAgence_Result>();
ViewBag.nomAgence = unitOfWork.AgenceRepository.GetByID(id).Nom;
ViewBag.agenceId = id;
return(View(lstResults));
}
public string[] ObtenirExtra(int?id)
{
H15_PROJET_E03Entities dataContext = new H15_PROJET_E03Entities();
var query = from Seances in dataContext.Seances
where Seances.SeanceId == id
select Seances.Extras;
string[] tabExtra;
if (query != null)
{
foreach (var extra in query)
{
if (extra != null)
{
tabExtra = extra.Split('|');
return(tabExtra);
}
}
}
return(null);
}
public ActionResult Rapport(int id, FormCollection formCollection)
{
H15_PROJET_E03Entities context = new H15_PROJET_E03Entities();
List <usp_ProduireRapportAgence_Result> lstResults = new List <usp_ProduireRapportAgence_Result>();
string anneeString = formCollection["Année"];
string moisString = formCollection["Mois"];
int?annee;
int?mois;
if (anneeString == null || anneeString == "")
{
annee = null;
}
else
{
try
{
annee = int.Parse(anneeString);
}
catch
{
annee = null;
}
}
if (moisString == null || moisString == "")
{
mois = null;
}
else
{
try
{
mois = int.Parse(moisString);
}
catch
{
mois = null;
}
}
if (annee != null && mois != null)
{
using (context)
{
var result = context.usp_ProduireRapportAgence(id, annee, mois);
foreach (var item in result)
{
lstResults.Add(item);
}
DateTime dateDemandee = new DateTime(annee.Value, mois.Value, 1);
ViewBag.date = dateDemandee;
ViewBag.agenceId = id;
ViewBag.annee = annee;
ViewBag.mois = mois;
ViewBag.nomAgence = unitOfWork.AgenceRepository.GetByID(id).Nom;
return(View(lstResults));
}
}
return(RedirectToAction("Rapport"));
}
public AgenceRepository(H15_PROJET_E03Entities context) : base(context)
{
}
public ProprieteRepository(H15_PROJET_E03Entities context) : base(context)
{
}
public PhotoRepository(H15_PROJET_E03Entities context) : base(context)
{
}
public ForfaitRepository(H15_PROJET_E03Entities context) : base(context)
{
}
public GenericRepository(H15_PROJET_E03Entities context)
//public GenericRepository(GestionPhotoImmobilierEntities1 context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
