public static HR_WorkingDaysShifting GetHR_WorkingDaysShiftingObjectByEmployeeID(string EmployeeID)
{
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider();
hR_WorkingDaysShifting = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingObjectByEmployeeID(EmployeeID);
return hR_WorkingDaysShifting;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString();
string txtStartMin = this.ddltime_minstart.SelectedValue.ToString();
string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00";
DateTime dtStartTime = Convert.ToDateTime(txtStartTime);
string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString();
string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString();
string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00";
DateTime dtEndTime = Convert.ToDateTime(txtEndTime);
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
hR_WorkingDaysShifting.WorkingDaysID = int.Parse(Request.QueryString["ID"].ToString());
hR_WorkingDaysShifting.EmployeeID = Profile.card_id;
hR_WorkingDaysShifting.Saturday = chkSaturday.Checked == true ? true : false;
hR_WorkingDaysShifting.Sunday = chkSunday.Checked == true ? true : false;
hR_WorkingDaysShifting.Monday = chkMonday.Checked == true ? true : false;
hR_WorkingDaysShifting.Tuesday = chkTuesday.Checked == true ? true : false;
hR_WorkingDaysShifting.Wednesday = chkWednesday.Checked == true ? true : false;
hR_WorkingDaysShifting.Thrusday = chkThrusday.Checked == true ? true : false;
//hR_WorkingDaysShifting.ShiftStartTime= DateTime.Parse(txtShiftStartTime.Text);
//hR_WorkingDaysShifting.ShiftEndTime= DateTime.Parse(txtShiftEndTime.Text);
hR_WorkingDaysShifting.ShiftStartTime = dtStartTime;
hR_WorkingDaysShifting.ShiftEndTime = dtEndTime;
hR_WorkingDaysShifting.Description = txtDescription.Text;
hR_WorkingDaysShifting.AddedBy = Profile.card_id;
hR_WorkingDaysShifting.AddedDate = DateTime.Now;
hR_WorkingDaysShifting.ModifiedBy = Profile.card_id;
hR_WorkingDaysShifting.ModifiedDate = DateTime.Now;
bool resutl = HR_WorkingDaysShiftingManager.UpdateHR_WorkingDaysShifting(hR_WorkingDaysShifting);
Response.Redirect("AdminDisplayHR_WorkingDaysShifting.aspx");
}
public static HR_WorkingDaysShifting GetHR_WorkingDaysShiftingByWorkingDaysID(int WorkingDaysID)
{
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider();
hR_WorkingDaysShifting = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingByWorkingDaysID(WorkingDaysID);
return hR_WorkingDaysShifting;
}
/// <summary>
/// ////////////////
/// </summary>
/// <param name="EmployeeID"></param>
/// <returns></returns>
public static DataTable GetHR_WorkingDaysShiftingTableByEmployeeID(string EmployeeID)
{
HR_WorkingDaysShifting hR_WorkingDayShift = new HR_WorkingDaysShifting();
SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider();
hR_WorkingDayShift = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingObjectByEmployeeID(EmployeeID);
//HR_WorkingDaysShifting hR_WorkingDayShift = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingObjectByEmployeeID("96b72550-3649-45c6-a1f5-0474a77f4fa6");
DataTable workDayShift = new DataTable();
workDayShift.Columns.Add("Days", Type.GetType("System.String"));
workDayShift.Columns.Add("StartTime", Type.GetType("System.String"));
workDayShift.Columns.Add("EndTime", Type.GetType("System.String"));
string startTimeHour = hR_WorkingDayShift.ShiftStartTime.Hour.ToString();
string startAMPM = "AM";
if (int.Parse(startTimeHour) > 12)
{
startTimeHour = (int.Parse(startTimeHour) - 12).ToString();
startAMPM = "PM";
}
else if (int.Parse(startTimeHour) == 12)
{
startAMPM = "PM";
}
string startTimeMinute = hR_WorkingDayShift.ShiftStartTime.Minute.ToString();
string startHourMinute = startTimeHour.Length == 1 ? "0" + startTimeHour : startTimeHour;
startHourMinute += " : ";
startHourMinute += startTimeMinute.Length == 1 ? "0" + startTimeMinute : startTimeMinute;
startHourMinute += " "+startAMPM;
string endTimeHour = hR_WorkingDayShift.ShiftEndTime.Hour.ToString();
string endAMPM = "AM";
if (int.Parse(endTimeHour) > 12)
{
endTimeHour = (int.Parse(endTimeHour) - 12).ToString();
endAMPM = "PM";
}
else if (int.Parse(endTimeHour) == 12)
{
endAMPM = "PM";
}
string endTimeMinute = hR_WorkingDayShift.ShiftEndTime.Minute.ToString();
string endHourMinute = endTimeHour.Length == 1 ? "0" + endTimeHour : endTimeHour;
endHourMinute += " : ";
endHourMinute += endTimeMinute.Length == 1 ? "0" + endTimeMinute : endTimeMinute;
endHourMinute += " " + endAMPM;
if (hR_WorkingDayShift.Saturday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Saturday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Sunday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Sunday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Monday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Monday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Tuesday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Tuesday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Wednesday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Wednesday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Thrusday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Thrusday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
if (hR_WorkingDayShift.Friday)
{
DataRow row = workDayShift.NewRow();
row["Days"] = "Friday";
row["StartTime"] = startHourMinute;
row["EndTime"] = endHourMinute;
workDayShift.Rows.Add(row);
}
return workDayShift;
}
public static bool UpdateHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting)
{
SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider();
return sqlHR_WorkingDaysShiftingProvider.UpdateHR_WorkingDaysShifting(hR_WorkingDaysShifting);
}
public static int InsertHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting)
{
SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider();
return sqlHR_WorkingDaysShiftingProvider.InsertHR_WorkingDaysShifting(hR_WorkingDaysShifting);
}
protected void btnAddWorkingDaysShifting_Click(object sender, EventArgs e)
{
if (hfEmployeeID.Value != null)
{
string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString();
string txtStartMin = this.ddltime_minstart.SelectedValue.ToString();
string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00";
DateTime dtStartTime = Convert.ToDateTime(txtStartTime);
string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString();
string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString();
string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00";
DateTime dtEndTime = Convert.ToDateTime(txtEndTime);
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
hR_WorkingDaysShifting.EmployeeID = hfEmployeeID.Value.ToString();
hR_WorkingDaysShifting.Saturday = chkSaturday.Checked == true ? true : false;
hR_WorkingDaysShifting.Sunday = chkSunday.Checked == true ? true : false;
hR_WorkingDaysShifting.Monday = chkMonday.Checked == true ? true : false;
hR_WorkingDaysShifting.Tuesday = chkTuesday.Checked == true ? true : false;
hR_WorkingDaysShifting.Wednesday = chkWednesday.Checked == true ? true : false;
hR_WorkingDaysShifting.Thrusday = chkThrusday.Checked == true ? true : false;
hR_WorkingDaysShifting.Friday = chkFriday.Checked == true ? true : false;
hR_WorkingDaysShifting.ShiftStartTime = dtStartTime;
hR_WorkingDaysShifting.ShiftEndTime = dtEndTime;
hR_WorkingDaysShifting.Description = txtDescription.Text;
string userID = Profile.card_id;
hR_WorkingDaysShifting.AddedBy = userID;
hR_WorkingDaysShifting.AddedDate = DateTime.Now;
hR_WorkingDaysShifting.ModifiedBy = userID;
hR_WorkingDaysShifting.ModifiedDate = DateTime.Now;
int resutl = HR_WorkingDaysShiftingManager.InsertHR_WorkingDaysShifting(hR_WorkingDaysShifting);
hdnWorkingDaysShiftingID.Value = resutl.ToString();
lblDaysShiftingMessage.Text = "Working Shift Information is saved";
lblDaysShiftingMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
lblDaysShiftingMessage.Text = "Employee is not specified.";
lblDaysShiftingMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void RefreshWorkingDaysShifting()
{
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
hR_WorkingDaysShifting = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingObjectByEmployeeID(hfEmployeeID.Value.ToString());
if (hR_WorkingDaysShifting != null)
{
hdnWorkingDaysShiftingID.Value = hR_WorkingDaysShifting.WorkingDaysID.ToString();
chkSaturday.Checked = hR_WorkingDaysShifting.Saturday;
chkSunday.Checked = hR_WorkingDaysShifting.Sunday;
chkMonday.Checked = hR_WorkingDaysShifting.Monday;
chkTuesday.Checked = hR_WorkingDaysShifting.Tuesday;
chkWednesday.Checked = hR_WorkingDaysShifting.Wednesday;
chkThrusday.Checked = hR_WorkingDaysShifting.Thrusday;
chkFriday.Checked = hR_WorkingDaysShifting.Friday;
string startingHour = hR_WorkingDaysShifting.ShiftStartTime.Hour.ToString();
ddltime_hoursStart.SelectedValue = startingHour.Length == 1 ? "0" + startingHour : startingHour;
string startingMinute = hR_WorkingDaysShifting.ShiftStartTime.Minute.ToString();
ddltime_minstart.SelectedValue = startingMinute.Length == 1 ? "0" + startingMinute : startingMinute;
string endingHour = hR_WorkingDaysShifting.ShiftEndTime.Hour.ToString();
ddltime_hoursEnd.SelectedValue = endingHour.Length == 1 ? "0" + endingHour : endingHour;
string endingMinute = hR_WorkingDaysShifting.ShiftEndTime.Minute.ToString();
ddltime_minEnd.SelectedValue = endingMinute.Length == 1 ? "0" + endingMinute : endingMinute;
txtDescription.Text = hR_WorkingDaysShifting.Description;
}
}
private void showHR_WorkingDaysShiftingData()
{
string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString();
string txtStartMin = this.ddltime_minstart.SelectedValue.ToString();
string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00";
DateTime dtStartTime = Convert.ToDateTime(txtStartTime);
string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString();
string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString();
string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00";
DateTime dtEndTime = Convert.ToDateTime(txtEndTime);
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting();
hR_WorkingDaysShifting = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingByWorkingDaysID(Int32.Parse(Request.QueryString["ID"]));
chkSaturday.Checked = hR_WorkingDaysShifting.Saturday;
chkSunday.Checked = hR_WorkingDaysShifting.Sunday;
chkMonday.Checked = hR_WorkingDaysShifting.Monday;
chkTuesday.Checked = hR_WorkingDaysShifting.Tuesday;
chkWednesday.Checked = hR_WorkingDaysShifting.Wednesday;
chkThrusday.Checked = hR_WorkingDaysShifting.Thrusday;
//txtShiftStartTime.Text =hR_WorkingDaysShifting.ShiftStartTime.ToString();
//txtShiftEndTime.Text =hR_WorkingDaysShifting.ShiftEndTime.ToString();
hR_WorkingDaysShifting.ShiftStartTime = dtStartTime;
hR_WorkingDaysShifting.ShiftEndTime = dtEndTime;
txtDescription.Text = hR_WorkingDaysShifting.Description.ToString();
}
public bool UpdateHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_WorkingDaysShifting", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@WorkingDaysID", SqlDbType.Int).Value = hR_WorkingDaysShifting.WorkingDaysID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.EmployeeID;
cmd.Parameters.Add("@Saturday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Saturday;
cmd.Parameters.Add("@Sunday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Sunday;
cmd.Parameters.Add("@Monday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Monday;
cmd.Parameters.Add("@Tuesday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Tuesday;
cmd.Parameters.Add("@Wednesday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Wednesday;
cmd.Parameters.Add("@Thrusday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Thrusday;
cmd.Parameters.Add("@Friday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Thrusday;
cmd.Parameters.Add("@ShiftStartTime", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ShiftStartTime;
cmd.Parameters.Add("@ShiftEndTime", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ShiftEndTime;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.Description;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_WorkingDaysShifting GetHR_WorkingDaysShiftingFromReader(IDataReader reader)
{
try
{
HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting
(
DataAccessObject.IsNULL<int>(reader["WorkingDaysID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<bool>(reader["Saturday"]),
DataAccessObject.IsNULL<bool>(reader["Sunday"]),
DataAccessObject.IsNULL<bool>(reader["Monday"]),
DataAccessObject.IsNULL<bool>(reader["Tuesday"]),
DataAccessObject.IsNULL<bool>(reader["Wednesday"]),
DataAccessObject.IsNULL<bool>(reader["Thrusday"]),
DataAccessObject.IsNULL<bool>(reader["Friday"]),
DataAccessObject.IsNULL<DateTime>(reader["ShiftStartTime"]),
DataAccessObject.IsNULL<DateTime>(reader["ShiftEndTime"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_WorkingDaysShifting;
}
catch(Exception ex)
{
return null;
}
}
