private void AddMoney(int Money) { newResp user = JsonUtility.FromJson <newResp>(jsonString); WWWForm form = new WWWForm(); form.AddField("userID", user.userID); form.AddField("amountToAdd", Money); WWW newWWW = new WWW("http://localhost/wash-admin/public/addMoney", form); string response = ""; if (newWWW.isDone) { Debug.Log(newWWW.text); if (string.IsNullOrEmpty(newWWW.error)) { response = newWWW.text; response = response.Replace("\"{", "{"); response = response.Replace(@"}""", "}"); response = response.Replace(@"\", ""); balance newBal = JsonUtility.FromJson <balance>(response); Debug.Log(newBal.washPoints.ToString()); PlayerPrefs.SetInt("Currency", newBal.washPoints); } } }
public void acceptreq(object sender, EventArgs e) { databaseDataContext db3 = new databaseDataContext(); budget_setting bs = new budget_setting(); //DateTime dt = new DateTime(); databaseDataContext db = new databaseDataContext(); balance b = new balance(); request r = new request(); admin adm = new admin(gid); databaseDataContext db1 = new databaseDataContext(); try { string s = comboBox1.GetItemText(this.comboBox1.SelectedItem); int es = Int32.Parse(s); b = db.balances.SingleOrDefault(x => x.membername == textBox1.Text); b.amount = b.amount + es; db.SubmitChanges(); r = db1.requests.SingleOrDefault(x => x.amount == es); db1.requests.DeleteOnSubmit(r); db1.SubmitChanges(); //following 3 lines don't work //bs = db3.budget_settings.SingleOrDefault(x => x.guardian_id == gid && x.year==dateTimePicker1.Value.Month && x.month==adm.convertdate(dateTimePicker1.Value.Month.ToString())); //bs.max = bs.max + es; //db3.SubmitChanges(); MessageBox.Show("request accepted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void addmemexp(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); cost_table c = new cost_table(); databaseDataContext db1 = new databaseDataContext(); // member m = new member(); balance b = new balance(); try { c.cost_title = textBox3.Text; c.cost_amount = Int32.Parse(textBox4.Text); // m = db1.members.SingleOrDefault(x=>x.username==mid); // string s = f.gid.ToString(); c.username = mid; c.date = dateTimePicker1.Value; db.cost_tables.InsertOnSubmit(c); db.SubmitChanges(); b = db1.balances.SingleOrDefault(x => x.membername == mid); b.amount = b.amount - Int32.Parse(textBox4.Text); db1.SubmitChanges(); MessageBox.Show("expense added"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private decimal balance(string sessionid) { mobiEz.balanceRequestType balanceRequestTypeObj = new balanceRequestType(); mobiEz.balanceResponse balanceResponseObj = new balanceResponse(); mobiEz.balance balanceObj = new balance(); balanceRequestTypeObj.sessionid = sessionid; balanceRequestTypeObj.type = 1; balanceObj.balanceRequest = balanceRequestTypeObj; try { //invoke balance function balanceResponseObj = UMSObj.balance(balanceObj); if (balanceResponseObj.balanceReturn.result == 0) { return(balanceResponseObj.balanceReturn.avail_1); } else { return(0); } } catch (Exception ex) { throw (ex); } }
private void showbalance(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); member m = new member(); balance b = new balance(); try { b = db.balances.SingleOrDefault(x => x.membername == mid); label5.Text = b.amount.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// GET: balances/Create public ActionResult Create() { var personas = from per in db.personas select per; var solicitantes = from sol in db.solicitantes select sol; balance bal = new balance(); bal.num_documento = personas.ToList().Count(); bal.listaper = personas.ToList(); bal.listasol = solicitantes.ToList(); ViewBag.id_solicitante = new SelectList(db.solicitantes, "uid", "num_solicitante"); ViewBag.capturista = new SelectList(db.usuarios, "uid", "departamento"); return View(bal); }
public IActionResult Balances() { balance data = null; using (var db = new AreaFundingDatabase()) { var sql = @" SELECT * FROM balances LIMIT 1;" ; data = db.Single <balance>(sql); } return(View(data)); }
protected void insert_member() { // databaseDataContext db = new databaseDataContext(); //balance b = new balance(); try { using (databaseDataContext dbcon = new databaseDataContext()) { member reg_member = new member { gurdian_id = int.Parse(comboBox1.SelectedItem.ToString()), username = use_name.Text, password = pass.Text, dob = dob_m.Value, name = name_m.Text, gender = gender_m.SelectedItem.ToString(), relation = relation_m.SelectedItem.ToString() }; dbcon.members.InsertOnSubmit(reg_member); dbcon.SubmitChanges(); } using (databaseDataContext db = new databaseDataContext()) { balance b = new balance { membername = use_name.Text, amount = 0 }; db.balances.InsertOnSubmit(b); db.SubmitChanges(); } MessageBox.Show("registration complete"); Form1 fm1 = new Form1(); this.Hide(); fm1.Show(); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void button1_Click(object sender, EventArgs e) { databaseDataContext bd = new databaseDataContext(); balance b = new balance(); databaseDataContext bd1 = new databaseDataContext(); budget_setting bs = new budget_setting(); databaseDataContext bd2 = new databaseDataContext(); try { // b = bd.balances.SingleOrDefault(x => x.membername == comboBox1.GetItemText(this.comboBox1.SelectedItem)); int m = int.Parse(bd2.balances.Select(x => x.year).ToString()); string fs = bd2.balances.Select(x => x.month).ToString(); b.membername = comboBox1.SelectedItem.ToString(); b.amount = int.Parse(textBox1.Text); b.month = comboBox3.SelectedItem.ToString(); b.year = int.Parse(comboBox2.SelectedItem.ToString()); if (b.month == fs && b.year == m) { bd.balances.InsertOnSubmit(b); bd.SubmitChanges(); MessageBox.Show("balance added"); } else { MessageBox.Show("duplicate value!!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } try { bs = bd1.budget_settings.SingleOrDefault(x => x.month == b.month && x.year == b.year); bs.max = bs.max + b.amount; bd1.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataTable Addbalance(balance ocr) { DataTable dt = new DataTable(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); StringBuilder str = new StringBuilder(); try { traceWriter.Trace(Request, "0", System.Diagnostics.TraceLevel.Info, "{0}", "Addbalance...."); str.Append("Mobileno:" + ocr.mobileno + ","); str.Append("Amount:" + ocr.Amount + ","); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString()); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSInsUpdAddbalance"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = ocr.flag; cmd.Parameters.Add(f); SqlParameter q1 = new SqlParameter("@Mobileno", SqlDbType.VarChar, 20); q1.Value = ocr.mobileno; cmd.Parameters.Add(q1); SqlParameter e = new SqlParameter("@Amount", SqlDbType.Decimal); e.Value = ocr.Amount; cmd.Parameters.Add(e); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Addbalance successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Addbalance...." + ex.Message.ToString()); //throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); dt.Columns.Add("Code"); dt.Columns.Add("description"); DataRow dr = dt.NewRow(); dr[0] = "ERR001"; dr[1] = ex.Message; dt.Rows.Add(dr); } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(dt); //Verify Passwordotp }