async Task SaveVitalsAsync()
{
//if (IsBusy || !(await LoginAsync()))
// return;
try
{
if (IsBusy)
{
return;
}
IsBusy = true;
var vVitalDetails = new ExpenseMaster()
{
UsrEmail = "*****@*****.**",
DateTaken = DateTime.Today,
Price = Convert.ToDecimal(dblPrice),
Quantity = Convert.ToDecimal(dblBmi),
Total = Convert.ToDecimal(dblTotal)
};
await azureService.AddVitals(vVitalDetails);
await App.Current.MainPage.Navigation.PopAsync();
}
catch (Exception ex)
{
Debug.WriteLine("OH NO!" + ex);
await Application.Current.MainPage.DisplayAlert("Sync Error", "Unable to sync coffees, you may be offline", "OK");
}
finally
{
IsBusy = false;
}
}
public Int64 Update(ExpenseMaster objcategory)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Expense_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@eid";
param.Value = objcategory.eid;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Expensename", objcategory.Expensename);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
//ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
public void BindExpenes(Int64 CategoryId)
{
ExpenseMaster objcategory = (new Cls_ExpenseMaster_b().SelectById(CategoryId));
if (objcategory != null)
{
txtExpenseName.Text = objcategory.Expensename;
}
}
public async Task <bool> AddVitals(ExpenseMaster aExpenseMaster)
{
await Initialize();
await mExpenseMasterTable.InsertAsync(aExpenseMaster);
await SyncVitals();
//return coffee
return(true);
}
public bool UpdateExpense(ExpenseMaster expense)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseMasters.Attach(expense);
_context.Entry(expense).State = EntityState.Modified;
foreach (ExpenseSummary s in expense.ExpenseSummaries)
{
_context.ExpenseSummaries.Attach(s);
_context.Entry(s).State = EntityState.Modified;
}
_context.SaveChanges();
return(true);
}
}
public bool CreateExpense(ExpenseMaster expense)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseMasters.Add(expense);
_context.SaveChanges();
expense.ExpenseCode = "Ex" + (1100 + expense.ExpenseId).ToString();
_context.ExpenseMasters.Attach(expense);
_context.Entry(expense).State = EntityState.Modified;
_context.SaveChanges();
//_context.ExpenseSummaries.AddRange(expense.ExpenseSummaries);
//_context.SaveChanges();
return(true);
}
}
public ExpenseMaster SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
ExpenseMaster objcategory = new ExpenseMaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Expense_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@eid", id);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objcategory.eid = Convert.ToInt64(ds.Tables[0].Rows[0]["eid"]);
objcategory.Expensename = Convert.ToString(ds.Tables[0].Rows[0]["Expensename"]);
}
}
}
}
}
}
catch (Exception ex)
{
// ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objcategory);
}
public ExpenseMaster GetExpenseForRepoManager(int id, string userId = null)
{
using (var _context = new AdminPortalEntities())
{
ExpenseMaster expense = new ExpenseMaster();
if (userId != null)
{
expense = _context.ExpenseMasters.Where(x => x.ExpenseId == id && x.AspNetUser.AspNetUser1.Id == userId && x.IsDeleted == false).Include(x => x.AspNetUser).Include(x => x.AspNetUser.AspNetUser1).Include(x => x.LookupCodeMaster).FirstOrDefault();
}
else
{
expense = _context.ExpenseMasters.Where(x => x.ExpenseId == id && x.IsDeleted == false).Include(x => x.AspNetUser).Include(x => x.AspNetUser.AspNetUser1).Include(x => x.LookupCodeMaster).FirstOrDefault();
}
return(expense);
}
}
public ExpenseMaster GetJustMyExpense(int id, string userId = null)
{
using (var _context = new AdminPortalEntities())
{
ExpenseMaster expense = new ExpenseMaster();
if (userId != null)
{
expense = _context.ExpenseMasters.Where(x => x.ExpenseId == id && x.UserId == userId && x.IsDeleted == false).FirstOrDefault();
}
else
{
expense = _context.ExpenseMasters.Where(x => x.ExpenseId == id && x.IsDeleted == false).FirstOrDefault();
}
return(expense);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
ExpenseMaster objcategory = new ExpenseMaster();
objcategory.Expensename = txtExpenseName.Text.Trim();
if (Request.QueryString["id"] != null)
{
objcategory.eid = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_ExpenseMaster_b().Update(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/Manage_expenseMaster.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Expense Not Updated";
BindExpenes(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_ExpenseMaster_b().Insert(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/Manage_expenseMaster.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Expense Not Inserted";
}
}
}
