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
}
