protected void login_Click(object sender, EventArgs e)
{
dboperation db = new dboperation();
string s = "select *from login where username='******' and password='******'";
DataTable dt = db.ret(s);
if (dt.Rows.Count > 0)
{
Session["userid"] = dt.Rows[0][0].ToString();
string a = dt.Rows[0][3].ToString();
if (a == "Farmer")
{
Response.Redirect("farmerhome.aspx");
}
else if (a == "AO")
{
string b = "select KID from AOS where aid=" + dt.Rows[0][0] + "";
DataTable d = db.ret(b);
Session["kid"] = d.Rows[0][0].ToString();
Response.Redirect("agrihome.aspx");
}
else
{
Response.Redirect("adminhome.aspx");
}
}
else
{
Response.Write("<script>alert('Incorrect password & username...')</script>");
}
}
void grid1()
{
string a = "select * from cropdetails";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
void grid()
{
string s = "select * from message";
DataTable dt = db.ret(s);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string s = " select * from notification";
DataTable dt = db.ret(s);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
}
public string notification()
{
string result = " ";
string s = "select * from notification";
DataTable dt = op.ret(s);
foreach (DataRow dr in dt.Rows)
{
result = dr[0].ToString() + "#" + dr[1].ToString() + "#" + dr[2].ToString() + "#" + dr[3].ToString() + "@" + result;
}
return(result);
}
void grid()
{
string a = "select * from article";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
protected void search_Click(object sender, EventArgs e)
{
string a = " select Landdetails.surveyno, Landdetails.area, Landdetails.type, farmer.Name, farmer.place, farmer.contactno, Landdetails.FID, farmer.FID from Landdetails inner join farmer ON Landdetails.FID = farmer.FID where Landdetails.KID=" + Session["kid"] + " and farmer.Name like '%" + fname.Text + "%'";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View1);
string a = "select culturingmethod.cropid, cropdetails.cropname, culturingmethod.cultureingmethod, culturingmethod.weatherdetails from culturingmethod inner join cropdetails on culturingmethod.cropid = cropdetails.cropid";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
string s = "select cropid ,cropname from cropdetails";
dt = db.ret(s);
DropDownList1.DataTextField = "cropname";
DropDownList1.DataValueField = "cropid";
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "select");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View1);
string a = "select * from notification";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View1);
string a = "select * from governmentpolicies";
DataTable dt = db.ret(a);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
string b = "select max(policyno) from governmentpolicies";
policy_no.Text = db.maxid(b).ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View1);
string s = "select KID , placename from krishibhavan";
DataTable dt = db.ret(s);
DropDownList1.DataTextField = "placename";
DropDownList1.DataValueField = "KID";
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "select");
string d = "select * from AOS";
dt = db.ret(d);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
for (int i = 1; i <= 31; i++)
{
DropDownList2.Items.Add(i.ToString());
DropDownList5.Items.Add(i.ToString());
DropDownList8.Items.Add(i.ToString());
}
for (int i = 1; i <= 12; i++)
{
DropDownList3.Items.Add(i.ToString());
DropDownList6.Items.Add(i.ToString());
DropDownList9.Items.Add(i.ToString());
}
for (int i = 1900; i <= 3000; i++)
{
DropDownList4.Items.Add(i.ToString());
DropDownList7.Items.Add(i.ToString());
DropDownList10.Items.Add(i.ToString());
}
}
}
