private void getFarInfoonLoad()
{
try
{
GridLandRecord.DataSource = null;
GridLandRecord.DataBind();
//SqlObj = new SqlString(ComObj);
string strsql = "SELECT FRG.DistNo_LRMP DistID_LRMP, FRG.Tehsile_ID as TehsileID,FRG.Village_Code as Vcode, LRVM.Villagename as village ,FRG.FarmerId as FarmerId ,FRG.FarmerName as FarmerName,FRG.FatherHusName as FarmerFatHUS, FRG.Gram_Panchayat, FRG.PatwariHalkaNo, LRTM.Tehsilname as Tehsil, LRDM .Distname as Distname,FRG.Mobileno Mobileno, FRG.Category Category , FRG.RinPustikaNo as RinPustikaNo, FRG.Farmer_EID_UID_No as EIDUIDNo, FRG.Farmer_BankName as Bankname, FRG.Farmer_BankAccountNo as AccNo, FRG.Procured_SocietyID, FRG.Procured_Dist_ID, FRG.Procured_Place as PrcPlace , FRG.Col_MaxQty,Category.Category ,CONVERT(VARCHAR(15), FRG.CropDep_Date, 106) as CropDepDate FROM FarmerRegistration FRG left join LR_VillageMaster LRVM on FRG.DistNo_LRMP=LRVM.Distno and FRG.Tehsile_ID=LRVM.Tehsilno and FRG.Village_Code=LRVM.Villageno left join LR_TehsilMaster LRTM on FRG.Tehsile_ID =LRTM.Distno and FRG.Tehsile_ID=LRTM.Tehsilno left join LR_DistrictMaster LRDM on FRG.DistNo_LRMP =LRDM.Distno left join Category on Category.Category_ID=FRG.Category where FRG.DistNo_LRMP='" + DDL_Dist.SelectedItem.Value.ToString() + "' order by FarmerId";
con.Open();
cmd = new SqlCommand(strsql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "farInfo");
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
GridLandRecord.DataSource = ds.Tables[0];
GridLandRecord.DataBind();
}
}
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
protected void GridLandRecord_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int i = e.RowIndex;
if (GridLandRecord.Rows.Count < 1)
{
ViewState["ckstat"] = "Delete";
}
((DataTable)Session["dt1"]).Rows[i].Delete();
((DataTable)Session["dt1"]).AcceptChanges();
GridLandRecord.DataSource = (DataTable)Session["dt1"];
GridLandRecord.DataBind();
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
protected void btn_LandReocord_Click(object sender, EventArgs e)
{
if (ddl_GridVillage.SelectedIndex > 0 && ddl_GridCrop.SelectedIndex > 0 && txt_Grid_KhasaraNo.Text != "" && txt_Grid_rakaba.Text != "" && txt_Grid_RKBSinchit.Text != "" && txt_Grid_RKBASinchit.Text != "" && txt_Grid_AchinchitQty.Text != "" && txt_Grid_AsinchitQty.Text != "" && txt_Grid_PrcQty.Text != "")
{
if (ddl_LandType.SelectedValue.ToString() == "Sikami")
{
if (txt_MoolBhoSwamiName.Text == "" || txt_Grid_MoolRinPustikaNo.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('मूल भूमि स्वामी से संबन्धित विवरण भरीये .... '); </script> ");
return;
}
}
if (Session["dt1"] == null)
{
Dt1 = CreateTable();
Session["dt1"] = Dt1;
}
DataRow dr = ((DataTable)Session["dt1"]).NewRow();
((DataTable)Session["dt1"]).AcceptChanges();
if (ddl_GridVillage.SelectedIndex != 0)
{
dr["VillageName"] = ddl_GridVillage.SelectedItem.Text;
dr["Village_ID"] = ddl_GridVillage.SelectedValue;
}
else
{
dr["VillageName"] = "";
dr["Village_ID"] = "";
}
if (ddl_GridCrop.SelectedIndex != 0)
{
dr["crop_Name"] = ddl_GridCrop.SelectedItem.Text;
dr["Crop_Id"] = ddl_GridCrop.SelectedValue;
}
else
{
dr["crop_Name"] = "";
dr["Crop_Id"] = "";
}
dr["MoolBhoSwami"] = txt_MoolBhoSwamiName.Text.Trim();
dr["BhoSwamiRinPustikaNo"] = txt_Grid_MoolRinPustikaNo.Text.Trim();
dr["khasarano"] = txt_Grid_KhasaraNo.Text.Trim();
dr["rakba"] = txt_Grid_rakaba.Text.Trim();
dr["Rakba_crop_sinchit"] = txt_Grid_RKBSinchit.Text.Trim();
dr["Rakba_crop_asinchit"] = txt_Grid_RKBASinchit.Text.Trim();
dr["Rakba_crop_sinchit_qty"] = txt_Grid_AchinchitQty.Text.Trim();
dr["Rakba_crop_asinchit_qty"] = txt_Grid_AsinchitQty.Text.Trim();
dr["Procured_qty"] = txt_Grid_PrcQty.Text.Trim();
dr["LandType"] = ddl_LandType.SelectedValue;
((DataTable)Session["dt1"]).Rows.Add(dr);
((DataTable)Session["dt1"]).AcceptChanges();
GridLandRecord.DataSource = (DataTable)Session["dt1"];
GridLandRecord.DataBind();
txt_MoolBhoSwamiName.Text = "";
txt_Grid_MoolRinPustikaNo.Text = "";
txt_Grid_KhasaraNo.Text = "";
txt_Grid_rakaba.Text = "";
txt_Grid_RKBSinchit.Text = "";
txt_Grid_RKBASinchit.Text = "";
txt_Grid_AchinchitQty.Text = "";
txt_Grid_AsinchitQty.Text = "";
txt_Grid_PrcQty.Text = "";
}
else
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('भूमि से संबन्धित सभी विवरण भरीये .... '); </script> ");
}
}
