protected void Page_Load(object sender, EventArgs e)
{
int getId;
try {
getId = Convert.ToInt32(Server.UrlDecode(Request.QueryString["id"].ToString()));
employeesDataContextDataContext db = new employeesDataContextDataContext();
var employee = (from a in db.employees where a.id_employee == getId select a).FirstOrDefault(); //get the needed log from db
//fio
string l_name = Convert.ToString(employee.last_name);
l_name = System.Text.RegularExpressions.Regex.Replace(l_name, @"\s+", ""); //remove spaces
string f_name = Convert.ToString(employee.first_name);
f_name = System.Text.RegularExpressions.Regex.Replace(f_name, @"\s+", ""); //remove spaces
//post
int post = Convert.ToInt32(employee.position);
var positions = (from a in db.positions where a.Id_positions == post select a).FirstOrDefault();
string pos_of_emp = Convert.ToString(positions.name_of_position);
Label1.Text = l_name + " " + f_name + ", " + pos_of_emp;
Label2.Text = DateTime.Today.ToShortDateString();
} catch (Exception)
{
getId = 0;
Label1.Text = "";
Label2.Text = "";
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label6.Text = " ";
int CurrentRowIndex = Convert.ToInt32(e.RowIndex);
GridViewRow gvRow = GridView1.Rows[CurrentRowIndex];
employeesDataContextDataContext db = new employeesDataContextDataContext();
//string login = ((gvRow.Cells[0].Controls[0] as TextBox).Text).Trim();
string f_name = ((gvRow.Cells[1].Controls[0] as TextBox).Text).Trim();
string l_name = ((gvRow.Cells[2].Controls[0] as TextBox).Text).Trim();
string position = ((gvRow.Cells[3].Controls[0] as TextBox).Text).Trim();
string faculty = ((gvRow.Cells[4].Controls[0] as TextBox).Text).Trim();
string getIdEmp = ((gvRow.Cells[5].Controls[0] as TextBox).Text).Trim();
int idEmp = Convert.ToInt32(getIdEmp);
employees UpdateEmployee = (from a in db.employees where a.id_employee == idEmp select a).FirstOrDefault();
int idPos = (from b in db.positions where b.name_of_position == position select b.Id_positions).FirstOrDefault();
int idFaculty = (from d in db.faculties where d.name_of_faculty == faculty select d.Id_faculty).FirstOrDefault();
//UpdateEmployee.login = login;
UpdateEmployee.first_name = f_name;
UpdateEmployee.last_name = l_name;
UpdateEmployee.position = idPos;
UpdateEmployee.faculty_id = idFaculty;
db.SubmitChanges();
Label6.Text = "Данные успешно обновлены!";
Label6.CssClass = "msg msg-success";
}
protected void BindGridView()
{
employeesDataContextDataContext db = new employeesDataContextDataContext();
var dataf = from f in db.activities
select new { f.name_of_act, f.Id_activity };
GridView1.DataSource = dataf;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
Label3.Text = null; //for msg
employeesDataContextDataContext db = new employeesDataContextDataContext();
var get_log = (from a in db.employees where a.login == TextBox1.Text select a).FirstOrDefault(); //get the needed log from db
int id;
if (get_log != null)
{
id = get_log.id_employee;
//login
login = Convert.ToString(get_log.login);
login = System.Text.RegularExpressions.Regex.Replace(login, @"\s+", ""); //remove spaces
//psw
string psw = Convert.ToString(get_log.pswd);
psw = System.Text.RegularExpressions.Regex.Replace(psw, @"\s+", ""); //remove spaces
//role
string role = Convert.ToString(get_log.role);
role = System.Text.RegularExpressions.Regex.Replace(role, @"\s+", ""); //remove spaces
if (TextBox1.Text == login && TextBox2.Text == psw)
{
if (role == "admin")
{
//Response.Redirect("/editEmplolyess.aspx");
Response.Redirect("editEmplolyess.aspx?id=" + Server.UrlEncode(id.ToString()));
}
else
{
//Response.Redirect("/workPage.aspx");
Response.Redirect("workPage.aspx?id=" + Server.UrlEncode(id.ToString()));
}
}
else
{
Label3.Text = "Неверный пароль или логин!!!";
Label3.CssClass = "msg msg-error";
TextBox1.Text = null;
TextBox2.Text = null;
}
}
else
{
Label3.Text = "Данный пользователь не зарегистрирован в системе!";
Label3.CssClass = "msg msg-error";
TextBox1.Text = null;
TextBox2.Text = null;
}
}
protected void BindGridView()
{
employeesDataContextDataContext db = new employeesDataContextDataContext();
var dataf = from f in db.employees
join h in db.positions on f.position equals h.Id_positions
join g in db.faculties on f.faculty_id equals g.Id_faculty
select new { f.id_employee, f.first_name, f.last_name, f.login, h.name_of_position, g.name_of_faculty };
GridView1.DataSource = dataf;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Label6.Text = null; //for msg
employeesDataContextDataContext db = new employeesDataContextDataContext();
var get_log = (from a in db.employees where a.login == (TextBox1.Text.Trim()) select a.login).FirstOrDefault(); //get the needed log from db
//login
if (get_log == null)
{
if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "")
{
Label6.Text = "Заполните все поля!";
Label6.CssClass = "msg msg-error";
}
else
{
//create
employees NewEmployee = new employees();
NewEmployee.login = TextBox1.Text;
NewEmployee.pswd = "1234";
NewEmployee.first_name = TextBox2.Text;
NewEmployee.last_name = TextBox3.Text;
NewEmployee.role = "user";
NewEmployee.position = Convert.ToInt32(DropDownList1.SelectedValue);
NewEmployee.faculty_id = Convert.ToInt32(DropDownList2.SelectedValue);
//Insert new record in tblmembers
db.employees.InsertOnSubmit(NewEmployee);
//Update table
db.SubmitChanges();
BindGridView();
Label6.Text = "Пользователь успешно зарегистрирован!";
Label6.CssClass = "msg msg-success";
}
}
else
{
string login = Convert.ToString(get_log);
login = System.Text.RegularExpressions.Regex.Replace(login, @"\s+", ""); //remove spaces
if (login != null)
{
Label6.Text = "Пользователь с таким логином уже зарегистрирован в системе!";
Label6.CssClass = "msg msg-error";
}
}
clearFields();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label6.Text = " ";
int CurrentRowIndex = Convert.ToInt32(e.RowIndex);
GridViewRow gvRow = GridView1.Rows[CurrentRowIndex];
employeesDataContextDataContext db = new employeesDataContextDataContext();
int idEmp = Convert.ToInt32(gvRow.Cells[5].Text);
//Fetch particular member record from table directly with id.
var employeeDetail = (from a in db.employees where a.id_employee == idEmp select a).FirstOrDefault();
db.employees.DeleteOnSubmit(employeeDetail);
db.SubmitChanges();
Label6.Text = "Запись успешно удалена!";
Label6.CssClass = "msg msg-success";
BindGridView();
}
protected void Button1_Click(object sender, EventArgs e)
{
Label6.Text = ""; //for msg
employeesDataContextDataContext db = new employeesDataContextDataContext();
var get_name = (from a in db.activities where a.name_of_act == (TextBox1.Text.Trim()) select a.name_of_act).FirstOrDefault(); //get the needed log from db
//login
if (get_name == null)
{
if (TextBox1.Text == "")
{
Label6.Text = "Заполните все поля!";
Label6.CssClass = "msg msg-error";
}
else
{
//create
activities NewAct = new activities();
NewAct.name_of_act = TextBox1.Text.Trim();
//Insert new record in tblmembers
db.activities.InsertOnSubmit(NewAct);
//Update table
db.SubmitChanges();
BindGridView();
Label6.Text = "Запись успешно добавлена!";
Label6.CssClass = "msg msg-success";
}
}
else
{
Label6.Text = "Данный вид деятельности уже зарегистрирован в системе!";
Label6.CssClass = "msg msg-error";
}
TextBox1.Text = "";
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label6.Text = "";
int CurrentRowIndex = Convert.ToInt32(e.RowIndex);
GridViewRow gvRow = GridView1.Rows[CurrentRowIndex];
employeesDataContextDataContext db = new employeesDataContextDataContext();
string nameOfAct = ((gvRow.Cells[0].Controls[0] as TextBox).Text).Trim();
string getId = ((gvRow.Cells[1].Controls[0] as TextBox).Text).Trim();
int id = Convert.ToInt32(getId);
activities UpdateAct = (from a in db.activities where a.Id_activity == id select a).FirstOrDefault();
UpdateAct.name_of_act = nameOfAct;
db.SubmitChanges();
Label6.Text = "Данные успешно обновлены!";
Label6.CssClass = "msg msg-success";
}
protected void Button3_Click(object sender, EventArgs e) //FINISH
{
if (StartTimeTXT.Text != "")
{
//--------panel
Button2.Enabled = false; //pause locked
Button1.Enabled = true; //start/continue locked
Button1.Text = "Начать работать";
Button1.CssClass = "panel-btn panel-btn--active";
Button2.CssClass = "panel-btn panel-btn--blocked";
startTime = Convert.ToDateTime(StartTimeTXT.Text);
TimeSpan eightT = new TimeSpan(8, 0, 0);
try
{
finishTime = Convert.ToDateTime(PauseTimeTXT.Text);
workTime = TimeSpan.Parse(WorkTimeTXT.Text);
//workTime = new TimeSpan(15, 0, 0);
if (TextBox1.Text == "")
{
throw new Exception("emptyField");
}
//if (workTime > eightT)
//{
// throw new Exception("moreThanEight");
//}
}
catch (Exception eR)
{
if (eR.ToString() == "emptyField")
{
finishTime = getTime();
workTime += finishTime - startTime;
WorkTimeTXT.Text = workTime.ToString("hh':'mm':'ss");//FINISH TIME
TextBox1.Text = "Без названия";
}
//if (eR.ToString() == "moreThanEight")
//{
// workTime = new TimeSpan(8, 0, 0);
//}
}
if (workTime > eightT)
{
workTime = new TimeSpan(8, 0, 0);
}
//TO DATABASE
employeesDataContextDataContext db = new employeesDataContextDataContext();
int id_empl = Convert.ToInt32(Server.UrlDecode(Request.QueryString["id"].ToString()));
schedule NewSchedule = new schedule();
TimeSpan startTimetoDB = TimeSpan.Parse(startTime.ToLongTimeString());
TimeSpan finishTimetoDB = TimeSpan.Parse(finishTime.ToLongTimeString());
DateTime daTEtoDB = DateTime.Today;
NewSchedule.employes_id = id_empl;
NewSchedule.data = daTEtoDB;
NewSchedule.started_to_work_time = startTimetoDB;
NewSchedule.ended_to_work_time = finishTimetoDB;
NewSchedule.activity_id = Convert.ToInt32(DropDownList1.Text);
NewSchedule.work_hours = workTime;
NewSchedule.name_of_theme = TextBox1.Text;
//Insert new record in tblmembers
db.schedule.InsertOnSubmit(NewSchedule);
//Update table
db.SubmitChanges();
//reset TXT
StartTimeTXT.Text = "";
PauseTimeTXT.Text = "";
WorkTimeTXT.Text = "";
//-------lecture+activity
DropDownList1.Enabled = true;
DropDownList1.SelectedIndex = 0;
TextBox1.Enabled = true;
TextBox1.Text = "";
}
}
