public ActionResult Edit(ProgressOrb _friend) { string endda = _friend.tgl; string tglB = endda.Substring(0, 2); string blnB = endda.Substring(3, 2); string thnB = endda.Substring(6, 4); string NewEndda = thnB + "/" + blnB + "/" + tglB; using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PPIC"].ConnectionString)) { string sqlQuery = "Update tProgressOrb Set progress = " + _friend.progress + ", tgl = \'" + NewEndda + "\' Where id = " + _friend.id; int rowsAffected = db.Execute(sqlQuery); } //return RedirectToAction("Index"); return(new EmptyResult()); }
public ActionResult Create(ProgressOrb _friend) { string endda = _friend.tgl; string tglB = endda.Substring(0, 2); string blnB = endda.Substring(3, 2); string thnB = endda.Substring(6, 4); string NewEndda = thnB + "/" + blnB + "/" + tglB; using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["PPIC"].ConnectionString)) { string sqlQuery = "Insert Into tProgressOrb (iCustomerProductID, cInquiryCode, progress, tgl) Values(" + _friend.iCustomerProductID + ",\'" + _friend.cInquiryCode + "\'," + _friend.progress + ",\'" + NewEndda + "\')"; int rowsAffected = db.Execute(sqlQuery); } //return RedirectToAction("Index"); return(new EmptyResult()); }