private void saveRateToRoomType(Rates rate, ref String result) { Rate_To_RoomType rateToRoomType = new Rate_To_RoomType(); rateToRoomType.Rate_ID = rate.Rate_ID; if (rateToRoomType.DeleteAllWRate_IDLogic()) { foreach (ListItem li in lstRoomTypes.Items) { if (li.Selected) { rateToRoomType.RoomType_ID = Int32.Parse(li.Value); int counter = 0; if (rateToRoomType.Insert()) { result = lblMsg.Text + "; " + ++counter + "Data Saved."; lblMsg.ForeColor = Color.Green; } else { lblMsg.Text = result; lblMsg.ForeColor = Color.Red; } } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (drpRates.SelectedValue.Equals("-1")) { lblMsg.Text = "Please select a Rate"; lblMsg.ForeColor = Color.Red; return; } Rate_To_RoomType rateToRoomType = new Rate_To_RoomType(); rateToRoomType.Rate_ID = Int32.Parse(drpRates.SelectedValue); if (rateToRoomType.DeleteAllWRate_IDLogic()) { foreach (ListItem li in lstRoomTypes.Items) { if (li.Selected) { rateToRoomType.RoomType_ID = Int32.Parse(li.Value); int counter = 0; if (rateToRoomType.Insert()) { lblMsg.Text = ++counter + "Data Saved."; lblMsg.ForeColor = Color.Green; } } } } }
private void BindRateByRoomType(SqlInt32 roomTypeId) { Rate_To_RoomType rateToRmType = new Rate_To_RoomType(); rateToRmType.RoomType_ID = roomTypeId; DataTable table = rateToRmType.SelectRatesByRoomTypeID(); drpRatesApplicable.DataSource = table; drpRatesApplicable.DataTextField = table.Columns["RateDescription_EN"].ToString(); drpRatesApplicable.DataValueField = table.Columns["Rate_ID"].ToString(); drpRatesApplicable.DataBind(); if (drpRatesApplicable.Items.Count > 0) { var results = (from m in table.AsEnumerable() where m.Field <int>("Rate_ID") == Int32.Parse(drpRatesApplicable.Items[0].Value) //&& m.Field<int>("Rate_ID") == rateId select m); lblRate.Text = results.ElementAt(0)["Rate"].ToString(); } //CalculateTotalAmount(); }
private void BindRoomTypesByRate(int rateId) { Rate_To_RoomType rateToRoomType = new Rate_To_RoomType(); rateToRoomType.Rate_ID = rateId; DataTable table = rateToRoomType.SelectRoomTypesByRateID(); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { foreach (ListItem li in lstRoomTypes.Items) { if (li.Value.Equals(row["RoomType_ID"].ToString())) { li.Selected = true; } } } } }