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);
}
}
