public DataTable GetExists(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_agentMaxRooms]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@AccomId", obj._AccomId); da.SelectCommand.Parameters.AddWithValue("@AgentId", obj._AgentId); da.SelectCommand.Parameters.AddWithValue("@date", obj._Date); da.SelectCommand.Parameters.AddWithValue("@ToDate", obj.toDate); 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 DeletebookableInfo(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.DeleteCommand = new SqlCommand("[dbo].[sp_agentMaxRooms]", cn); da.DeleteCommand.Parameters.AddWithValue("@Action", obj._Action); da.DeleteCommand.Parameters.AddWithValue("@Id", obj._id); da.DeleteCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.DeleteCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public DataTable GetBookableRoomDetails(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_agentMaxRooms]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@AgentId", obj._AgentId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null && dtReturnData.Rows.Count > 0) { foreach (DataRow row in dtReturnData.Rows) { row["AgentName"] = DataSecurityManager.Decrypt(row["AgentName"].ToString()); } return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public int UpdateRoomImages(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("sp_RoomCategoryImages", cn); da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action); da.UpdateCommand.Parameters.AddWithValue("@Id", obj._id); da.UpdateCommand.Parameters.AddWithValue("@AccomId", obj._AccomId); da.UpdateCommand.Parameters.AddWithValue("@RoomCategoryId", obj.RoomCategoryId); da.UpdateCommand.Parameters.AddWithValue("@ImagePath", obj.ImagePath); 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 DataTable getImageById(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("sp_RoomCategoryImages", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@Id", obj._id); 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 UpdateRooms(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("[dbo].[sp_agentMaxRooms]", cn); da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action); da.UpdateCommand.Parameters.AddWithValue("@AccomId", obj._AccomId); da.UpdateCommand.Parameters.AddWithValue("@AgentId", obj._AgentId); da.UpdateCommand.Parameters.AddWithValue("@maxRooms", obj._maxRooms); da.UpdateCommand.Parameters.AddWithValue("@date", obj._Date); da.UpdateCommand.Parameters.AddWithValue("@ToDate", obj.toDate); 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); } }