protected void OnDelete(object sender, EventArgs e)
{
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int id = int.Parse((item.FindControl("record_id") as Label).Text);
DataSetTableAdapters.workHoursTableAdapter adapter = new DataSetTableAdapters.workHoursTableAdapter();
adapter.DeleteQuery(id);
repeater_work_hours.DataBind();
}
protected void Insert(object sender, EventArgs e)
{
int worker_id, task_id;
string date, time, comment;
worker_id = int.Parse(ddl_worker2.SelectedValue);
task_id = int.Parse(ddl_task2.SelectedValue);
date = tb_date2.Text.Trim();
time = tb_hours.Text.Trim();
comment = tb_comment.Text.Trim();
DataSetTableAdapters.workHoursTableAdapter adapter = new DataSetTableAdapters.workHoursTableAdapter();
adapter.InsertQuery(worker_id, task_id, date, time, comment);
repeater_work_hours.DataBind();
}
protected void OnUpdate(object sender, EventArgs e)
{
int id, worker_id, task_id;
string date, time, comment;
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
id = int.Parse((item.FindControl("record_id") as Label).Text);
worker_id = int.Parse((item.FindControl("ddl_worker1") as DropDownList).SelectedValue);
task_id = int.Parse((item.FindControl("ddl_task1") as DropDownList).SelectedValue);
date = (item.FindControl("tb_date1") as TextBox).Text;
time = (item.FindControl("tb_edit_total_hours") as TextBox).Text;
comment = (item.FindControl("tb_edit_comment") as TextBox).Text;
DataSetTableAdapters.workHoursTableAdapter adapter = new DataSetTableAdapters.workHoursTableAdapter();
adapter.UpdateQuery(worker_id, task_id, date, time, comment, id);
repeater_work_hours.DataBind();
}
protected void btn_save_Click(object sender, EventArgs e)
{
int worker_id, task_id;
String comments, date, time;
DataSetTableAdapters.workHoursTableAdapter adapter;
worker_id = int.Parse(ddl_worker.SelectedValue);
date = tb_date.Text;
task_id = int.Parse(ddl_task.SelectedValue);
time = string.Format(ddl_minute.SelectedItem.Text.Trim() + ":" + ddl_hour.SelectedItem.Text.Trim());
comments = tb_comment.Text.Trim();
adapter = new DataSetTableAdapters.workHoursTableAdapter();
adapter.InsertQuery(worker_id, task_id, date, time, comments);
Response.Write("<script>alert('הנתונים נשמרו בהצלחה');</script>");
}
