public static bool registerFarmer(farmers c)
{
bool status = false;
try
{
using (MySqlConnection con = new MySqlConnection(connString)) //DI via Constructor
{
if (con.State == ConnectionState.Closed) //if connection is closed?
{
con.Open();
}
string query = "INSERT INTO farmers (fisrtname,lastname,emailID,password,contact, address) " +
"VALUES ( @FirstName, @Lastname, @emailId, @password,@contact,@address)";
MySqlCommand cmd = new MySqlCommand(query, con);
//cmd.Parameters.Add(new MySqlParameter("@default", default));
cmd.Parameters.Add(new MySqlParameter("@FirstName", c.FirstName));
cmd.Parameters.Add(new MySqlParameter("@Lastname", c.LastName));
cmd.Parameters.Add(new MySqlParameter("@emailId", c.Email));
cmd.Parameters.Add(new MySqlParameter("@password", c.password));
cmd.Parameters.Add(new MySqlParameter("@contact", c.contact));
cmd.Parameters.Add(new MySqlParameter("@address", c.address));
cmd.ExecuteNonQuery();
con.Close();
status = true;
}
}
catch (MySqlException exp)
{
string message = exp.Message;
}
return(status);
}
public ActionResult RegFarmer(String firstname, String lastname, String email, String password, String cpassword, String contact, String address)
{
if (password == cpassword)
{
farmers c = new farmers
{
FirstName = firstname,
LastName = lastname,
Email = email,
password = password,
contact = contact,
address = address
};
bool status = BusinessManager.regFarmer(c);
if (status)
{
return(RedirectToAction("loginFarmer", "farmers"));
}
}
// var customer = new Customer();
return(View());
}
public static List <farmers> SelectAllFarmers()
{
List <farmers> allfarmers = new List <farmers>();
IDbConnection conn = new MySqlConnection();
conn.ConnectionString = connString;
string query = "Select * from farmers";
IDbCommand cmd = new MySqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
MySqlDataAdapter da = new MySqlDataAdapter(cmd as MySqlCommand);
DataSet ds = new DataSet();
try
{
//farmerID, FisrtName, LastName, emailID, password, contact, address
da.Fill(ds);
DataRowCollection rows = ds.Tables[0].Rows;
foreach (DataRow row in rows)
{
farmers farmer = new farmers();
farmer.farmerId = int.Parse(row["farmerId"].ToString());
farmer.FirstName = row["FisrtName"].ToString();
farmer.LastName = row["LastName"].ToString();
farmer.Email = row["emailID"].ToString();
farmer.password = row["password"].ToString();
farmer.address = row["address"].ToString();
farmer.contact = row["contact"].ToString();
allfarmers.Add(farmer);
}
}
catch (MySqlException e)
{
string message = e.Message;
}
return(allfarmers);
}
public static bool regFarmer(farmers c)
{
return(DBManager.registerFarmer(c));
}
