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;
}
}
}
}
}
