public Boolean UpdateDataVMS(VMSDataModel model) { SqlConnection con = new SqlConnection(conString); try { SqlCommand com = new SqlCommand("SP_UpdateVMSData", con); com.CommandTimeout = 0; com.CommandType = CommandType.StoredProcedure; com.Parameters.Add(new SqlParameter("@NIK", model.NIK)); com.Parameters.Add(new SqlParameter("@Photo", model.Photo)); com.Parameters.Add(new SqlParameter("@CardNo", model.CardNo)); com.Parameters.Add(new SqlParameter("@Name", model.Name)); com.Parameters.Add(new SqlParameter("@UnitBusiness", model.UnitBusiness)); con.Open(); com.ExecuteNonQuery(); } catch (Exception err) { con.Close(); return(false); } finally { con.Close(); } return(true); }
public Boolean VMSAPIUpdateDataUser() { bool result = false; var client = new RestClient("http://117.102.82.138"); var request = new RestRequest("erp/api_vms_update_data.php", Method.GET); request.AddParameter("hash", dataEncryption.Encrypt(DateTime.Now.ToString("yyyy-MM-dd"))); // adds to POST or URL querystring based on Method request.AddParameter("user", dataEncryption.Encrypt("api.koperasi.local")); request.AddParameter("date", DateTime.Now.ToString("yyyy-MM-dd")); var response = client.Execute(request); updateUserResult = response.Content; var data = (JObject)JsonConvert.DeserializeObject(response.Content); VMSDataModel model = new VMSDataModel(); if (data["data"] != null) { foreach (var item in data["data"]) { model.NIK = item[3].ToString(); model.Name = item[1].ToString(); model.UnitBusiness = item[2].ToString(); model.CardNo = item[0].ToString(); model.Photo = item[4].ToString(); result = UpdateDataVMS(model); if (!result) { return(result); } } } return(result); }