protected void Page_Load(object moveIcon, EventArgs e) { btn_excel.Visible = false; int cbo_day_index = cbo_day.SelectedIndex; int cbo_week_index = cbo_week.SelectedIndex; int cbo_farm_index = cbo_farm.SelectedIndex; ((Label)Master.FindControl("lbl_title")).Text = "Report"; SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["KiwihortData"].ConnectionString); con.Open(); dateConverter d = new dateConverter(); SqlCommand comMin = new SqlCommand("SELECT min(Day) FROM tbl_Duty", con); SqlCommand comMax = new SqlCommand("SELECT max(Day) FROM tbl_Duty", con); SqlDataReader readerMin = comMin.ExecuteReader(); readerMin.Read(); if (readerMin.HasRows == true && String.Compare(readerMin.GetValue(0).ToString(), null) != 0) { btn_submit.Enabled = true; DateTime dayMin = d.convertUTCtoNZT(readerMin.GetDateTime(0)); DateTime dayMax = d.convertUTCtoNZT((DateTime)comMax.ExecuteScalar()); cbo_day.Items.Clear(); cbo_farm.Items.Clear(); cbo_day.Items.Add("Select a day"); for (var count = dayMax; count >= dayMin; count = count.AddDays(-1)) { cbo_day.Items.Add(new ListItem(count.Date.ToString("d/M/yyyy") + " - " + count.DayOfWeek.ToString(), d.convertNZTtoUTC(count.Date).ToString())); } var firstRun = true; cbo_week.Items.Clear(); cbo_week.Items.Add("Select a week"); //for (var count = dayMin; count <= dayMax; dayMin = dayMin.AddDays(1), count = count.AddDays(1)) //{ // while (dayMin.DayOfWeek.ToString() != "Monday") // { // if (firstRun) // { // dayMin = dayMin.AddDays(-1); // } // else // { // dayMin = dayMin.AddDays(1); // count = count.AddDays(1); // } // } // firstRun = false; // cbo_week.Items.Add(new ListItem(dayMin.Day.ToString() + "/" + dayMin.Month.ToString() + "/" + dayMin.Year.ToString(), d.convertNZTtoUTC(dayMin).ToString())); //} for (var count = dayMax; count >= dayMin; dayMax = dayMax.AddDays(-1), count = count.AddDays(-1)) { while (dayMax.DayOfWeek.ToString() != "Monday") { if (firstRun) { dayMax = dayMax.AddDays(-1); } else { dayMax = dayMax.AddDays(-1); count = count.AddDays(-1); } } firstRun = false; cbo_week.Items.Add(new ListItem(dayMax.Day.ToString() + "/" + dayMax.Month.ToString() + "/" + dayMax.Year.ToString(), d.convertNZTtoUTC(dayMax).ToString())); } } else { btn_submit.Enabled = false; } SqlCommand comFarm = new SqlCommand("SELECT Farm_Name, farmid FROM tbl_farms WHERE GrowerID = @0", con); comFarm.Parameters.AddWithValue("@0", Session["Id"].ToString()); SqlDataReader reader = comFarm.ExecuteReader(); if (reader.HasRows) { cbo_farm.Items.Add("Select a farm"); while (reader.Read()) { cbo_farm.Items.Add(new ListItem(reader.GetString(0), reader.GetString(1))); } } cbo_day.SelectedIndex = cbo_day_index; cbo_week.SelectedIndex = cbo_week_index; cbo_farm.SelectedIndex = cbo_farm_index; }
protected void Page_Load(object sender, EventArgs e) { int cbo_day_index = cbo_day.SelectedIndex; int cbo_farm_index = cbo_farm.SelectedIndex; GridView1.Visible = false; SqlConnection con2 = new SqlConnection(WebConfigurationManager.ConnectionStrings["KiwihortData"].ConnectionString); con2.Open(); dateConverter d = new dateConverter(); SqlCommand comMin = new SqlCommand("SELECT min(Day) FROM tbl_Duty", con2); SqlCommand comMax = new SqlCommand("SELECT max(Day) FROM tbl_Duty", con2); SqlDataReader readerMin = comMin.ExecuteReader(); readerMin.Read(); if (readerMin.HasRows == true && String.Compare(readerMin.GetValue(0).ToString(), null) != 0) { btn_submit.Enabled = true; DateTime dayMin = d.convertUTCtoNZT(readerMin.GetDateTime(0)); DateTime dayMax = d.convertUTCtoNZT((DateTime)comMax.ExecuteScalar()); cbo_day.Items.Clear(); cbo_farm.Items.Clear(); cbo_day.Items.Add("Select a day"); for (var count = dayMax; count >= dayMin; count = count.AddDays(-1)) { cbo_day.Items.Add(new ListItem(count.Date.ToString("d/M/yyyy") + " - " + count.DayOfWeek.ToString(), d.convertNZTtoUTC(count.Date).ToString())); } } else { } SqlCommand comFarm = new SqlCommand("SELECT Farm_Name, farmid FROM tbl_farms WHERE GrowerID = @0", con2); comFarm.Parameters.AddWithValue("@0", Session["Id"].ToString()); SqlDataReader reader1 = comFarm.ExecuteReader(); if (reader1.HasRows) { cbo_farm.Items.Add("Select a farm"); while (reader1.Read()) { cbo_farm.Items.Add(new ListItem(reader1.GetString(0), reader1.GetString(1))); } } cbo_day.SelectedIndex = cbo_day_index; cbo_farm.SelectedIndex = cbo_farm_index; SqlDataSource1.SelectCommand = "SELECT RTRIM(firstname) + ' ' + RTRIM(lastname) AS name, '$' + CAST(CAST(tbl_pay.pay AS MONEY) AS VARCHAR(MAX)) AS payrate FROM tbl_worker INNER JOIN tbl_pay ON tbl_worker.payrate = tbl_pay.payID INNER JOIN[dbo].[tbl_employees] on[dbo].[tbl_employees].[workersid]= [tbl_worker].[WorkersId] where[dbo].[tbl_employees].[growersid]=@0"; SqlDataSource1.SelectParameters.Clear(); SqlDataSource1.SelectParameters.Add("0", Session["Id"].ToString()); SqlDataSource1.DataBind(); if (Session["Id"] == null) { Response.Redirect("~/login.aspx"); } ((Label)Master.FindControl("lbl_title")).Text = "Worker Pay"; // RequiredFieldValidator2.ControlToValidate = txtsubject; con2.Close(); if (!IsPostBack) { SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["KiwihortData"].ConnectionString); con.Open(); SqlCommand com = new SqlCommand("SELECT [tbl_worker].[FirstName], [tbl_worker].[LastName], [tbl_worker].[WorkersId] FROM [tbl_worker] INNER JOIN [tbl_login] ON [tbl_login].[Id]=[tbl_worker].[WorkersId] INNER JOIN [dbo].[tbl_employees] on [dbo].[tbl_employees].[workersid]= [tbl_worker].[WorkersId] where [dbo].[tbl_employees].[growersid]=@0 ORDER BY [tbl_worker].[FirstName]", con); com.Parameters.AddWithValue("@0", Session["Id"]); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { if (reader.HasRows == true && String.Compare(reader.GetValue(0).ToString(), null) != 0) { cbo_worker.Items.Add(new ListItem(Convert.ToString(reader["FirstName"]) + " " + Convert.ToString(reader["LastName"]), Convert.ToString(reader["workersId"]))); } } cbo_worker_SelectedIndexChanged(null, null); } }