protected void LoadGroupDetails()
{
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string sql = "select * from Groups where TeacherID='" + Session["TeacherId"].ToString() + "'";
//sql = "Select * from StudentInformation where TeacherId='"+Session["TeacherId"].ToString()+"'";
SqlDataAdapter AdapterGroupInformation = new SqlDataAdapter(sql, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(AdapterGroupInformation);
DataSet ds = new DataSet();
AdapterGroupInformation.Fill(ds, "GroupInformation");
GridViewGroupDetails.DataSource = ds.Tables["GroupInformation"];
GridViewGroupDetails.DataBind();
}
protected void Populate_Details(int groupno)
{
string storedprocedure = "GetComissionDetails";
SqlConnection cn = GetSqlCon.GetCon();
if (cn == null)
{
Response.Redirect("~/Error.aspx");
}
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(storedprocedure, cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@param1", groupno);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
GridViewGroupDetails.DataSource = dt;
GridViewGroupDetails.DataBind();
cn.Close();
GridViewGroupDetails.Visible = true;
foreach (GridViewRow row in GridViewGroupDetails.Rows)
{
int id, price;
int.TryParse(row.Cells[0].Text, out id);
price = Commissions.GetPrice(id);
Label LabelPrice = row.FindControl("LabelPrice") as Label;
if (price != 0)
{
LabelPrice.Text = price.ToString();
}
else
{
Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button;
Button BtnRejectComission = row.FindControl("BtnRejectComission") as Button;
BtnAcceptComission.Visible = false;
BtnRejectComission.Visible = false;
LabelPrice.Text = "N/A";
}
}
}