protected void gv_Students_RowCommand(object sender, GridViewCommandEventArgs e)
{
Achievement selTD = new Achievement();
AchievementDAO updTD = new AchievementDAO();
int updCnt;
String Status = "delete";
int AchievementId = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
updCnt = updTD.delete(AchievementId, LblAdminNo.Text, Status);
if (updCnt == 1)
{
Response.Redirect("AchievementPage.aspx");
}
}
else if (e.CommandName == "Edit")
{
Session["SSAchievementId"] = Convert.ToInt32(e.CommandArgument.ToString());
Response.Redirect("EditAchievement.aspx");
}
}
protected void BtnConfirm_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TbAchievementName.Text) || string.IsNullOrEmpty(TbAyearTaken.Text))
{
LblResult.Text = "pls fill in all the blank";
}
else
{
String Status = "active";
String AdminNo = lbAdminNo.Text.ToString();
String AchievementName = TbAchievementName.Text.ToString();
int AyearTaken = Convert.ToInt32(TbAyearTaken.Text.ToString());
AchievementDAO fmTd = new AchievementDAO();
int insCnt = fmTd.InsertTD(AchievementName, AyearTaken, AdminNo, Status);
if (insCnt == 1)
{
LblResult.Text = "Achievement Created!";
Response.Redirect("AchievementPage.aspx");
}
else
{
LblResult.Text = "Unable to insert Achievement, please inform system administrator!";
}
BtnConfirm.Enabled = false;
}
// complete the code
/*
* try
* {
* int tdRenewMode = Convert.ToInt16(DdlRenew.SelectedValue);
* timeDepositDAO fmTd = new timeDepositDAO();
* int insCnt = fmTd.InsertTD(tdAccount, tdCustId, tdPrincipal, tdTerm, tdIntRte, tdMaturityDte, tdMaturedAmt, tdInterest, tdRenewMode);
* if (insCnt == 1)
* {
* LblResult.Text = "Time Deposit Created!";
* }
* else
* {
* LblResult.Text = "Unable to insert time deposit, please inform system administrator!";
*
* }
* BtnConfirm.Enabled = false;
*
* }
* catch (FormatException)
* {
* LblResult.Text = "Select a renewal option!";
* }
*/
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["SSAchievementId"] != null)
{
int AchievementId = Convert.ToInt32(Session["SSAchievementId"]);
LblAchievementId.Text = AchievementId.ToString();
Achievement selTD = new Achievement();
AchievementDAO updTD = new AchievementDAO();
selTD = updTD.getAchievementById(AchievementId);
}
}
}
protected void BtnUpdate(object sender, EventArgs e)
{
int AchievementId = Convert.ToInt32(Session["SSAchievementId"]);
Achievement selTD = new Achievement();
AchievementDAO updTD = new AchievementDAO();
int AyearTaken = Convert.ToInt32(TbAyearTaken.Text.ToString());
int updCnt;
updCnt = updTD.Edit(AchievementId, TbAchievementName.Text, AyearTaken);
if (string.IsNullOrEmpty(TbAchievementName.Text) || string.IsNullOrEmpty(TbAyearTaken.Text))
{
LblResult.Text = "pls fill in all the blank";
}
else
{
if (updCnt == 1)
{
Response.Redirect("AchievementPage.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//LblAdminNo.Text = Session["SSAdminNo"].ToString();
//String adminNo = LblAdminNo.Text.ToString();
//string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
//SqlConnection myConn = new SqlConnection(DBConnect);
//SqlCommand cmd1 = new SqlCommand("select * from Achievement where AdminNo = adminNo", myConn);
//SqlDataAdapter sda1 = new SqlDataAdapter(cmd1);
//DataTable dt = new DataTable();
//sda1.Fill(dt);
//GridView_Achievement.DataSource = dt;
//GridView_Achievement.DataBind();
LblAdminNo.Text = Session["AdminNo"].ToString();
String adminNo = LblAdminNo.Text.ToString();
AchievementDAO tdDAO = new AchievementDAO();
List <Achievement> tdList = new List <Achievement>();
tdList = tdDAO.getAchievement(LblAdminNo.Text);
GridView_Achievement.DataSource = tdList;
GridView_Achievement.DataBind();
LblAdminNo.Visible = false;
}