public DataTable GetAccom(BALRateCard obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_cardMaster]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action);
da.SelectCommand.Parameters.AddWithValue("@AccomTypeId", obj._AccomTypeId);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public int DeleteHotelRateCard(BALRateCard obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.DeleteCommand = new SqlCommand("[dbo].[sp_cardMaster]", cn);
da.DeleteCommand.Parameters.AddWithValue("@Action", obj._Action);
da.DeleteCommand.Parameters.AddWithValue("@RateCardId", obj._RateCardId);
da.DeleteCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
int InsertStatus = da.DeleteCommand.ExecuteNonQuery();
cn.Close();
if (InsertStatus > 0)
{
return(InsertStatus);
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
}
}
public int UpdateFitGitMealRate(BALRateCard obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.UpdateCommand = new SqlCommand("[dbo].[sp_cardMaster]", cn);
da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action);
da.UpdateCommand.Parameters.AddWithValue("@WelcomeDrink", obj.WelcomeDrink);
da.UpdateCommand.Parameters.AddWithValue("@Breakfast", obj.Breakfast);
da.UpdateCommand.Parameters.AddWithValue("@Lunch", obj.Lunch);
da.UpdateCommand.Parameters.AddWithValue("@EveSnacks", obj.EveSnacks);
da.UpdateCommand.Parameters.AddWithValue("@Dinner", obj.Dinner);
da.UpdateCommand.Parameters.AddWithValue("@FitOrGit", obj._FitOrGit);
da.UpdateCommand.Parameters.AddWithValue("@RatecardId", obj._RateCardId);
da.UpdateCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
int Status = da.UpdateCommand.ExecuteNonQuery();
cn.Close();
if (Status > 0)
{
return(Status);
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
}
}
public int UpdateFitGitRoomRate(BALRateCard obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.UpdateCommand = new SqlCommand("[dbo].[sp_cardMaster]", cn);
da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action);
da.UpdateCommand.Parameters.AddWithValue("@RateCardId", obj._RateCardId);
da.UpdateCommand.Parameters.AddWithValue("@FitOrGit", obj._FitOrGit);
da.UpdateCommand.Parameters.AddWithValue("@RoomTypeId", obj._RoomTypeId);
da.UpdateCommand.Parameters.AddWithValue("@Amt", obj._Amt);
da.UpdateCommand.Parameters.AddWithValue("@agentid", obj.agentid);
da.UpdateCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
int Status = da.UpdateCommand.ExecuteNonQuery();
cn.Close();
if (Status > 0)
{
return(Status);
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
}
}
public int UpdateParentRateCard(BALRateCard obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.UpdateCommand = new SqlCommand("[dbo].[sp_cardMaster]", cn);
da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action);
da.UpdateCommand.Parameters.AddWithValue("@RateCardId", obj._RateCardId);
da.UpdateCommand.Parameters.AddWithValue("@RateCategoryId", obj._RateCategoryId);
da.UpdateCommand.Parameters.AddWithValue("@AccomTypeId", obj._AccomTypeId);
da.UpdateCommand.Parameters.AddWithValue("@AccomId", obj._AccomId);
da.UpdateCommand.Parameters.AddWithValue("@RoomCategoryId", obj._RoomCategoryId);
da.UpdateCommand.Parameters.AddWithValue("@ValFrom", obj._ValFrom);
da.UpdateCommand.Parameters.AddWithValue("@ValTo", obj._ValTo);
da.UpdateCommand.Parameters.AddWithValue("@Season", obj._Season);
da.UpdateCommand.Parameters.AddWithValue("@minNights", obj._minNights);
da.UpdateCommand.Parameters.AddWithValue("@OperatingDays", obj._OperatingDays);
da.UpdateCommand.Parameters.AddWithValue("@AlloExtraBed", obj._AlloExtraBed);
da.UpdateCommand.Parameters.AddWithValue("@WebEnabled", obj._WebEnabled);
da.UpdateCommand.Parameters.AddWithValue("@TaxInclusive", obj._TaxInclusive);
da.UpdateCommand.Parameters.AddWithValue("@CommissionEnabled", obj._CommissionEnabled);
da.UpdateCommand.Parameters.AddWithValue("@RateTypeId", obj._RateTypeId);
da.UpdateCommand.Parameters.AddWithValue("@Currency", obj._Currency);
da.UpdateCommand.Parameters.AddWithValue("@Remark", obj._Remark);
da.UpdateCommand.Parameters.AddWithValue("@GITPaxFrom", obj.GITPaxFrom);
da.UpdateCommand.Parameters.AddWithValue("@TaxPct", obj.TaxPct);
da.UpdateCommand.Parameters.AddWithValue("@Description", obj.Description);
da.UpdateCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
int Status = da.UpdateCommand.ExecuteNonQuery();
cn.Close();
if (Status > 0)
{
return(Status);
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
}
}
private int AddFitGitRoomRate(BALRateCard obj)
{
try
{
#region Insert RoomRate For Fit/Git
for (int LoopCounter = 0; LoopCounter < GridFITRooms.Rows.Count; LoopCounter++)
{
try
{
#region Insert Fit Room Rate
obj._FitOrGit = "FIT";
HiddenField hdfnRoomTypeIdFit = (HiddenField)GridFITRooms.Rows[LoopCounter].Cells[0].FindControl("hdnfRoomTypeId");
TextBox txtCorrespondingRateFIT = (TextBox)GridFITRooms.Rows[LoopCounter].Cells[1].FindControl("txtFitRate");
obj._RoomTypeId = Convert.ToInt32(hdfnRoomTypeIdFit.Value.ToString());
if (txtCorrespondingRateFIT.Text != string.Empty)
{
obj._Amt = Convert.ToDecimal(txtCorrespondingRateFIT.Text.ToString().Trim());
}
else
{
obj._Amt = 0;
}
getQueryResponse = 0;
if (btnSbmit.Text == "Submit")
{
obj._Action = "InsertFitGitRoomRate";
getQueryResponse = dlcard.AddFitGitRoomRate(obj);
}
else
{
obj._Action = "UpdDetails";
getQueryResponse = dlcard.UpdateFitGitRoomRate(obj);
}
#endregion
#region insert Git Room Rate
obj._FitOrGit = "GIT";
HiddenField hdfnRoomTypeIdGit = (HiddenField)GridGITRooms.Rows[LoopCounter].Cells[0].FindControl("hdnfRoomTypeId");
TextBox txtCorrespondingRateGit = (TextBox)GridGITRooms.Rows[LoopCounter].Cells[1].FindControl("txtGitRate");
obj._RoomTypeId = Convert.ToInt32(hdfnRoomTypeIdGit.Value.ToString());
if (txtCorrespondingRateFIT.Text != string.Empty)
{
obj._Amt = Convert.ToDecimal(txtCorrespondingRateGit.Text.ToString().Trim());
}
else
{
obj._Amt = 0;
}
getQueryResponse = 0;
if (btnSbmit.Text == "Submit")
{
obj._Action = "InsertFitGitRoomRate";
getQueryResponse = dlcard.AddFitGitRoomRate(obj);
}
else
{
obj._Action = "UpdDetails";
getQueryResponse = dlcard.UpdateFitGitRoomRate(obj);
}
#endregion
#region Add Fit / Git Quad-ExtraBed (This Part Of Code Will Exicute when Loop Run Last Time)
if (LoopCounter == GridFITRooms.Rows.Count - 1)
{
#region FitQuad
obj._FitOrGit = "FIT";
obj._Quad = Convert.ToDecimal(txtFITQuad.Text.ToString().Trim());
obj._ExtraBed = Convert.ToDecimal(txtFItExtraBed.Text.ToString().Trim());
if (btnSbmit.Text == "Submit")
{
obj._Action = "AddQuad";
getQueryResponse = dlcard.AddFitGitQuad(obj);
}
else
{
obj._Action = "updQuadExtra";
getQueryResponse = dlcard.updateFitGitQuad(obj);
}
#endregion
#region Git Quad
obj._FitOrGit = "GIT";
obj._Quad = Convert.ToDecimal(txtGitQuad.Text.ToString().Trim());
obj._ExtraBed = Convert.ToDecimal(txtGitExtraBed.Text.ToString().Trim());
if (btnSbmit.Text == "Submit")
{
obj._Action = "AddQuad";
getQueryResponse = dlcard.AddFitGitQuad(obj);
}
else
{
obj._Action = "updQuadExtra";
getQueryResponse = dlcard.updateFitGitQuad(obj);
}
#endregion
}
#endregion
}
catch (Exception sqe)
{
continue;
}
}
#endregion
#region Insert Service For Fit/Git
try
{
#region Insert Fit Service Rates
TextBox txtWlcmDrnk = (TextBox)gdvMealRatesFIT.Rows[0].FindControl("txtWelcomeDrinkFIT");
TextBox txtBrkfst = (TextBox)gdvMealRatesFIT.Rows[0].FindControl("txtBreakfastFIT");
TextBox txtlunch = (TextBox)gdvMealRatesFIT.Rows[0].FindControl("txtLunchFIT");
TextBox txtDinner = (TextBox)gdvMealRatesFIT.Rows[0].FindControl("txtDinnerFIT");
TextBox txtEvesnacks = (TextBox)gdvMealRatesFIT.Rows[0].FindControl("txtEveSnacksFIT");
obj.WelcomeDrink = Convert.ToDouble(txtWlcmDrnk.Text);
obj.Breakfast = Convert.ToDouble(txtBrkfst.Text);
obj.Lunch = Convert.ToDouble(txtlunch.Text);
obj.Dinner = Convert.ToDouble(txtDinner.Text);
obj.EveSnacks = Convert.ToDouble(txtEvesnacks.Text);
obj._FitOrGit = "FIT";
getQueryResponse = 0;
if (btnSbmit.Text == "Submit")
{
obj._Action = "InsertFitGitMealRate";
getQueryResponse = dlcard.AddFitGitMealRate(obj);
}
else
{
obj._Action = "updMeal";
getQueryResponse = dlcard.UpdateFitGitMealRate(obj);
}
#endregion
#region Insert Git Service Rate
TextBox txtWlcmDrnkGIT = (TextBox)gdvMealRatesGIT.Rows[0].FindControl("txtWelcomeDrinkGIT");
TextBox txtBrkfstGIT = (TextBox)gdvMealRatesGIT.Rows[0].FindControl("txtBreakfastGIT");
TextBox txtlunchGIT = (TextBox)gdvMealRatesGIT.Rows[0].FindControl("txtLunchGIT");
TextBox txtDinnerGIT = (TextBox)gdvMealRatesGIT.Rows[0].FindControl("txtDinnerGIT");
TextBox txtEvesnacksGIT = (TextBox)gdvMealRatesGIT.Rows[0].FindControl("txtEveSnacksGIT");
obj.WelcomeDrink = Convert.ToDouble(txtWlcmDrnkGIT.Text);
obj.Breakfast = Convert.ToDouble(txtBrkfstGIT.Text);
obj.Lunch = Convert.ToDouble(txtlunchGIT.Text);
obj.Dinner = Convert.ToDouble(txtDinnerGIT.Text);
obj.EveSnacks = Convert.ToDouble(txtEvesnacksGIT.Text);
obj._FitOrGit = "GIT";
getQueryResponse = 0;
if (btnSbmit.Text == "Submit")
{
obj._Action = "InsertFitGitMealRate";
getQueryResponse = dlcard.AddFitGitMealRate(obj);
}
else
{
obj._Action = "updMeal";
getQueryResponse = dlcard.UpdateFitGitMealRate(obj);
}
#endregion
}
catch (Exception sqe)
{
}
#endregion
return(1);
}
catch (Exception sqe)
{
return(0);
}
}
