public void BindGrid()
{
DataSet ds = AgeCalculationClass.GetList(null, null, null, null, null, null);
DataView dv = new DataView(ds.Tables[0]);
//if (Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString()) == null)
//{
// ViewState["AgeCalculation"] = "id Desc";
//}
//dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void BtnSerach_Click1(object sender, EventArgs e)
{
DataSet ds = AgeCalculationClass.GetList(null, TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString());// null, null, null,null );
DataView dv = new DataView(ds.Tables[0]);
//String StrSort = Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString());
//if (StrSort != null)
//{
// dv.Sort = StrSort;
//}
GridView1.DataSource = dv;
GridView1.DataBind();
}
public void DeleteItem(object sender, System.EventArgs e)
{
String id = ((HtmlAnchor)sender).HRef.ToString();
int i = AgeCalculationClass.Delete(Convert.ToInt32(id));
if (i == 0)
{
LblMsg.Text = " error ";
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true);
}
else
{
BindGrid();
}
LightBox.Value = "0";
}
protected void BtnUpdate_Click1(object sender, EventArgs e)
{
int i = AgeCalculationClass.Update(TXTid.Text, TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString());
if (i == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا";
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ویرایش انجام شد";
BindGrid();
}
}
protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
int t = AgeCalculationClass.insert(TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString());
if (t == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا در ثبت";
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindGrid();
}
}
public void UpItem(object sender, EventArgs e)
{
String id = ((HtmlAnchor)sender).HRef.ToString();
DataSet ds = AgeCalculationClass.GetList(null, null, null, null, null, null);
DataRow dr = ds.Tables[0].Rows[0];
TXTid.Text = id;
TXTBonSize.Text = dr["BonSize"].ToString();
TXTGroupAge.Text = dr["GroupAge"].ToString();
DDyear.SelectedValue = dr["year"].ToString();
DDTreeType.SelectedValue = dr["TreeType"].ToString();
DDAgeTypeId.SelectedValue = dr["AgeTypeId"].ToString();
EmptyLight();
LightBox.Value = "1";
BtnInsert.Visible = false;
BtnSerach.Visible = false;
BtnUpdate.Visible = true;
}
