protected void Page_Load(object sender, EventArgs e)
{
using (VactionsystemEntities db = new VactionsystemEntities())
{
int x = Convert.ToInt32(Session["user"].ToString());
//var getrequst = db.vactions.Where(u => u.User.parent == x || u.userid == x).ToList();
var getrequst = (from a in db.vactions join b in db.Users on a.userid equals b.UserId where a.User.parent == x || a.userid == x select new
{ b.UserName, a.vac_from, a.vac_to, a.Returning, a.duratin, a.submissiondate }).ToList();
GridView1.DataSource = getrequst;
GridView1.DataBind();
}
}
public void filldata(string user)
{
using (VactionsystemEntities db = new VactionsystemEntities())
{
int x = Convert.ToInt32(user);
var use = db.Users.Where(s => s.UserId == x).FirstOrDefault();
////////////////////////////////////
Label1.Text = DateTime.Now.ToString();
TextBox1.Text = use.UserName;
TextBox2.Text = use.postion;
TextBox3.Text = use.department.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
VactionsystemEntities u = new VactionsystemEntities();
int x = Convert.ToInt32(Session["user"].ToString());
var use = u.vactioncridits.Where(s => s.userid == x).FirstOrDefault();
if (use == null)
{
Label3.Text = "You not have vacation cridit";
}
else
{
if (float.Parse(Label2.Text) <= use.cridiet)
{
using (VactionsystemEntities db = new VactionsystemEntities())
{
vaction vac = new vaction();
vac.userid = Convert.ToInt32(Session["user"].ToString());
vac.duratin = Convert.ToInt32(Label2.Text);
vac.Returning = Convert.ToDateTime(TextBox4.Text);
vac.vac_from = Convert.ToDateTime(date1.Text);
vac.vac_to = Convert.ToDateTime(date2.Text);
vac.submissiondate = DateTime.Now;
vac.notes = TextBox5.Text;
db.vactions.Add(vac);
db.SaveChanges();
Label3.Text = "Done";
}
use.cridiet = (use.cridiet - float.Parse(Label2.Text));
// u.vactioncridits.Add(use);
u.SaveChanges();
}
else
{
Label3.Text = "Vacation is more then your cridit";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = TextBox1.Text;
string password = TextBox2.Text;
if (username == "")
{
Label1.Text = "insert username";
}
else
{
if (password == "")
{
Label1.Text = "insert username";
}
else
{
using (VactionsystemEntities db = new VactionsystemEntities())
{
var log = db.Users.Where(u => u.user_name == username && u.password == password).FirstOrDefault();
if (log == null)
{
HttpContext.Current.Response.Redirect("~/vacationforms/login.aspx");
Label1.Text = "";
}
else
{
Session["log"] = log.userrole;
Session["user"] = log.UserId;
HttpContext.Current.Response.Redirect("~/vacationforms/createacation.aspx");
Label1.Text = "";
}
}
}
}
}
