/// <summary> /// Method to Save the Entry /// </summary> /// <param name="obj"></param> /// <returns></returns> public int SaveData(SaraiRoomAvailability obj) { int Id = 0; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ID", obj.Id)); parameters.Add(new SqlParameter("@SARAI_MASTER_ID", obj.FromDate)); parameters.Add(new SqlParameter("@ROOM_CATEGORY_MASTER_ID", obj.ToDate)); parameters.Add(new SqlParameter("@FROM_DATE", obj.Remarks)); parameters.Add(new SqlParameter("@TO_DATE", obj.IsActive)); parameters.Add(new SqlParameter("@ONLINE_ROOMS_COUNT", obj.RowVersion)); parameters.Add(new SqlParameter("@OFFLINE_ROOMS_COUNT", obj.CheckSumValue)); parameters.Add(new SqlParameter("@IS_ACTIVE", obj.IsActive)); parameters.Add(new SqlParameter("@ROW_VERSION", obj.RowVersion)); parameters.Add(new SqlParameter("@SUPERADMIN_USERNAME", Localizer.CurrentUser.SuperAdminName)); parameters.Add(new SqlParameter("@USER_MASTER_ID", Localizer.CurrentUser.Id)); DataTable dt = Db.GetDataTable("SAVE_UPDATE_SARAI_ROOM_AVAILABILITY", parameters); if (dt.Rows.Count > 0) { Id = Convert.ToInt32(dt.Rows[0][0]); } return(Id); }
/// <summary> /// Method to Get the Particular Record from Database /// </summary> /// <param name="Id"></param> /// <returns></returns> public SaraiRoomAvailability GetSingleRecordDetail(int Id) { SaraiRoomAvailability obj = new SaraiRoomAvailability(); string strQuery = ""; strQuery = strQuery + System.Environment.NewLine + "SELECT M.ID AS Id,"; strQuery = strQuery + System.Environment.NewLine + " M.SARAI_MASTER_ID AS SaraiMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.ROOM_CATEGORY_MASTER_ID AS RoomCategoryMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.FROM_DATE AS FromDate,"; strQuery = strQuery + System.Environment.NewLine + " M.TO_DATE AS ToDate,"; strQuery = strQuery + System.Environment.NewLine + " M.ONLINE_ROOMS_COUNT AS OnlineRoomsCount,"; strQuery = strQuery + System.Environment.NewLine + " M.OFFLINE_ROOMS_COUNT AS OfflineRoomsCount,"; strQuery = strQuery + System.Environment.NewLine + " M.IS_ACTIVE AS IsActive,"; strQuery = strQuery + System.Environment.NewLine + " M.ROW_VERSION AS [RowVersion],"; strQuery = strQuery + System.Environment.NewLine + " M.CREATED_BY AS CreatedByUserId,"; strQuery = strQuery + System.Environment.NewLine + " ISNULL(C_UM.NAME, '') AS CreatedByUserName,"; strQuery = strQuery + System.Environment.NewLine + " M.CREATE_DATE AS CreateDate,"; strQuery = strQuery + System.Environment.NewLine + " ISNULL(M.MODIFIED_BY, 0) AS ModifiedByUserId,"; strQuery = strQuery + System.Environment.NewLine + " M.MODIFY_DATE AS ModifyDate,"; strQuery = strQuery + System.Environment.NewLine + " ISNULL(M_UM.NAME, '') AS ModifiedByUserName"; strQuery = strQuery + System.Environment.NewLine + "FROM SARAI_ROOM_AVAILABILITY M"; strQuery = strQuery + System.Environment.NewLine + "INNER JOIN USER_MASTER C_UM"; strQuery = strQuery + System.Environment.NewLine + "ON M.CREATED_BY = C_UM.ID"; strQuery = strQuery + System.Environment.NewLine + "LEFT JOIN USER_MASTER M_UM"; strQuery = strQuery + System.Environment.NewLine + "ON M.MODIFIED_BY = M_UM.ID"; strQuery = strQuery + System.Environment.NewLine + "WHERE M.ID = "+ Id.ToString(); obj = Db.DapperGet <SaraiRoomAvailability>(strQuery); return(obj); }