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); }