public static bool updateCrop(CropFarmer 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 = "Update cropfarmerxref set qty_left = '" + c.qty_left + "',added_on='" + c.added_on + "' Where cropid='" + c.cid + "'"; MySqlCommand cmd = new MySqlCommand(query, con); //cmd.Parameters.Add(new MySqlParameter("@default", default)); cmd.ExecuteNonQuery(); con.Close(); status = true; } } catch (MySqlException exp) { string message = exp.Message; } return(status); }
public ActionResult Update(int cid, string crop_name, int quantity, int unit_price) { if (Session["UserData"] != null) { int id = int.Parse(Session["UserData"].ToString()); CropFarmer c = new CropFarmer { fid = id, cid = cid, added_on = DateTime.Now, qty_left = quantity }; crops c1 = BusinessManager.getcrop(cid); int totalquantity = c1.quantity + c.qty_left; c.qty_left = totalquantity; BusinessManager.updateCrop(c); bool status = BusinessManager.updateCropquantity(cid, totalquantity); if (status) { return(RedirectToAction("displayAllCrops", "crops")); } else { return(View()); } } return(RedirectToAction("loginfarmerdis", "farmers")); }
public ActionResult RegisterCrops(int cid, int quantity, int unit_price) { if (Session["UserData"] != null) { int id = int.Parse(Session["UserData"].ToString()); // bool status = BusinessManager.AddCrop(c); DateTime date = DateTime.Now; int totalquantity = 0; crops c = new crops(); List <CropFarmer> cf = BusinessManager.getcropfarmerByID(id); foreach (CropFarmer i in cf) { if (i.cid == cid) { c = BusinessManager.getcrop(cid); totalquantity = c.quantity + i.qty_left; i.qty_left = totalquantity; i.added_on = DateTime.Now; BusinessManager.updateCrop(i); BusinessManager.updateCropquantity(cid, totalquantity); } } BusinessManager.AddCrop_xref(id, cid, date, quantity); c = BusinessManager.getcrop(cid); CropFarmer cf1 = BusinessManager.getcropFarmer(cid); totalquantity = c.quantity + cf1.qty_left; BusinessManager.updateCropquantity(cid, totalquantity);//main crop table return(RedirectToAction("displayAllCrops", "crops")); } return(RedirectToAction("loginfarmer", "farmers")); }
public static List <CropFarmer> getcropFarmerBYFarmerID(int id) { List <CropFarmer> listcrop = new List <CropFarmer>(); IDbConnection conn = new MySqlConnection(); conn.ConnectionString = connString; string query = "Select * from cropfarmerxref WHERE farmerID=" + id; IDbCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Connection = conn; MySqlDataAdapter da = new MySqlDataAdapter(cmd as MySqlCommand); DataSet ds = new DataSet(); try { //cropID, crop_name, added_on, category, description, quantity, unit_price, image da.Fill(ds); DataRowCollection rows = ds.Tables[0].Rows; foreach (DataRow row in rows) { CropFarmer thecrops = new CropFarmer(); thecrops.cid = int.Parse(row["cropID"].ToString()); thecrops.fid = int.Parse(row["farmerID"].ToString()); thecrops.added_on = DateTime.Parse(row["added_on"].ToString()); thecrops.qty_left = int.Parse(row["qty_left"].ToString()); listcrop.Add(thecrops); } } catch (MySqlException e) { string message = e.Message; } // implementation return(listcrop); }
public static bool updateCrop(CropFarmer c) { return(DBManager.updateCrop(c)); }