protected void btn_Submit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Elderlies objElder = new Elderlies();
objElder.ElderID = Request.QueryString["elderid"];
if (dd_Volunteer.SelectedIndex != 0)
{
objElder.volunteer = dd_Volunteer.SelectedValue;
}
int errorCode = objElder.updateVol();
if (errorCode == 0)
{
lblMessage.Text = "Updated";
}
else if (errorCode == -2)
{
lblMessage.Text = "Fail";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Elderlies objElder = new Elderlies();
objElder.ElderID = Request.QueryString["ElderID"];
objElder.getDetails();
objElder.status = objElder.getStatus();
lblElderName.Text = objElder.FullName;
lblElderID.Text = objElder.SerialNo;
lblAddress.Text = objElder.Address;
lblMeal.Text = objElder.Meal;
if (objElder.getStatus() == "Y")
{
rblSuccess.SelectedIndex = 0;
}
else if (objElder.getStatus() == "P")
{
rblSuccess.SelectedIndex = 1;
txtFeedback.Visible = true;
}
else
{
rblSuccess.SelectedIndex = 2;
txtFeedback.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet result = new DataSet();
Elderlies objElder = new Elderlies();
int errorCode = objElder.displayElderListStatusYes(ref result);
if (errorCode == 0)
{
gvElderY.DataSource = result.Tables["ElderDetails"];
gvElderY.DataBind();
}
int errorCode2 = objElder.displayElderListStatusNoWithRemarks(ref result);
if (errorCode2 == 0)
{
gvElderN.DataSource = result.Tables["ElderDetails3"];
gvElderN.DataBind();
}
int errorCode3 = objElder.displayElderListStatusP(ref result);
if (errorCode3 == 0)
{
gvElderP.DataSource = result.Tables["ElderDetails2"];
gvElderP.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
displayVolunteerDropDownList();
if (Request.QueryString["elderid"] != null)
{
Elderlies objElder = new Elderlies();
objElder.ElderID = Request.QueryString["elderid"];
int errorCode = objElder.getDetails();
if (errorCode == 0)
{
lblName.Text = objElder.FullName;
lblSerialNo.Text = objElder.SerialNo;
dd_Volunteer.SelectedValue = objElder.volunteer.ToString();
}
else if (errorCode == -2)
{
lblMessage.Text = "Unable to retrieve Elder details for ID " + objElder.ElderID;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Elderlies objElder = new Elderlies();
if (!Page.IsPostBack)
{
if (Request.QueryString["elderid"] != null)
{
objElder.ElderID = (Request.QueryString["elderid"]);
int errorCode = objElder.getDetails();
if (errorCode == 0)
{
lblName.Text = objElder.FullName;
lblSerialNo.Text = objElder.SerialNo;
dd_Prepare.SelectedValue = objElder.Prepare.ToString();
ddlTiming.SelectedValue = objElder.Timing.ToString();
}
else if (errorCode == -2)
{
lblMessage.Text = "Unable to retrieve Elder details for ID " + objElder.ElderID;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
if (objElder.getMeal() == "Lunch")
{
rblMeal.SelectedIndex = 0;
}
else
{
rblMeal.SelectedIndex = 1;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Elderlies objElder = new Elderlies();
objElder.ElderID = Request.QueryString["ElderID"];
objElder.getDetails();
objElder.status = objElder.getStatus();
if (rblSuccess.SelectedIndex == 0)
{
lblChanges.Text = objElder.setSuccess();
txtFeedback.Visible = false;
}
else
{
lblChanges.Text = objElder.setUnsuccess();
txtFeedback.Visible = true;
//Feedback coding
if (txtFeedback.Text.Length > 1)
{
Volunteers objVolunteer = new Volunteers();
objVolunteer.EmailAddr = Session["LoginID"].ToString();
objVolunteer.Password = objVolunteer.getPass();
objVolunteer.getDetails();
string feedbacktext = txtFeedback.Text;
string strConn = ConfigurationManager.ConnectionStrings["P2ConnectionString"].ToString();
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("INSERT INTO Feedback(VolunteerID, ElderID, Feedback, DateCreated) Output inserted.FeedbackID " +
"Values(@volunteerid, @ElderID, @feedbacktext, GetDate())", conn);
string elderid = Request.QueryString["ElderID"];
cmd.Parameters.AddWithValue("@volunteerid", objVolunteer.VolunteerID);
cmd.Parameters.AddWithValue("@ElderID", elderid);
cmd.Parameters.AddWithValue("@feedbacktext", feedbacktext);
SqlDataAdapter daFeedback = new SqlDataAdapter(cmd);
DataSet result = new DataSet();
conn.Open();
int id = cmd.ExecuteNonQuery();
conn.Close();
lblFeedback.Text = "Success Sent!";
}
else
{
lblFeedback.Text = "Error!";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet result = new DataSet();
Elderlies objElder = new Elderlies();
int errorCode = objElder.getDetailsOnly(ref result);
if (errorCode == 0)
{
gvElderDetails.DataSource = result.Tables["ElderDetails"];
gvElderDetails.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet result = new DataSet();
Elderlies objElder = new Elderlies();
Volunteers objVolunteer = new Volunteers();
objVolunteer.EmailAddr = Session["LoginID"].ToString();
objVolunteer.getPass();
objVolunteer.getId();
int errorCode = objVolunteer.getPrepare(ref result);
if (errorCode == 0)
{
gvElderPrepare.DataSource = result.Tables["ElderDetails"];
gvElderPrepare.DataBind();
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Elderlies objelder = new Elderlies();
objelder.ElderID = Request.QueryString["elderID"];
int errorCode = objelder.setStatus();
int errorCode1 = objelder.deleteFeedback();
if (errorCode == 0)
{
lblMessage.Text = "Done Create Meal";
}
else
{
lblMessage.Text = "Error";
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Elderlies objelder = new Elderlies();
objelder.ElderID = Request.QueryString["elderID"];
if (dd_Prepare.SelectedIndex == 0)
{
objelder.Prepare = "Completed";
}
else
{
objelder.Prepare = "Still Progressing";
}
int errorCode = objelder.update();
if (rblMeal.SelectedIndex == 0 && ddlTiming.SelectedIndex == 0)
{
lblMealTiming.Text = objelder.setLunch();
}
if (rblMeal.SelectedIndex == 1 && ddlTiming.SelectedIndex == 1)
{
lblMealTiming.Text = objelder.setDinner();
}
if (errorCode == 0)
{
lblMessage.Text = "Elder record has been updated successfully";
}
else if (errorCode == -2)
{
lblMessage.Text = "Unable to save record as elder is not found";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
