public static bool UpdateApoitment(int id, string update, string result, bool date)
{
var conn = new DataLayer.DataClasses1DataContext();
Activity activity = (from a in conn.Activity
where a.id_act == id
select a).SingleOrDefault();
if (activity != null)
{
if (date == true)
{
activity.dt_fin_cancel = DateTime.Today;
}
else
{
activity.dt_fin_cancel = null;
}
activity.status = update;
activity.result = result;
try
{
conn.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
else
{
return(false);
}
}
public static List <int> AppoitmentsIds(int worker)
{
var conn = new DataLayer.DataClasses1DataContext();
List <int> ids = (from a in conn.Activity
where a.id_pers == worker && (a.status == "opn" || a.status == "pro")
select a.id_act).ToList();
return(ids);
}
public static List <WorkerSection> Appoitments(int worker)
{
var conn = new DataLayer.DataClasses1DataContext();
List <WorkerSection> activity = (from a in conn.Activity
where a.id_pers == worker && (a.status == "opn" || a.status == "pro")
select new WorkerSection(a.id_act, a.seq_name, a.description, a.Request.Object.id_obj, a.Request.Object.name, a.status, a.Activity_Type.act_name)).ToList();
return(activity);
}
public static Personel Login(string uname, string pass)
{
DateTime date = DateTime.Today;
var conn = new DataLayer.DataClasses1DataContext();
try
{
Personel user = (from a in conn.Personel
where a.uname == uname && a.password == MD5Hash(pass) && (a.dt_exp > date || a.dt_exp == null)
select a).SingleOrDefault();
return(user);
}
catch
{
return(null);
}
}