public PTWWS DoRetrieveLatestPTWWSByRId(int rid)
{
try
{
using (NpgsqlConnection connection = new NpgsqlConnection())
{
connection.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ToString();
connection.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = connection;
cmd.CommandText = "Select * from PTWWS WHERE rid=@rid order by ptwwsid DESC";
cmd.CommandType = CommandType.Text;
NpgsqlDataAdapter da = new NpgsqlDataAdapter(cmd);
da.SelectCommand.Parameters.AddWithValue("@rid", rid);
DataTable dt = new DataTable();
da.Fill(dt);
cmd.Dispose();
connection.Close();
int id = Convert.ToInt32(dt.Rows[0]["ptwwsid"].ToString());
int rId = Convert.ToInt32(dt.Rows[0]["rid"].ToString());
PTWWS ptwws = new PTWWS(id, rId);
return(ptwws);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
UserAccount user = (UserAccount)Session["UserAccountObj"];
RiderBLL riderbll = new RiderBLL();
Rider rider = riderbll.DoRetrieveRiderByID(user.UserId);
if (rider.IsFullTime == true)
{
Response.Redirect("RetrieveLatestMWSWWS.aspx");
}
if (!IsPostBack)
{
PTWWSBLL ptwwsbll = new PTWWSBLL();
DataTable ptwwsdt = new DataTable();
ptwwsdt = ptwwsbll.DoRetrieveAllPTWWSByRId(user.UserId);
for (int i = 0; i < ptwwsdt.Rows.Count; i++)
{
string theValue = ptwwsdt.Rows[i].ItemArray[0].ToString();
ddlOption.Items.Add(theValue);
}
}
if (ddlOption.SelectedItem.Text == "Remaining Schedule")
{
DataTable dt = new DataTable();
PTDayScheduleBLL ptdsbll = new PTDayScheduleBLL();
PTWWSBLL ptwwsbll = new PTWWSBLL();
PTWWS latestptwws = ptwwsbll.DoRetrieveLatestPTWWSByRId(user.UserId);
//currently it is based on today's date. If I want to perform testing, I have to manually change the Datetime to some other dates instead
//DateTime datetest = new DateTime(2020, 4, 26);
if (latestptwws != null)
{
dt = ptdsbll.DoRetrieveUnfulfilledPTWWSByPTWWSId(latestptwws.PtwwsId, DateTime.Now);
}
if (dt != null)
{
gv_schedule.DataSource = dt;
gv_schedule.DataBind();
}
else
{
lblNotWorking.Text = "Unable to retrieve list of schedule";
}
}
else if (ddlOption.SelectedItem.Text != "Select Schedule to View")
{
DataTable dt = new DataTable();
PTDayScheduleBLL ptdsbll = new PTDayScheduleBLL();
//dt = wwsbll.DoRetrieveAllWWSByMWSId(latestmws.MwsId);
//string value = "4/26/2020";
//DateTime datetest = DateTime.Parse(value);
DateTime datetest = new DateTime(2020, 4, 26);
dt = ptdsbll.DoRetrievePTWWSByPTWWSId(Convert.ToInt32(ddlOption.SelectedValue.ToString()));
if (dt != null)
{
gv_schedule.DataSource = dt;
gv_schedule.DataBind();
}
else
{
lblNotWorking.Text = "Unable to retrieve list of scheudle";
}
}
}
