protected void btnSelect_Click(object sender, EventArgs e) { try { ListView.Visible = true; cm = new CaloriesModel(); cm.Date = MyDate.SelectedDate; GetData(MyDate.SelectedDate); SumCalorie.Text = cr.SelectSumCalorie(cm).ToString(); // MyDate.SelectedDates.Clear(); GetDataActivity(MyDate.SelectedDate); // MyDate.SelectedDates.Clear(); mm = new MobilitiesModel(); mm.Date = MyDate.SelectedDate; SumMobilityTxt.Text = mr.SelectSumMobility(mm).ToString(); //dailyCalorie.Text = (Convert.ToInt32(SumCalorie.Text) - Convert.ToInt32(SumMobilityTxt.Text)).ToString(); } catch (Exception ex) { le.SaveLogError(ex); } }
protected void Calorie_RowCommand(object sender, GridViewCommandEventArgs e) { cm = new CaloriesModel(); int index = Convert.ToInt32(e.CommandArgument); cm.Id = Convert.ToInt32(CalorieList.Rows[index].Cells[3].Text); if (e.CommandName == "DeleteRow") { bool res = cr.Delete(cm); if (res) { string message = "Deleting info was successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } else { string message = "Deleting info was not successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } if (MyDate.SelectedDate != null) { GetData(MyDate.SelectedDate); } else { GetData(Calender.SelectedDate); } } if (e.CommandName == "EditRow") { MyDate.SelectedDates.Clear(); addNew.Visible = true; ShowList.Visible = false; btnUpdate.Visible = true; btnSave.Visible = false; addNew.Visible = true; Quantity.Text = CalorieList.Rows[index].Cells[7].Text.ToString(); Calender.SelectedDate = Convert.ToDateTime(CalorieList.Rows[index].Cells[9].Text); var foodGroupId = CalorieList.Rows[index].Cells[11].Text.ToString(); FoodGroupDropDown.SelectedValue = FoodGroupDropDown.Items.FindByValue(foodGroupId).Value; LoadFoodDropDown(Convert.ToInt32(foodGroupId)); var foodId = CalorieList.Rows[index].Cells[10].Text.ToString(); FoodDropDown.SelectedValue = FoodDropDown.Items.FindByValue(foodId).Value; ListView.Visible = false; CalorieIdTxt.Text = CalorieList.Rows[index].Cells[3].Text.ToString(); UsageCalorie.Text = CalorieList.Rows[index].Cells[8].Text.ToString(); FoodCalorieText.Text = CalorieList.Rows[index].Cells[12].Text.ToString(); } }
public string SelectSumCalorie(CaloriesModel cm) { base.DataAccess(); base.Connect(); string Query = "select sum(Calorie) from Calories where Date='" + cm.Date + "' and UserId='" + cm.UserId + "'"; string b = base.ExecuteSelect(Query); base.DisConnect(); return(b); }
public DataTable SelectByDate(CaloriesModel cm) { base.DataAccess(); base.Connect(); string Query = "select Calories.Id,FoodsGroup.Name as 'Food Group',Foods.Name as 'Food Name',Foods.Calorie as 'Food Calorie',Calories.Quantity,Calories.Calorie as 'Usage Calorie',Calories.Date,Calories.FoodId,Foods.FoodGroupId,Foods.Calorie from Calories,Foods,FoodsGroup where Calories.FoodId = Foods.Id and Foods.FoodGroupId = FoodsGroup.Id and Calories.Date = '" + cm.Date + "' and Calories.UserId = '" + cm.UserId + "' order by Calories.Id desc"; DataTable dt = base.Select(Query); base.DisConnect(); return(dt); }
public bool Update(CaloriesModel cm)//method for update { base.DataAccess(); base.Connect(); string Query = "update Calories set FoodId=N'{0}',Quantity=N'{1}',Calorie=N'{2}',Date=N'{3}' where Id={4}"; Query = string.Format(Query, cm.FoodId, cm.Quantity, cm.Calorie, cm.Date, cm.Id); bool res = base.DoCommand(Query); base.DisConnect(); return(res); }
public bool Delete(CaloriesModel cm)//method for delet { base.DataAccess(); base.Connect(); string Query = "delete from Calories where Id={0}"; Query = string.Format(Query, cm.Id); bool res = base.DoCommand(Query); base.DisConnect(); return(res); }
public bool Insert(CaloriesModel cm) //method for adding item { base.DataAccess(); base.Connect(); string Query = "insert into Calories (UserId,FoodId,Quantity,Calorie,Date) values (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}')"; Query = string.Format(Query, cm.UserId, cm.FoodId, cm.Quantity, cm.Calorie, cm.Date); bool res = base.DoCommand(Query); base.DisConnect(); return(res); }
protected void btnSave_Click(object sender, EventArgs e) { try { if ((Calender.SelectedDate == Convert.ToDateTime("1 / 1 / 0001 12:00:00 AM")) || (FoodGroupDropDown.SelectedItem.Value == "0") || (FoodDropDown.SelectedItem.Value == "0")) { string message = "Please fill all items!"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); //Scr } else { cm = new CaloriesModel(); cm.FoodId = Convert.ToInt32(FoodDropDown.SelectedItem.Value); cm.UserId = Convert.ToInt32(UserIdTxt.Text); cm.Quantity = Quantity.Text.ToString(); cm.Date = Calender.SelectedDate; cm.Calorie = (Convert.ToInt32(Quantity.Text.ToString())) * (Convert.ToInt32(FoodCalorieText.Text.ToString())); bool res = cr.Insert(cm); if (res) { string message = "Saving info was successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true); } else { string message = "Saving info was not successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } addNew.Visible = false; ShowList.Visible = true; ListView.Visible = true; MyDate.SelectedDate = cm.Date; GetData(Calender.SelectedDate); GetDataActivity(Calender.SelectedDate); SumCalorie.Text = cr.SelectSumCalorie(cm).ToString(); //dailyCalorie.Text = (Convert.ToInt32(SumCalorie.Text) - Convert.ToInt32(SumMobilityTxt.Text)).ToString(); } } catch (Exception ex) { le.SaveLogError(ex); } }
private void GetData(DateTime dt) { try { cm = new CaloriesModel(); cm.Date = dt; CalorieList.DataSource = cr.SelectByDate(cm); CalorieList.DataBind(); } catch (Exception ex) { le.SaveLogError(ex); } }
private void GetData(DateTime dt) { try { cm = new CaloriesModel(); cm.Date = dt; cm.UserId = Convert.ToInt32(UserIdTxt.Text); CalorieList.DataSource = cr.SelectByDate(cm); CalorieList.DataBind(); } catch (Exception ex) { le.SaveLogError(ex); } }
protected void btnSelect_Click(object sender, EventArgs e) { try { cm = new CaloriesModel(); cm.Date = MyDate.SelectedDate; ListView.Visible = true; GetData(MyDate.SelectedDate); SumCalorie.Text = cr.SelectSumCalorie(cm).ToString(); // MyDate.SelectedDates.Clear(); } catch (Exception ex) { le.SaveLogError(ex); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { cm = new CaloriesModel(); cm.FoodId = Convert.ToInt32(FoodDropDown.SelectedItem.Value); cm.Quantity = Quantity.Text.ToString(); cm.Date = Calender.SelectedDate; cm.Calorie = (Convert.ToInt32(Quantity.Text.ToString())) * (Convert.ToInt32(FoodCalorieText.Text.ToString())); cm.Id = Convert.ToInt32(CalorieIdTxt.Text.ToString()); bool res = cr.Update(cm); if (res) { string message = "Saving info was successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true); } else { string message = "Saving info was not successfully"; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } addNew.Visible = false; ShowList.Visible = true; ListView.Visible = true; MyDate.SelectedDate = cm.Date; GetData(cm.Date); SumCalorie.Text = cr.SelectSumCalorie(cm).ToString(); } catch (Exception ex) { le.SaveLogError(ex); } }