public int SetAgricultureDetails(AgricultureDetails objAgricultureDetails)
{
SqlCommand sqlCmd = new SqlCommand();
int success = 0;
try
{
commandText = "SetAgricultureDetails";
sqlCmd.Parameters.AddWithValue("@UserId", objAgricultureDetails.UserId);
sqlCmd.Parameters.AddWithValue("@Rubber", objAgricultureDetails.Rubber);
sqlCmd.Parameters.AddWithValue("@Pepper", objAgricultureDetails.Pepper);
sqlCmd.Parameters.AddWithValue("@Tapioca", objAgricultureDetails.Tapioca);
sqlCmd.Parameters.AddWithValue("@Vegetables", objAgricultureDetails.Vegetables);
sqlCmd.Parameters.AddWithValue("@Cocoa", objAgricultureDetails.Cocoa);
sqlCmd.Parameters.AddWithValue("@Coconuttree", objAgricultureDetails.CoconutTree);
sqlCmd.Parameters.AddWithValue("@Vazha", objAgricultureDetails.Banana);
// sqlCmd.Parameters.AddWithValue("Area", objAgricultureDetails.Status);
success = objConnection.ExecuteSQLNonQuery(sqlCmd, CommandType.StoredProcedure, commandText);
}
catch (Exception ex)
{
throw ex;
}
return(success);
}
public AgricultureDetails GetAgricultureDetails(int userid)
{
DataSet objDataset = new DataSet();
AgricultureDetails obj = new AgricultureDetails();
try
{
SqlCommand sqlCmd = new SqlCommand();
commandText = "GetAgricultureDetails";
sqlCmd.Parameters.AddWithValue("@UserId", userid);
objDataset = objConnection.GetDataSet(sqlCmd, CommandType.StoredProcedure, commandText);
if (objDataset.Tables[0].Rows.Count > 0)
{
obj.UserId = (int)objDataset.Tables[0].Rows[0]["UserId"];
obj.Banana = (int)objDataset.Tables[0].Rows[0]["Vazha"];
obj.Cocoa = (int)objDataset.Tables[0].Rows[0]["Cocoa"];
obj.CoconutTree = (int)objDataset.Tables[0].Rows[0]["Coconuttree"];
obj.Pepper = (int)objDataset.Tables[0].Rows[0]["Pepper"];
obj.Rubber = (int)objDataset.Tables[0].Rows[0]["Rubber"];
obj.Tapioca = (int)objDataset.Tables[0].Rows[0]["Tapioca"];
obj.Vegetables = (int)objDataset.Tables[0].Rows[0]["Vegetables"];
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public int SetAgricultureDetails(AgricultureDetails objAgricultureDetails)
{
int success = 0;
try
{
success = objHomeDL.SetAgricultureDetails(objAgricultureDetails);
}
catch (Exception ex)
{
throw ex;
}
return(success);
}
public AgricultureDetails GetAgricultureDetails(int userid)
{
DataSet objDataset = new DataSet();
AgricultureDetails obj = new AgricultureDetails();
try
{
obj = objHomeDL.GetAgricultureDetails(userid);
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
