protected void btnSave_Click(object sender, EventArgs e)
{
foreach (DataListItem item in dlEmployee.Items)
{
DropDownList ddlcheckin, ddlcheckout;
CheckBox chkIsLeave;
TextBox txtAnnual, txtSick, txtOther;
chkIsLeave = (CheckBox)item.FindControl("chkIsLeave");
txtAnnual = (TextBox)item.FindControl("txtAnnualLeave");
txtSick = (TextBox)item.FindControl("txtSickLeave");
txtOther = (TextBox)item.FindControl("txtOtherLeave");
ddlcheckin = (DropDownList)item.FindControl("ddlCheckIn");
ddlcheckout = (DropDownList)item.FindControl("ddlCheckOut");
HiddenField empNum = (HiddenField)item.FindControl("employeeNum");
tblReservationTime entity = new tblReservationTime();
entity.workdate = (DateTime)DateSelector1.DateValue;
entity.checkinTime = ddlcheckin.SelectedItem.Text;
entity.checkoutTime = ddlcheckout.SelectedItem.Text;
entity.employeeNum = empNum.Value;
entity.isLeave = chkIsLeave.Checked;
entity.AnnualLeave = txtAnnual.Text.Trim();
entity.SickLeave = txtSick.Text.Trim();
entity.OtherLeave = txtOther.Text.Trim();
rh.saveReservationTime(entity);
}
this.ShowSavaOK("");
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (RepeaterItem Item in rptEmp.Items)
{
DropDownList ddlcheckin, ddlcheckout;
CheckBox chkIsLeave, chkSel;
TextBox txtAnnual, txtSick, txtOther;
chkIsLeave = (CheckBox)Item.FindControl("chkIsLeave");
chkSel = (CheckBox)Item.FindControl("chkSel");
txtAnnual = (TextBox)Item.FindControl("txtAnnualLeave");
txtSick = (TextBox)Item.FindControl("txtSickLeave");
txtOther = (TextBox)Item.FindControl("txtOtherLeave");
ddlcheckin = (DropDownList)Item.FindControl("ddlCheckIn");
ddlcheckout = (DropDownList)Item.FindControl("ddlCheckOut");
HiddenField empNum = (HiddenField)Item.FindControl("employeeNum");
//---add work store field
//-- 如果選擇了,就是該分店的當天上班的員工. 員工每天上班的分店是不固定的
if (chkSel.Checked)
{
tblReservationTime entity = new tblReservationTime();
entity.workdate = (DateTime)DateSelector1.DateValue;
entity.checkinTime = ddlcheckin.SelectedItem.Text;
entity.checkoutTime = ddlcheckout.SelectedItem.Text;
entity.employeeNum = empNum.Value;
entity.isLeave = chkIsLeave.Checked;
entity.AnnualLeave = txtAnnual.Text.Trim();
entity.SickLeave = txtSick.Text.Trim();
entity.OtherLeave = txtOther.Text.Trim();
entity.workStore = ddlStoreNum.SelectedValue;
rh.saveReservationTime(entity);
}
}
this.ShowSavaOK("");
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (DataListItem item in dlEmployee.Items)
{
DropDownList ddlcheckin, ddlcheckout;
CheckBox chkIsLeave;
TextBox txtAnnual, txtSick, txtOther;
chkIsLeave = (CheckBox)item.FindControl("chkIsLeave");
txtAnnual = (TextBox)item.FindControl("txtAnnualLeave");
txtSick = (TextBox)item.FindControl("txtSickLeave");
txtOther = (TextBox)item.FindControl("txtOtherLeave");
ddlcheckin = (DropDownList)item.FindControl("ddlCheckIn");
ddlcheckout = (DropDownList)item.FindControl("ddlCheckOut");
HiddenField empNum = (HiddenField)item.FindControl("employeeNum");
tblReservationTime entity = new tblReservationTime();
entity.workdate = (DateTime)DateSelector1.DateValue;
entity.checkinTime = ddlcheckin.SelectedItem.Text;
entity.checkoutTime = ddlcheckout.SelectedItem.Text;
entity.employeeNum = empNum.Value;
entity.isLeave = chkIsLeave.Checked;
entity.AnnualLeave = txtAnnual.Text.Trim();
entity.SickLeave = txtSick.Text.Trim();
entity.OtherLeave = txtOther.Text.Trim();
rh.saveReservationTime(entity);
}
this.ShowSavaOK("");
}
public tblReservationTime saveReservationTime(tblReservationTime entity)
{
if (dataCtx.Connection != null)
{
dataCtx.Connection.Open();
}
DbTransaction tran = dataCtx.Connection.BeginTransaction();
dataCtx.Transaction = tran;
try
{
var qry = from t in ReservationTimes
where t.employeeNum == entity.employeeNum &&
t.workdate == entity.workdate
select t;
var obj = qry.SingleOrDefault();
if (obj != null)
{
//pk identity can't update
//this.CopyEntity(obj, entity);
obj.checkinTime = entity.checkinTime;
obj.checkoutTime = entity.checkoutTime;
obj.isLeave = entity.isLeave;
obj.AnnualLeave = entity.AnnualLeave;
obj.SickLeave = entity.SickLeave;
obj.OtherLeave = entity.OtherLeave;
obj.workOffice = entity.workOffice;
}
else
{
this.ReservationTimes.InsertOnSubmit(entity);
}
this.dataCtx.SubmitChanges();
tran.Commit();
return(obj);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
dataCtx.Connection.Close();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (RepeaterItem Item in rptEmp.Items)
{
DropDownList ddlcheckin, ddlcheckout;
CheckBox chkIsLeave,chkSel;
TextBox txtAnnual, txtSick, txtOther;
chkIsLeave = (CheckBox)Item.FindControl("chkIsLeave");
chkSel = (CheckBox)Item.FindControl("chkSel");
txtAnnual = (TextBox)Item.FindControl("txtAnnualLeave");
txtSick = (TextBox)Item.FindControl("txtSickLeave");
txtOther = (TextBox)Item.FindControl("txtOtherLeave");
ddlcheckin = (DropDownList)Item.FindControl("ddlCheckIn");
ddlcheckout = (DropDownList)Item.FindControl("ddlCheckOut");
HiddenField empNum = (HiddenField)Item.FindControl("employeeNum");
//---add work store field
//-- 如果選擇了,就是該分店的當天上班的員工. 員工每天上班的分店是不固定的
if (chkSel.Checked)
{
tblReservationTime entity = new tblReservationTime();
entity.workdate = (DateTime)DateSelector1.DateValue;
entity.checkinTime = ddlcheckin.SelectedItem.Text;
entity.checkoutTime = ddlcheckout.SelectedItem.Text;
entity.employeeNum = empNum.Value;
entity.isLeave = chkIsLeave.Checked;
entity.AnnualLeave = txtAnnual.Text.Trim();
entity.SickLeave = txtSick.Text.Trim();
entity.OtherLeave = txtOther.Text.Trim();
entity.workStore = ddlStoreNum.SelectedValue;
rh.saveReservationTime(entity);
}
}
this.ShowSavaOK("");
}
public tblReservationTime saveReservationTime(tblReservationTime entity)
{
if (dataCtx.Connection != null) dataCtx.Connection.Open();
DbTransaction tran = dataCtx.Connection.BeginTransaction();
dataCtx.Transaction = tran;
try
{
var qry = from t in ReservationTimes
where t.employeeNum == entity.employeeNum
&& t.workdate == entity.workdate
select t;
var obj = qry.SingleOrDefault();
if (obj != null)
{
//pk identity can't update
//this.CopyEntity(obj, entity);
obj.checkinTime = entity.checkinTime;
obj.checkoutTime = entity.checkoutTime;
obj.isLeave = entity.isLeave;
obj.AnnualLeave = entity.AnnualLeave;
obj.SickLeave = entity.SickLeave;
obj.OtherLeave = entity.OtherLeave;
obj.workOffice = entity.workOffice;
}
else
this.ReservationTimes.InsertOnSubmit(entity);
this.dataCtx.SubmitChanges();
tran.Commit();
return obj;
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
dataCtx.Connection.Close();
}
}
