protected void btnView_OnClick(object sender, EventArgs e)
{
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
if (rbtndate.Checked == true)
{
fillgrid("date", Convert.ToDateTime(txtDate.Text, dtinfo));
}
else if (rbtnFollowupDate.Checked == true)
{
fillgrid("nextdate", Convert.ToDateTime(txtDate.Text, dtinfo));
}
GridCounselling.Focus();
}
protected void Grid_OnselectedIndexChanged(object sender, EventArgs e)
{
if (GridCounselling.Rows.Count > 0)
{
pnlCounselling.Visible = true; pnlhome.Visible = false;
fillProfile(Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString()));
rbtnFollowupDate.Checked = true;
SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString()) + "'", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridCounselling.DataSource = ds;
GridCounselling.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
pnlCounselling.Visible = false;
rbtndate.Checked = true;
maikal mk = new maikal();
int lvl = mk.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString());
txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtCurrentDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
SqlDataAdapter ad = new SqlDataAdapter("select * from Counselling where Date Between '" + Convert.ToDateTime(txtDate.Text, dtinfo).AddMonths(-1) + "' and '" + Convert.ToDateTime(txtDate.Text, dtinfo) + "'", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridCounselling.DataSource = ds;
GridCounselling.DataBind();
GridCounselling.Focus();
}
if (rbtnFollowupDate.Checked == true)
{
if (lblCID.Text.ToString() == null)
{
SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(lblCID.Text) + "'", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridCounselling.DataSource = ds;
GridCounselling.DataBind();
}
}
btnView.Focus();
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
private void fillgrid(string type, DateTime dt)
{
string qry = "";
if (type == "date")
{
qry = "select * from Counselling where Date='" + dt + "'";
}
else if (type == "nextdate")
{
qry = "select * from Followup where FollowUpDate='" + dt + "'";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridCounselling.DataSource = ds;
GridCounselling.DataBind();
}
protected void btnSubmit_Onclick(object sender, EventArgs e)
{
con.Close();
con.Open();
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
SqlCommand cmd = new SqlCommand("select max(CounsellingNo) from Followup where CID='" + lblCID.Text.ToString() + "'", con);
int inCid = Convert.ToInt32(cmd.ExecuteScalar());
cmd = new SqlCommand("update Followup set Response=@Response,Comments=@Comments,Counselor=@Counselor where CID='" + Convert.ToInt32(lblCID.Text) + "' and CounsellingNo='" + inCid + "'", con);
cmd.Parameters.AddWithValue("@Response", ddlResponse.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@Comments", txtdetail.Text.ToString());
cmd.Parameters.AddWithValue("@Counselor", txtCounselor.Text.ToString());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("insert into Followup(CounsellingNo,FollowUpDate,Response,Comments,Counselor,CID) Values(@CounsellingNo,@FollowUpDate,@Response,@Comments,@Counselor,@CID)", con);
cmd.Parameters.AddWithValue("@CounsellingNo", inCid + 1);
if (string.IsNullOrEmpty(txtNextDate.Text) || txtNextDate.Text == "")
{
cmd.Parameters.AddWithValue("@FollowUpDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FollowUpDate", Convert.ToDateTime(txtNextDate.Text.ToString(), dtinfo));
}
//cmd.Parameters.AddWithValue("@FollowUpDate", Convert.ToDateTime(txtNextDate.Text.ToString(), dtinfo));
cmd.Parameters.AddWithValue("@Response", ddlResponse.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@Comments", txtdetail.Text.ToString());
cmd.Parameters.AddWithValue("@Counselor", txtCounselor.Text.ToString());
cmd.Parameters.AddWithValue("@CID", Convert.ToInt32(lblCID.Text));
cmd.ExecuteNonQuery();
con.Close();
GridCounselling.Focus();
txtdetail.Text = "";
txtCounselor.Text = "";
}
