private void Weekdays_PreviewKeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
Action <FocusNavigationDirection> moveFocus = focusDirection =>
{
e.Handled = true;
var request = new TraversalRequest(focusDirection);
var focusedElement = Keyboard.FocusedElement as CheckBox;
if (((string)focusedElement.Content == "SU" && request.FocusNavigationDirection == FocusNavigationDirection.Next))
{
Monday.Focus();
}
else if (((string)focusedElement.Content == "MO" && request.FocusNavigationDirection == FocusNavigationDirection.Previous))
{
Sunday.Focus();
}
else
{
focusedElement.MoveFocus(request);
}
};
if (e.Key == Key.Down)
{
moveFocus(FocusNavigationDirection.Previous);
}
else if (e.Key == Key.Up)
{
moveFocus(FocusNavigationDirection.Next);
}
if (e.Key == Key.Tab)
{
Sunday.Focus();
}
}
public void Copy(Schedule schedule)
{
Monday.Copy(schedule.Monday);
Tuesday.Copy(schedule.Tuesday);
Wednesday.Copy(schedule.Wednesday);
Thursday.Copy(schedule.Thursday);
Friday.Copy(schedule.Friday);
}
public ActionResult DeleteConfirmed(int id)
{
Monday monday = db.Mondays.Find(id);
db.Mondays.Remove(monday);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Compares the current instance with another object of the same type and returns an integer that
/// indicates whether the current instance precedes, follows, or occurs in the same position in the
/// sort order as the other object.
/// </summary>
/// <param name="other">The object to compare with this instance.</param>
/// <returns>A value that indicates the relative order of the objects being compared.</returns>
public int CompareTo(TimeSlotRow other)
{
if (other == null)
{
return(1);
}
var hourComparison = Hour.CompareTo(other.Hour);
if (hourComparison != 0)
{
return(hourComparison);
}
var mondayComparison = Monday.CompareTo(other.Monday);
if (mondayComparison != 0)
{
return(mondayComparison);
}
var tuesdayComparison = Tuesday.CompareTo(other.Tuesday);
if (tuesdayComparison != 0)
{
return(tuesdayComparison);
}
var wednesdayComparison = Wednesday.CompareTo(other.Wednesday);
if (wednesdayComparison != 0)
{
return(wednesdayComparison);
}
var thursdayComparison = Thursday.CompareTo(other.Thursday);
if (thursdayComparison != 0)
{
return(thursdayComparison);
}
var fridayComparison = Friday.CompareTo(other.Friday);
if (fridayComparison != 0)
{
return(fridayComparison);
}
var saturdayComparison = Saturday.CompareTo(other.Saturday);
if (saturdayComparison != 0)
{
return(saturdayComparison);
}
return(Sunday.CompareTo(other.Sunday));
}
private void ResultsKeyPress(object sender, KeyEventArgs e)
{
if (e.Key != Key.Enter || Results.SelectedItem == null)
{
return;
}
SelectNode(Results.SelectedItem as NavigatorNode);
Monday.Focus();
}
private void ClearLists()
{
Monday.Clear();
Tuesday.Clear();
Wednesday.Clear();
Thursday.Clear();
Friday.Clear();
Saturday.Clear();
Sunday.Clear();
}
public ActionResult Edit([Bind(Include = "Id,Available")] Monday monday)
{
if (ModelState.IsValid)
{
db.Entry(monday).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(monday));
}
private void ClearEventArrays()
{
Monday.Clear();
Tuesday.Clear();
Wednesday.Clear();
Thursday.Clear();
Friday.Clear();
Saturday.Clear();
Sunday.Clear();
}
static public double Average(Monday monday, int j)
{
double s = 0;
for (int i = 0; i < 3; i++)
{
s += monday[i, j];
}
return(s / 3);
}
private void SearchKeyPress(object sender, KeyEventArgs e)
{
if (e.Key != Key.Enter || Results.Items.Count == 0)
{
return;
}
SelectNode(Results.Items[0] as NavigatorNode);
Monday.Focus();
}
public ActionResult Edit([Bind(Include = "MondayId,NameOfTraining,WeightOfTraining,Approach,Appr1,Appr2,Appr3,Appr4,Appr5,DateDateId")] Monday monday)
{
if (ModelState.IsValid)
{
db.Entry(monday).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateDateId = new SelectList(db.Dates, "DateId", "DateId", monday.DateDateId);
return(View(monday));
}
public ActionResult Create([Bind(Include = "Id,Available")] Monday monday)
{
if (ModelState.IsValid)
{
db.Mondays.Add(monday);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(monday));
}
internal void AddShareSkill()
{
ExcelLib.PopulateInCollection(Base.ExcelPath, "ManageListings");
GlobalDefinitions.WaitForElement(ShareSkillButton, 30);
ShareSkillButton.Click();
GlobalDefinitions.WaitForElement(Title, 30);
Title.SendKeys(ExcelLib.ReadData(2, "Title"));
Description.SendKeys(ExcelLib.ReadData(2, "Description"));
Category(CategoryDropDown, ExcelLib.ReadData(2, "Category"));
SubCategory(SubCategoryDropDown, ExcelLib.ReadData(2, "Sub Category"));
Tags.SendKeys(ExcelLib.ReadData(2, "Tags"));
Tags.SendKeys(Keys.Enter);
OneOff.Click();
OnLine.Click();
StartDateDropDown.SendKeys(ExcelLib.ReadData(2, "Start Date"));
EndDateDropDown.SendKeys(ExcelLib.ReadData(2, "End Date"));
Sunday.Click();
SundayStartTime.SendKeys(ExcelLib.ReadData(2, "Sunday Start Time"));
SundayEndTime.SendKeys(ExcelLib.ReadData(2, "Sunday End Time"));
Monday.Click();
MondayStartTime.SendKeys(ExcelLib.ReadData(2, "Monday Start Time"));
MondayEndTime.SendKeys(ExcelLib.ReadData(2, "Monday End Time"));
Tuesday.Click();
TuesdayStartTime.SendKeys(ExcelLib.ReadData(2, "Monday Start Time"));
TuesdayEndTime.SendKeys(ExcelLib.ReadData(2, "Monday End Time"));
CreditOption.Click();
if (SkillExchangeOption.Selected)
{
SkillExchange.SendKeys(ExcelLib.ReadData(2, "Skill Exchange"));
}
else
{
CreditAmount.SendKeys(ExcelLib.ReadData(2, "Credit"));
}
Hidden.Click();
Save.Click();
}
private void Save(string[] asIDSArr, ListViewItem lvi)
{
if (asIDSArr.Length < 7) return;
string lsSAPB1DB = ((Label)lvi.FindControl("lblSAPB1DBEdit")).Text;// lsPrjSAPB1DBArr[1];
string lsPrjCode = ((Label)lvi.FindControl("lblPrjCodeEdit")).Text;// lsPrjSAPB1DBArr[0];
string lsPrjName = ((Label)lvi.FindControl("lblPrjNameEdit")).Text;//((DropDownList)lvi.FindControl("ddlPrjTaskEdit")).SelectedItem.Text;
string lsTask = ((TextBox)lvi.FindControl("txtTaskEdit")).Text;
string lsComments = ((TextBox)lvi.FindControl("txtCommentsEdit")).Text;
string lsPhase = ((DropDownList)lvi.FindControl("ddlPhaseEdit")).SelectedValue;
//string[] lsMoreInfo = ((Label)lvi.FindControl("lblMoreInfoEdit")).Text.Split(';');
//string lsCountry = string.Empty, lsEBMName = string.Empty, lsProspectName = string.Empty;
//if (lsMoreInfo != null)
//{
// if (lsMoreInfo.Length > 0) lsCountry = lsMoreInfo[0];
// if (lsMoreInfo.Length > 1) lsEBMName = lsMoreInfo[1];
// if (lsMoreInfo.Length > 2) lsProspectName = lsMoreInfo[2];
//}
// Get Hours
string lsMon = ((TextBox)lvi.FindControl("txtMonEdit")).Text;
string lsTue = ((TextBox)lvi.FindControl("txtTueEdit")).Text;
string lsWed = ((TextBox)lvi.FindControl("txtWedEdit")).Text;
string lsThu = ((TextBox)lvi.FindControl("txtthuEdit")).Text;
string lsFri = ((TextBox)lvi.FindControl("txtFriEdit")).Text;
string lsSat = ((TextBox)lvi.FindControl("txtSatEdit")).Text;
string lsSun = ((TextBox)lvi.FindControl("txtSunEdit")).Text;
// Get Billable
int liBillable = (((CheckBox)lvi.FindControl("chkBillableEdit")).Checked == true ? 1 : 0);
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure, "sp_InsUpdTimeEntry",
Data.CreateParameter("@IN_UserCode", User.Identity.Name),
Data.CreateParameter("@IN_Monday", Monday.ToString("yyyyMMdd")),
Data.CreateParameter("@IN_PrjCode", lsPrjCode),
Data.CreateParameter("@IN_PrjName", lsPrjName),
Data.CreateParameter("@IN_Task", lsTask),
Data.CreateParameter("@IN_Comments", lsComments),
Data.CreateParameter("@IN_SAPB1DB", lsSAPB1DB),
Data.CreateParameter("@IN_MON", asIDSArr[0] + ";" + CS2Dec(lsMon).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_TUE", asIDSArr[1] + ";" + CS2Dec(lsTue).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_WED", asIDSArr[2] + ";" + CS2Dec(lsWed).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_THU", asIDSArr[3] + ";" + CS2Dec(lsThu).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_FRI", asIDSArr[4] + ";" + CS2Dec(lsFri).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_SAT", asIDSArr[5] + ";" + CS2Dec(lsSat).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_SUN", asIDSArr[6] + ";" + CS2Dec(lsSun).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_PHASE", lsPhase),
Data.CreateParameter("@IN_COUNTRY", hdnCountry.Value),
Data.CreateParameter("@IN_EBMNAME", hdnEBMName.Value),
Data.CreateParameter("@IN_PROSPECTNAME", hdnProspectName.Value)
);
//FromDate = txtFromDate.Text.Trim();
Response.Redirect(WeeklyURL + "&date=" + txtFromDate.Text.Trim());
}
protected void UpdateListViewHeader()
{
CultureInfo ivCEn = new CultureInfo("en-US");
Label lblMon = this.lvStage.Controls[0].FindControl("lblMon") as Label;
if (lblMon != null)
{
lblMon.Text = Monday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblTue = this.lvStage.Controls[0].FindControl("lblTue") as Label;
if (lblTue != null)
{
lblTue.Text = Tuesday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblWed = this.lvStage.Controls[0].FindControl("lblWed") as Label;
if (lblWed != null)
{
lblWed.Text = Wednesday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblThu = this.lvStage.Controls[0].FindControl("lblThu") as Label;
if (lblThu != null)
{
lblThu.Text = Thursday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblFri = this.lvStage.Controls[0].FindControl("lblFri") as Label;
if (lblFri != null)
{
lblFri.Text = Friday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblSat = this.lvStage.Controls[0].FindControl("lblSat") as Label;
if (lblSat != null)
{
lblSat.Text = Saturday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
Label lblSun = this.lvStage.Controls[0].FindControl("lblSun") as Label;
if (lblSun != null)
{
lblSun.Text = Sunday.ToString("ddd </br> dd-MMM-yy", ivCEn);
}
}
// GET: Mondays/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Monday monday = db.Mondays.Find(id);
if (monday == null)
{
return(HttpNotFound());
}
return(View(monday));
}
private void FetchTasks()
{
Monday.Clear();
Tuesday.Clear();
Wednesday.Clear();
Thursday.Clear();
Friday.Clear();
Saturday.Clear();
Sunday.Clear();
List <DailyTask> Models = db.DailyTasks
.Where(p => p.UserId == User.Id)
.ToList <DailyTask>();
foreach (var m in Models)
{
if (m.Date.HasValue)
{
Debug.WriteLine("Has value!");
if (m.Date.Value.Date == (WeekDates[0].Date))
{
Monday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[1].Date))
{
Tuesday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[2].Date))
{
Wednesday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[3].Date))
{
Thursday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[4].Date))
{
Friday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[5].Date))
{
Saturday.Add(m);
}
else if (m.Date.Value.Date == (WeekDates[6].Date))
{
Sunday.Add(m);
}
}
}
}
// GET: Mondays/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Monday monday = db.Mondays.Find(id);
if (monday == null)
{
return(HttpNotFound());
}
ViewBag.DateDateId = new SelectList(db.Dates, "DateId", "DateId", monday.DateDateId);
return(View(monday));
}
public void AddMonday(Staff s)
{
Monday m = new Monday();
m.staffId = s.staffId;
try
{
cntx.Monday.Add(m);
cntx.SaveChanges();
}
catch (Exception)
{
throw new ArgumentException("Error in adding " + s.initials + " to Monday schedule.");
}
}
public void ShareSkillPageRemaining()
{
var Startdatedata = ExcelLibHelper.ReadData(rownum, "StartDate");
StartDate.SendKeys(Startdatedata);
var Enddatedata = ExcelLibHelper.ReadData(rownum, "EndDate");
EndDate.SendKeys(Enddatedata);
Sunday.Click();
Monday.Click();
var Starttimedata = ExcelLibHelper.ReadData(rownum, "StartTime");
Starttime.SendKeys(Startdatedata);
var Endtimedata = ExcelLibHelper.ReadData(rownum, "EndTime");
Endtime.SendKeys(Enddatedata);
}
private void Save(string[] asIDSArr, ListViewItem lvi)
{
if (asIDSArr.Length < 7)
{
return;
}
string[] lsPrjSAPB1DBArr = ((DropDownList)lvi.FindControl("ddlPrjTaskEdit")).SelectedItem.Value.Split(';');
string lsSAPB1DB = lsPrjSAPB1DBArr[1];
string lsPrjCode = lsPrjSAPB1DBArr[0];
string lsPrjName = ((DropDownList)lvi.FindControl("ddlPrjTaskEdit")).SelectedItem.Text;
string lsTask = ((TextBox)lvi.FindControl("txtTaskEdit")).Text;
string lsComments = ((TextBox)lvi.FindControl("txtCommentsEdit")).Text;
// Get Hours
string lsMon = ((TextBox)lvi.FindControl("txtMonEdit")).Text;
string lsTue = ((TextBox)lvi.FindControl("txtTueEdit")).Text;
string lsWed = ((TextBox)lvi.FindControl("txtWedEdit")).Text;
string lsThu = ((TextBox)lvi.FindControl("txtthuEdit")).Text;
string lsFri = ((TextBox)lvi.FindControl("txtFriEdit")).Text;
string lsSat = ((TextBox)lvi.FindControl("txtSatEdit")).Text;
string lsSun = ((TextBox)lvi.FindControl("txtSunEdit")).Text;
// Get Billable
int liBillable = (((CheckBox)lvi.FindControl("chkBillableEdit")).Checked == true ? 1 : 0);
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure, "sp_InsUpdTimeEntry",
Data.CreateParameter("@IN_UserCode", User.Identity.Name),
Data.CreateParameter("@IN_Monday", Monday.ToString("yyyyMMdd")),
Data.CreateParameter("@IN_PrjCode", lsPrjCode),
Data.CreateParameter("@IN_PrjName", lsPrjName),
Data.CreateParameter("@IN_Task", lsTask),
Data.CreateParameter("@IN_Comments", lsComments),
Data.CreateParameter("@IN_SAPB1DB", lsSAPB1DB),
Data.CreateParameter("@IN_MON", asIDSArr[0] + ";" + CS2Dec(lsMon).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_TUE", asIDSArr[1] + ";" + CS2Dec(lsTue).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_WED", asIDSArr[2] + ";" + CS2Dec(lsWed).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_THU", asIDSArr[3] + ";" + CS2Dec(lsThu).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_FRI", asIDSArr[4] + ";" + CS2Dec(lsFri).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_SAT", asIDSArr[5] + ";" + CS2Dec(lsSat).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_SUN", asIDSArr[6] + ";" + CS2Dec(lsSun).ToString() + ";" + liBillable.ToString()),
Data.CreateParameter("@IN_PHASE", "")
);
Response.Redirect("/TimeSheet/Pending4ApprTimeSheet.aspx?date=" + txtFromDate.Text.Trim());
}
public void Refresh(DayOfWeek?day = null)
{
switch (day)
{
case DayOfWeek.Monday:
Monday.InvalidateSurface();
break;
case DayOfWeek.Tuesday:
Tuesday.InvalidateSurface();
break;
case DayOfWeek.Wednesday:
Wednesday.InvalidateSurface();
break;
case DayOfWeek.Thursday:
Thursday.InvalidateSurface();
break;
case DayOfWeek.Friday:
Friday.InvalidateSurface();
break;
case DayOfWeek.Saturday:
Friday.InvalidateSurface();
break;
case DayOfWeek.Sunday:
Friday.InvalidateSurface();
break;
default:
Monday.InvalidateSurface();
Tuesday.InvalidateSurface();
Wednesday.InvalidateSurface();
Thursday.InvalidateSurface();
Friday.InvalidateSurface();
Saturday.InvalidateSurface();
Sunday.InvalidateSurface();
break;
}
}
static DateTimeUtil()
{
var now = DateTime.Now.Date;
Today = now;
FirstDayOfTheMonth = now.AddDays(now.Day * -1 + 1);
LastDayOfTheMonth = FirstDayOfTheMonth.AddMonths(1).AddDays(-1);
FirstDayOfLastMonth = FirstDayOfTheMonth.AddMonths(-1);
LastDayOfLastMonth = FirstDayOfTheMonth.AddDays(-1);
int i = now.DayOfWeek - DayOfWeek.Monday == -1 ? 6 : -1;
TimeSpan ts = new TimeSpan(i, 0, 0, 0);
Monday = now.Subtract(ts).Date;
Tuesday = Monday.AddDays(1);
Wednesday = Monday.AddDays(2);
Thursday = Monday.AddDays(3);
Friday = Monday.AddDays(4);
Saturday = Monday.AddDays(5);
Sunday = Monday.AddDays(6);
LastMonday = Monday.AddDays(-7);
LastTuesday = LastMonday.AddDays(1);
LastWednesday = LastMonday.AddDays(2);
LastThursday = LastMonday.AddDays(3);
LastFriday = LastMonday.AddDays(4);
LastSaturday = LastMonday.AddDays(5);
LastSunday = LastMonday.AddDays(6);
NextMonday = Sunday.AddDays(1);
NextTuesday = Monday.AddDays(1);
NextWednesday = Monday.AddDays(2);
NextThursday = Monday.AddDays(3);
NextFriday = Monday.AddDays(4);
NextSaturday = Monday.AddDays(5);
NextSunday = Monday.AddDays(6);
RunIdOfToday = now.ToString("yyyy-MM-dd");
RunIdOfMonthly = FirstDayOfTheMonth.ToString("yyyy-MM-dd");
RunIdOfMonday = Monday.ToString("yyyy-MM-dd");
}
void Binding()
{
CultureInfo ivC = new CultureInfo("es-US");
DateTime Today = Convert.ToDateTime(txtFromDate.Text, ivC);
Monday = Today.AddDays(1 - Today.DayOfWeek.GetHashCode());
Tuesday = Today.AddDays(2 - Today.DayOfWeek.GetHashCode());
Wednesday = Today.AddDays(3 - Today.DayOfWeek.GetHashCode());
Thursday = Today.AddDays(4 - Today.DayOfWeek.GetHashCode());
Friday = Today.AddDays(5 - Today.DayOfWeek.GetHashCode());
Saturday = Today.AddDays(6 - Today.DayOfWeek.GetHashCode());
Sunday = Today.AddDays(7 - Today.DayOfWeek.GetHashCode());
////////////////////////////////////////////////////////////////////
LoadUser();
ddlUser.DataSource = dsUserList.Tables[0];
ddlUser.DataTextField = "UserCode";
ddlUser.DataValueField = "UserCode";
ddlUser.DataBind();
ddlUser.Items.Insert(0, "");
ddlUser.SelectedIndex = mi_idxUser;
ddlStatus.SelectedIndex = mi_idxStatus;
/////////////////////////////////////////////////////////////////////
ds = SqlHelper.ExecuteDataSet(Data.ConnectionString, CommandType.StoredProcedure, "sp_Pending4ApproveTimeSheet",
Data.CreateParameter("@IN_BeginDate", Monday.ToString("MM/dd/yyyy")),
Data.CreateParameter("@IN_ProjectManager", User.Identity.Name),
Data.CreateParameter("@IN_UserCode", ddlUser.SelectedValue),
Data.CreateParameter("@IN_Status", ddlStatus.SelectedValue));
DataView dv = new DataView(ds.Tables[0]);
this.lvStage.DataSource = dv;
this.lvStage.DataBind();
LoadPrj();
if (ds.Tables[0].Rows.Count <= 0)
{
btnReject.Enabled =
btnApprove.Enabled = false;
}
}
void Binding()
{
txtUserCode.Text = User.Identity.Name;
txtUserCode.ReadOnly = true;
CultureInfo ivC = new CultureInfo("es-US");
DateTime Today = Convert.ToDateTime(FromDate, ivC);
Monday = Today.AddDays(1 - Today.DayOfWeek.GetHashCode());
Tuesday = Today.AddDays(2 - Today.DayOfWeek.GetHashCode());
Wednesday = Today.AddDays(3 - Today.DayOfWeek.GetHashCode());
Thursday = Today.AddDays(4 - Today.DayOfWeek.GetHashCode());
Friday = Today.AddDays(5 - Today.DayOfWeek.GetHashCode());
Saturday = Today.AddDays(6 - Today.DayOfWeek.GetHashCode());
Sunday = Today.AddDays(7 - Today.DayOfWeek.GetHashCode());
DataSet ds = SqlHelper.ExecuteDataSet(Data.ConnectionString, CommandType.StoredProcedure, "sp_WeekendTimeSheet",
Data.CreateParameter("@IN_BeginDate", Monday.ToString("MM/dd/yyyy")), Data.CreateParameter("@IN_UserCode", User.Identity.Name));
// Keep ds
Session["dsWeeklyTimesheet"] = ds;
string lsSQL = " Select Count(*) From tbl_TimeEntry Where UserCode = '" + User.Identity.Name + "' and [Status] = 0 "
+ " and convert(varchar(8), [Date], 112) >= '" + Monday.ToString("yyyyMMdd") + "'"
+ " and convert(varchar(8), [Date], 112) <= '" + Sunday.ToString("yyyyMMdd") + "'";
if (!CheckStatus(lsSQL) && ds.Tables[0].Rows.Count > 0)
{
//btnAddRecord.Enabled = false;
btnSubmit.Enabled = false;
}
DataView dv = new DataView(ds.Tables[0]);
this.lvStage.DataSource = dv;
this.lvStage.DataBind();
LoadPrj();
if (ds.Tables[0].Rows.Count <= 0)
btnSubmit.Enabled = false;
}
public void CopyData(AAS.DB.Course other)
{
CRN = other.CRN;
Subject = other.Subject;
Credits = other.Credits;
Title = other.Title;
CourseNumber = other.CourseNumber;
SectionNumber = other.SectionNumber;
foreach (AAS.DB.Period p in other.Periods)
{
if (p.DayOfWeek.ToUpper() == "M")
{
Monday.Add(new Period(p));
}
if (p.DayOfWeek.ToUpper() == "T")
{
Tuesday.Add(new Period(p));
}
if (p.DayOfWeek.ToUpper() == "W")
{
Wednesday.Add(new Period(p));
}
if (p.DayOfWeek.ToUpper() == "R")
{
Thursday.Add(new Period(p));
}
if (p.DayOfWeek.ToUpper() == "F")
{
Friday.Add(new Period(p));
}
}
foreach (AAS.DB.Exam e in other.Exams)
{
Exams.Add(new Exam(e));
}
}
public void SortEvents()
{
ClearEventArrays();
foreach (Event e in TimetableEvents)
{
switch (e.Day)
{
case 1:
Monday.Add(e);
break;
case 2:
Tuesday.Add(e);
break;
case 3:
Wednesday.Add(e);
break;
case 4:
Thursday.Add(e);
break;
case 5:
Friday.Add(e);
break;
case 6:
Saturday.Add(e);
break;
case 7:
Sunday.Add(e);
break;
}
}
}
public static Weekday Create(string name, IEnumerable <Item> items)
{
Weekday day = null;
switch (name)
{
case "Monday": day = new Monday(); break;
case "Tuesday": day = new Tuesday(); break;
case "Wednesday": day = new Wednesday(); break;
case "Thursday": day = new Thursday(); break;
case "Friday": day = new Friday(); break;
default:
throw new NotSupportedException($"Unsupported weekday '{name}'!");
}
day.Items = items;
return(day);
}
private async void DialogHost_DialogClosing(object sender, MaterialDesignThemes.Wpf.DialogClosingEventArgs eventArgs)
{
if (!Equals(eventArgs.Parameter, true))
{
return;
}
if (TaskTitle.Text != null && TaskDescription.Text != null && DialogTime.Text != null)
{
switch (DialogDays.Text)
{
case "Monday":
Monday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(MondayTitle));
break;
case "Tuesday":
Tuesday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(TuesdayTitle));
break;
case "Wednesday":
Wednesday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(WednesdayTitle));
break;
case "Thursday":
Thursday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(ThursdayTitle));
break;
case "Friday":
Friday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(FridayTitle));
break;
case "Saturday":
Saturday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(SaturdayTitle));
break;
case "Sunday":
Sunday.Add(new ListViewStruct
{
Title = TaskTitle.Text,
Description = TaskDescription.Text,
Time = DialogTime.Text,
});
await AddToDatabase(Convert.ToDateTime(SundayTitle));
break;
}
}
}
private void LoadUser()
{
dsUserList = SqlHelper.ExecuteDataSet(Data.ConnectionString, CommandType.Text, "Select distinct UserCode "
+ "From tbl_TimeEntry "
+ "where Convert(varchar(8), [Date], 112) >= '" + Monday.ToString("yyyyMMdd") + "'"
+ " and Convert(varchar(8), [Date], 112) <= '" + Sunday.ToString("yyyyMMdd") + "' and [Status] in (2, 1) "
+ " and PrjCode in (Select SUBSTRING(PrjCode, 1, CHARINDEX(';',PrjCode)-1) "
+ " From dbo.tbl_ProjectManager P inner join dbo.aspnet_Users U on P.UserID = U.UserID "
+ " where U.UserName = '******') ");
}
