protected void Add_ShiftUpdate(object sender, EventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
Shift objShift_Data = new Shift();
AdminBLL ws = new AdminBLL();
AdminDAL aa = new AdminDAL();
SqlConnection conn = new SqlConnection();
conn = aa.getconnection();
DateTime datetime;
objShift_Data.Shift_ID = txtaddshiftID.Text;
objShift_Data.shiftdep = txtaddshiftName.Text;
objShift_Data.ShiftDateFrom = DateTime.TryParse(txtaddDateFrom.Text, out datetime) ? (DateTime?)datetime : null;;
objShift_Data.ShiftDateTo = DateTime.TryParse(txtaddDateTo.Text, out datetime) ? (DateTime?)datetime : null;;
objShift_Data.ShiftTimeFrom = TimeSelector1.Date.TimeOfDay.ToString();
objShift_Data.ShiftTimeTo = TimeSelector2.Date.TimeOfDay.ToString();
objShift_Data.Location = txtaddLocationName.Text;
AddNewStaffShiftRequest objstaffshift = new AddNewStaffShiftRequest();
Staff_Shift objStaff = new Staff_Shift();
User_Info objuser = new User_Info();
foreach (TextBox tb in dynamicTextBoxes)
{
string ss = Convert.ToString(objuser.Staff_ID);
SqlCommand cmd = new SqlCommand("select Staff_ID from userinformation", conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
ss = rd.GetValue(0).ToString();
if (ss == tb.Text)
{
objStaff.Shift_ID = objShift_Data.Shift_ID;
objStaff.Staff_ID = tb.Text;
ws.AddStaffShift(objStaff);
}
}
rd.Close();
}
ws.UpdateShiftData(objShift_Data);
HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "UPDATE");
Server.Transfer("AlertUpdateComplete.aspx");
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public void AddStaffShift(Staff_Shift objStaffShift)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
objAdminDAL.AddStaffShift(objStaffShift);
}
catch (Exception es)
{
throw es;
}
}
