public async Task <IActionResult> Edit(int id, [Bind("Id,Date,Conductor,OpeningHymn,ClosingHymn,SacramentHymn,IntermediateSong,OpeningPrayer,ClosingPrayer")] Sunday sunday)
{
if (id != sunday.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(sunday);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SundayExists(sunday.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(sunday));
}
private string GetWeekendHTML()
{
StringBuilder stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(Saturday.Trim()) && !string.IsNullOrEmpty(Sunday.Trim()))
{
stringBuilder.AppendFormat("<tr class='weekplanw'><td>Friday</td><td>Saturday</td><td> </td><td> </td><td> </td></tr>"
+ "<tr><td>{0}<br />Estimate: {1} H</td><td>{2}<br />Estimate: {3} H</td><td> </td><td> </td><td> </td></tr>", Friday, FridayEstimate, Saturday, SaturdayEstimate);
return(stringBuilder.ToString());
}
else if (!string.IsNullOrEmpty(Saturday.Trim()))
{
stringBuilder.AppendFormat("<tr class='weekplanw'><td>Saturday</td><td> </td><td> </td><td> </td><td> </td></tr>"
+ "<tr><td>{0}<br />Estimate: {1} H</td><td> </td><td> </td><td> </td></tr>", Saturday, SaturdayEstimate);
return(stringBuilder.ToString());
}
else if (!string.IsNullOrEmpty(Sunday.Trim()))
{
stringBuilder.AppendFormat("<tr class='weekplanw'><td>Friday</td><td> </td><td> </td><td> </td><td> </td></tr>"
+ "<tr><td>{0}<br />Estimate: {1} H</td><td> </td><td> </td><td> </td></tr>", Friday, FridayEstimate);
return(stringBuilder.ToString());
}
else
{
return("");
}
}
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 static Sunday FromCsv(string line)
{
var culture = new System.Globalization.CultureInfo("de-DE");
const int PROPERTY_COUNT = 13;
var values = line.Split(new string[] { SPLITTER }, StringSplitOptions.None);
if (values.Length != PROPERTY_COUNT)
{
throw new NotSupportedException($"ExportRow does not have the expected amount of values ({PROPERTY_COUNT}) when split with '{SPLITTER}'.\nValues: " + line);
}
var row = new Sunday()
{
Date = System.Convert.ToDateTime(values[0], culture),
PowerConsumptionWh = TryParseSingle(values[1], culture),
PowerGenerationWh = TryParseSingle(values[2], culture),
FeedInWh = TryParseSingle(values[3], culture),
PurchaseWh = TryParseSingle(values[4], culture),
BatterySupplyWh = TryParseSingle(values[5], culture),
BatteryChargeWh = TryParseSingle(values[6], culture),
BatteryChargePercent = TryParseNullableSingle(values[7], culture), // these values are not summed up, the lastest one is the correct one -> don't take "--" as 0 here, we need to differentiate.
PrivateUseWh = TryParseSingle(values[8], culture),
FeedIn2Wh = TryParseSingle(values[9], culture),
PrivateUseFromPvWh = TryParseSingle(values[10], culture),
PowerGenerationAtLocationWh = TryParseSingle(values[11], culture),
PowerGenerationTotalWh = TryParseSingle(values[12], culture)
};
return(row);
}
private void ClearEventArrays()
{
Monday.Clear();
Tuesday.Clear();
Wednesday.Clear();
Thursday.Clear();
Friday.Clear();
Saturday.Clear();
Sunday.Clear();
}
private void ClearLists()
{
Monday.Clear();
Tuesday.Clear();
Wednesday.Clear();
Thursday.Clear();
Friday.Clear();
Saturday.Clear();
Sunday.Clear();
}
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();
}
public async Task <IActionResult> Create([Bind("Id,Date,Conductor,OpeningHymn,ClosingHymn,SacramentHymn,IntermediateSong,OpeningPrayer,ClosingPrayer,Speakers")] Sunday sunday)
{
if (ModelState.IsValid)
{
_context.Add(sunday);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(sunday));
}
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);
}
}
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);
}
}
}
}
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);
}
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");
}
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;
}
}
}
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 IEnumerable <NameCount> Decisions()
{
var dt1 = Sunday.AddDays(-4);
var dt2 = Sunday.AddDays(2);
var q3 = from p in DbUtil.Db.People
where p.DecisionDate >= dt1 && p.DecisionDate < dt2.AddDays(1)
where (Campus ?? 0) == 0 || p.CampusId == Campus
group p by p.DecisionType.Description into g
orderby g.Key
select new NameCount
{
Name = g.Key,
Count = g.Count()
};
var list = q3.ToList();
TotalDecisions = new NameCount
{
Name = "Total",
Count = q3.Sum(i => i.Count)
};
return(list);
}
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;
}
}
}
protected void lvStage_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (lvStage.EditIndex >= 0)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
if (dataItem.DisplayIndex == lvStage.EditIndex)
{
DropDownList ddl = (DropDownList)e.Item.FindControl("ddlPrjTaskEdit"); if (ddl != null)
{
string lsPrjCode = ((Label)e.Item.FindControl("lblPrjCodeEdit")).Text;
string lsSAPB1DB = ((Label)e.Item.FindControl("lblSAPB1DBEdit")).Text;
ddl.DataSource = dsPrjList.Tables[0];
ddl.DataTextField = "PrjName";
ddl.DataValueField = "PrjCode";
ddl.DataBind();
if (!lsPrjCode.Equals("") && !lsSAPB1DB.Equals(""))
ddl.SelectedValue = lsPrjCode + ";" + lsSAPB1DB;
}
DropDownList ddlPhase = (DropDownList)e.Item.FindControl("ddlPhaseEdit"); if (ddlPhase != null)
{
if (ddlPhase.Items.FindByValue(msPhase) != null)
{
ddlPhase.Items.FindByValue(msPhase).Selected = true;
msPhase = string.Empty;
}
else
ddlPhase.SelectedIndex = 0;
}
TextBox txtMon = (TextBox)e.Item.FindControl("txtMonEdit");
TextBox txtTue = (TextBox)e.Item.FindControl("txtTueEdit");
TextBox txtWed = (TextBox)e.Item.FindControl("txtWedEdit");
TextBox txtThu = (TextBox)e.Item.FindControl("txtThuEdit");
TextBox txtFri = (TextBox)e.Item.FindControl("txtFriEdit");
TextBox txtSat = (TextBox)e.Item.FindControl("txtSatEdit");
TextBox txtSun = (TextBox)e.Item.FindControl("txtSunEdit");
TextBox txtSrvType = (TextBox)e.Item.FindControl("txtSrvTypeEdit");
TextBox txtTimeEndDate = (TextBox)e.Item.FindControl("txtTimeEndDateEdit");
txtMon.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtMon.ClientID + "', '" + txtSrvType.Text + "', '" + Monday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtTue.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtTue.ClientID + "', '" + txtSrvType.Text + "', '" + Tuesday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtWed.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtWed.ClientID + "', '" + txtSrvType.Text + "', '" + Wednesday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtThu.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtThu.ClientID + "', '" + txtSrvType.Text + "', '" + Thursday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtFri.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtFri.ClientID + "', '" + txtSrvType.Text + "', '" + Friday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtSat.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtSat.ClientID + "', '" + txtSrvType.Text + "', '" + Saturday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
txtSun.Attributes.Add("onKeyUp", "txtOnKeyPress( '" + txtSun.ClientID + "', '" + txtSrvType.Text + "', '" + Sunday.ToString("yyyyMMdd") + "', '" + txtTimeEndDate.Text + "' )");
}
//mbVisible = true;
System.Web.UI.HtmlControls.HtmlTableCell td = (System.Web.UI.HtmlControls.HtmlTableCell)e.Item.FindControl("tdButtons");
if (td != null) td.Visible = true;
}
else
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
System.Web.UI.HtmlControls.HtmlTableCell td = (System.Web.UI.HtmlControls.HtmlTableCell)e.Item.FindControl("tdButtons");
if (td != null) td.Visible = btnAddRecord.Enabled;
}
}
}
public void getDates(DateTime date)
{
//use the passed over date to find the start of the week and then use that to count forward to saturday (maybe sunday)
//get start of week
while (date.DayOfWeek != System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.FirstDayOfWeek)
{
date = date.AddDays(-1);
}
Monday = date;
//MessageBox.Show(Monday.ToString());
//get end of week
Sunday = date.AddDays(6);
// MessageBox.Show(Sunday.ToString());
//from here fill DT based on sql using monday+sunday
//dataGridView1.Columns[0].HeaderText = "Date";
//dataGridView1.Columns[1].HeaderText = "Department Over Time";
using (SqlConnection CONNECT = new SqlConnection(connectionStrings.ConnectionString))
{
string sql = "";
if (dept == "Dressing")
{
sql = "Select a.id,CAST(a.date_plan as date), b.buffing_OT" +
" FROM dbo.power_plan_date a " +
"LEFT JOIN dbo.power_plan_overtime b on b.date_id = a.id " +
"WHERE date_plan >= '" + Monday.ToString("yyyyMMdd") + "' AND date_plan <= '" + Sunday.ToString("yyyyMMdd") + "' ORDER BY date_plan ASC";
}
else
{
sql = "Select a.id,CAST(a.date_plan as date), b." + dept + "_OT" +
" FROM dbo.power_plan_date a " +
"LEFT JOIN dbo.power_plan_overtime b on b.date_id = a.id " +
"WHERE date_plan >= '" + Monday.ToString("yyyyMMdd") + "' AND date_plan <= '" + Sunday.ToString("yyyyMMdd") + "' ORDER BY date_plan ASC";
}
using (SqlCommand COMMAND = new SqlCommand(sql, CONNECT))
{
CONNECT.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(COMMAND);
da.Fill(dt);
dataGridView1.DataSource = dt;
CONNECT.Close();
}
sql = "Select id from dbo.power_plan_date where date_plan = '" + passedDate.ToString("yyyyMMdd") + "'";
using (SqlCommand cmd = new SqlCommand(sql, CONNECT))
{
CONNECT.Open();
dateID = Convert.ToInt32(cmd.ExecuteScalar());
// MessageBox.Show("dateID = " + dateID.ToString());
CONNECT.Close();
}
}
this.dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "Date";
dataGridView1.Columns[2].HeaderText = dept + " Over Time";
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
col.HeaderCell.Style.Font = new Font("Calibri", 15F, FontStyle.Regular, GraphicsUnit.Pixel);
}
dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.DefaultCellStyle.Font = new Font("Calibri", 13F, FontStyle.Regular, GraphicsUnit.Pixel);
//if there is a blank entry fill it with 0 to avoid sql error
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[2].Value.ToString() == "")
{
dataGridView1.Rows[i].Cells[2].Value = "0";
}
}
}
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 = '******') ");
}
internal void EnterShareSkill()
{//GlobalDefinitions.WaitForElement(driver, By.,20)
GlobalDefinitions.wait(10);
GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ShareSkill");
//clcik on Shareskill button
ShareSkillButton.Click();
//Click on Title text box
Title.SendKeys(ExcelLib.ReadData(2, "Title"));
//Enter Description in Title
Description.SendKeys(ExcelLib.ReadData(2, "Description"));
//CLick on dropdown
CategoryDropDown.Click();
//Thread.Sleep(5000);
//Selecting option from Categorydropdown
SelectElement oselect = new SelectElement(SelectSubDropdown);
oselect.SelectByText(ExcelLib.ReadData(2, "Category"));
//Click on SubCategory
SubCategoryDropDown.Click();
//Selecting option from SubCategorydropdown
SelectElement subCategory = new SelectElement(SelectDropdown);
subCategory.SelectByValue(ExcelLib.ReadData(2, "SubCategory"));
//Enter Tags
Tags.SendKeys(ExcelLib.ReadData(2, "Tags"));
Tags.SendKeys(Keys.Enter);
//Select Service Type(Radio buttons)
switch (ExcelLib.ReadData(2, "ServiceType"))
{
case "One-off service":
OneOffType.Click();
break;
case "Hourly basis service":
HourlyType.Click();
break;
}
//Select Location Type (Radio buttons)
switch (ExcelLib.ReadData(2, "LocationType"))
{
case "On-site":
OnSiteLocationTypeOption.Click();
break;
case "Online":
OnlineLocationTypeOption.Click();
break;
}
GlobalDefinitions.WaitForElement(driver, By.XPath("//div[3]/div[2]/input[1]"), 10);
//Select Start Date
StartDateDropDown.Click();
Thread.Sleep(5000);
StartDateDropDown.SendKeys(ExcelLib.ReadData(2, "Startdate"));
GlobalDefinitions.WaitForElement(driver, By.Name("endDate"), 10);
//Select End Date
EndDateDropDown.Click();
EndDateDropDown.SendKeys(ExcelLib.ReadData(2, "Enddate"));
//DayAvailability
switch (ExcelLib.ReadData(2, "Selectday"))
{
case "Sun":
Sunday.Click();
SundayTime.SendKeys(ExcelLib.ReadData(2, "Starttime"));
SundayEndTime.SendKeys(ExcelLib.ReadData(2, "Endtime"));
break;
case "Mon":
Monday.Click();
MondayTime.SendKeys(ExcelLib.ReadData(2, "Starttime"));
MondayEndTime.SendKeys(ExcelLib.ReadData(2, "Endtime"));
break;
case "Tue":
Tuesday.Click();
TuesdayTime.SendKeys(ExcelLib.ReadData(2, "Starttime"));
TuesdayEndTime.SendKeys(ExcelLib.ReadData(2, "Endtime"));
break;
case "Wed":
Wednesday.Click();
WednesdayTime.SendKeys(ExcelLib.ReadData(2, "Starttime"));
WednesdayEndTime.SendKeys(ExcelLib.ReadData(2, "Endtime"));
break;
case "Thu":
Thursday.Click();
ThursdayTime.SendKeys(ExcelLib.ReadData(2, "Starttime"));
//MondayEndTime.SendKeys(ExcelLib.ReadData(2, "Endtime"));
break;
}
//Select Skill Trade Radio buttons)
switch (ExcelLib.ReadData(2, "SkillTrade"))
{
case "Skill-exchange":
FirstSkillTradeOption.Click();
break;
case "Credit":
SecondkillTradeOption.Click();
break;
}
//Enter Skill-Exchange
SkillExchange.SendKeys(ExcelLib.ReadData(2, "Skill-Exchange"));
SkillExchange.SendKeys(Keys.Enter);
//Enter WorkSample
//FileUpload.SendKeys(@"C:\Users\minty\OneDrive\Pictures\FIle1.txt");
GlobalDefinitions.WaitForElement(driver, By.XPath("//i[@Class = 'huge plus circle icon padding-25']"), 10);
FileUpload.Click();
AutoItX3 autoIt = new AutoItX3();
autoIt.WinActivate("Open");
Thread.Sleep(5000);
autoIt.Send(@"C:\Users\minty\OneDrive\Pictures\Camera Roll\Garry.jpeg");
Thread.Sleep(5000);
autoIt.Send("{ENTER}");
//Thread.Sleep(5000);
////WorkSample.Click();
//Select ACtive/Hidden Options ( Radio Buttons)
switch (ExcelLib.ReadData(2, "Active"))
{
case "Active":
ActiveOption.Click();
break;
case "Hidden":
HiddenOption.Click();
break;
}
//Click on Save
Save.Click();
// Assert.IsTrue("Service Listing Saved Successfully".Exist, "OK");
}
