/// <summary>
/// Retourne un Societe par son id
/// </summary>
/// <param name="id"></param>
/// <returns>client</returns>
public Societe GetSocieteById(int id)
{
Societe societe;
using (var db = new modelEntities1())
{
societe = db.Societe.First(c => c.Id == id);
}
return(societe);
}
/// <summary>
/// Retourne un client par son nom
/// </summary>
/// <param name="nom"></param>
/// <returnsSociete>client</returns>
public Societe GetSocieteByNom(string nom)
{
Societe societe;
using (var db = new modelEntities1())
{
societe = db.Societe.First(c => c.Nom == nom);
}
return(societe);
}
/// Retourne tous les clients
/// </summary>
/// <returns>liste de clients</returns>
public List <Societe> GetAllSocietes()
{
List <Societe> societes;
using (var db = new modelEntities1())
{
societes = db.Societe.ToList();
}
return(societes);
}
/// <summary>
/// Retourne un Societe par son id
/// </summary>
/// <param name="id"></param>
/// <returns>client</returns>
public Societe GetSocieteByGuId(Guid guid)
{
Societe societe;
var stringGuid = guid.ToString();
using (var db = new modelEntities1())
{
societe = db.Societe.First(c => c.Guid == stringGuid);
}
return(societe);
}
public bool Del(int id)
{
var societe = GetSocieteById(id);
using (var db = new modelEntities1())
{
db.Societe.Attach(societe);
db.Societe.Remove(societe);
db.SaveChanges();
return(true);
}
}
public void Update(Societe societe)
{
using (var db = new modelEntities1())
{
var original = db.Societe.Find(societe.Id);
if (original != null)
{
db.Entry(original).CurrentValues.SetValues(societe);
db.SaveChanges();
}
}
}
public ActionResult Hirelogin(hirer h)
{
if (ModelState.IsValid) // this is check validity
{
using (modelEntities1 dc = new modelEntities1())
{
var v = dc.hirers.Where(a => a.hmailid.Equals(h.hmailid) && a.hpwd.Equals(h.hpwd)).FirstOrDefault();
if (v != null)
{
Session["LogedUserID"] = v.hfname.ToString();
Session["LogedUserFullname"] = v.hlname.ToString();
return(RedirectToAction("HirerPage"));
}
}
}
return(View(h));
}
public ActionResult Login(user u)
{
if (ModelState.IsValid) // this is check validity
{
using (modelEntities1 dc = new modelEntities1())
{
var v = dc.users.Where(a => a.mailid.Equals(u.mailid) && a.pwd.Equals(u.pwd)).FirstOrDefault();
if (v != null)
{
Session["LogedUserID"] = v.fname.ToString();
Session["LogedUserFullname"] = v.lname.ToString();
return(RedirectToAction("WorkerPage"));
}
}
}
return(View(u));
}
public Societe Add(Societe c)
{
var newSociete = new Societe
{
//Id = c.Id,
Nom = c.Nom,
Guid = c.Guid,
CodePostal = c.CodePostal,
AdresseLigne1 = c.AdresseLigne1,
AdresseLigne2 = c.AdresseLigne2,
Ville = c.Ville,
};
using (var db = new modelEntities1())
{
db.Societe.Add(newSociete);
db.SaveChanges();
}
return(newSociete);
}
