//saves doctor shift public static void staffShiftSave(StaffShiftsHL staffShi) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Common.getConnection(); cmd.CommandText = "Staff_Shift_Insert"; cmd.CommandType = System.Data.CommandType.StoredProcedure; //Shift Name SqlParameter sShiftName = new SqlParameter("@shiftName", staffShi.shiftName); sShiftName.SqlDbType = System.Data.SqlDbType.NVarChar; cmd.Parameters.Add(sShiftName); //From SqlParameter tFrom = new SqlParameter("@from", staffShi.from); tFrom.SqlDbType = System.Data.SqlDbType.Time; cmd.Parameters.Add(tFrom); //To SqlParameter tTo = new SqlParameter("@to", staffShi.to); tTo.SqlDbType = System.Data.SqlDbType.Time; cmd.Parameters.Add(tTo); cmd.ExecuteNonQuery(); } }
//gets staffShifts list public static List <StaffShiftsHL> getStaffShifts() { List <StaffShiftsHL> staffShiftsList = new List <StaffShiftsHL>(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Common.getConnection(); cmd.CommandText = "Staff_Shift_Select"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { StaffShiftsHL ss = new StaffShiftsHL(); ss.shiftId = Int32.Parse(dt.Rows[i]["shiftId"].ToString()); ss.shiftName = dt.Rows[i]["shiftName"].ToString(); ss.from = (TimeSpan)dt.Rows[i]["from"]; ss.to = (TimeSpan)dt.Rows[i]["to"]; staffShiftsList.Add(ss); } } return(staffShiftsList); }