Click here to Skip to main content
14,740,501 members

Comments by Pradeepkumar patil sonu (Top 29 by date)

Pradeepkumar patil sonu 3-Mar-15 6:19am View
   
Reason for my vote of 5 \n it is nice tip.
Pradeepkumar patil sonu 23-Feb-15 1:00am View
   
Reason for my vote of 5 \n NIce article
Pradeepkumar patil sonu 23-Feb-15 0:58am View
   
Reason for my vote of 5 \n nice article.
Pradeepkumar patil sonu 8-Apr-14 6:08am View
   
GO /****** Object: StoredProcedure [dbo].[Check_Availability] Script Date: 04/08/2014 11:26:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Check_Availability]
@ChkIn int,
@ChkOut int,
@Arrdate1 datetime,
@Arrdate2 datetime,
@ChkInDateTime datetime,
@ChkOutDateTime datetime
AS
BEGIN
SET NOCOUNT ON;
declare @rowcount int
declare @roomtypetemp int
declare @stringtemp varchar(100)
declare @chkintime datetime;
declare @chkouttime datetime;
declare @fromtime varchar(50);
declare @totime varchar(50);
declare @differenceslots int;
set @chkintime=@ChkInDateTime;
set @chkouttime=@ChkOutDateTime;


DECLARE @outTable as Table([Room Type] varchar(20),[Description] varchar(100),[Max No Of People] int,
[No_Of Rooms] int,free int,[Min_Price] varchar(50),PriceType int,[Max No of Childrens] int);

set @fromtime=(select CONVERT(VARCHAR(8),CONVERT(datetime,@ChkInDateTime),108) );
set @totime=(select CONVERT(VARCHAR(8),CONVERT(datetime,@ChkOutDateTime),108) );

declare @RoomType as nvarchar(20),@Description varchar(100), @Noofrooms int,@Noofpersons as int,@PriceType as int,@Minprice decimal(38,20),@freeslots int,@noofchidrens int;

if(@ChkIn=@ChkOut)
set @rowcount=(select count(SlotId) FROM LifeStyleWebAvailability where
(SlotId= @ChkIn) and DocumentType=1 and (AvailabilityDate between @Arrdate1 and @Arrdate2) ) ;
else if(@ChkIn>@ChkOut)
set @rowcount=(select count(SlotId) FROM LifeStyleWebAvailability where
((SlotId between @ChkIn+1 and 23)) and DocumentType=1 and (AvailabilityDate = @Arrdate1))
+
(select count(SlotId) FROM LifeStyleWebAvailability where
((SlotId between 0 and @ChkOut)) and DocumentType=1 and (AvailabilityDate = @Arrdate2));
else
set @rowcount=(select count(SlotId) FROM LifeStyleWebAvailability where
((SlotId between @ChkIn+1 and @ChkOut)) and DocumentType=1 and (AvailabilityDate between @Arrdate1 and @Arrdate2) ) ;

delete from @outTable;
INSERT INTO @outTable([Room Type],[Description],[Max No Of People] ,[No_Of Rooms],[Max No of Childrens])
select [Room Type],[Description],[Max No Of People],[No_Of Rooms],[Max No of Children] from LifeStyleWebRoomType

--if(@fromtime<'10:00:00')
--begin
--set @fromtime=(select SUBSTRING(@fromtime,2,8));
--end
--if(@totime<'10:00:00')
--begin
--set @totime=(select SUBSTRING(@totime,2,8));
--end

print @fromtime;
print @totime;

declare cursor1 cursor for
select [Room Type],[Description],[Max No Of People] ,[No_Of Rooms],[Max No of Childrens] from @outTable
OPEN cursor1
FETCH NEXT FROM cursor1 INTO @RoomType,@Description, @Noofpersons,@Noofrooms,@noofchidrens
WHILE @@FETCH_STATUS = 0
BEGIN
set @PriceType=-1;
set @freeslots=0;
if(EXISTS(Select COUNT(*) from LifeStyleWebRoomPrice where [Room Type]=@RoomType having Count(*)=1))
BEGIN
print 'if'
if( exists(select pricetype from LifeStyleWebRoomPrice where [pricetype]=0 and [Room Type]=@RoomType and
CONVERT(VARCHAR(8),[Valid From],108)<= @fromtime and CONVERT(VARCHAR(8),[Valid To],108)>= @totime and @fromtime<=@totime))
BEGIN
select @PriceType=pricetype,@Minprice=Cast([Min Price] As varchar(50)) from LifeStyleWebRoomPrice where [pricetype]=0 and [Room Type]=@RoomType and
CONVERT(VARCHAR(8),[Valid From],108)<= @fromtime and CONVERT(VARCHAR(8),[Valid To],108)>= @totime and @fromtime<=@totime
END
else if( exists(select pricetype from LifeStyleWebRoomPrice where [pricetype]=1 and [Room Type]=@RoomType and
CONVERT(VARCHAR(8),[Valid From],108)<= @fromtime and CONVERT(VARCHAR(8),[Valid To],108)>= @totime and @fromtime>=@totime))
select @PriceType=pricetype,@Minprice=Cast([Min Price] As varchar(50)) from LifeStyleWebRoomPrice where [pricetype]=1 and [Room Type]=@RoomType and
CONVERT(VARCHAR(8),[Valid From],108)<= @fromtime and CONVERT(VARCHAR(8),[Valid To],108)>= @totime and @fromtime>=@totime

END
ELSE
BEGIN
print 'else 2'
if(EXISTS(SELECT top 1 price2.[Valid From],pric
Pradeepkumar patil sonu 24-Jul-13 6:14am View
   
i tried by using Fileinfo but same error m getting
Pradeepkumar patil sonu 24-Jul-13 5:51am View
   
Sorry i didnt get u
Pradeepkumar patil sonu 24-Jul-13 5:49am View
   
Deleted
Hi i made some changes in my above code but still m getting same error
<pre lang="c#">
string name = Environment.UserName;
string domain=System.Security.Principal.WindowsIdentity.GetCurrent().Name;
NTAccount act = new NTAccount(domain);
FileInfo fileinfo = new FileInfo(logFile);
FileSecurity filesecu = fileinfo.GetAccessControl();
// DirectoryInfo dirinfo = new DirectoryInfo(logFile);
//DirectorySecurity sec = dirinfo.GetAccessControl();

// FileSecurity sec = File.GetAccessControl(logFile);
filesecu.AddAccessRule(new FileSystemAccessRule(act, FileSystemRights.Write | FileSystemRights.ListDirectory,AccessControlType.Allow));
File.SetAccessControl(logFile, filesecu);
//if (permissionset.IsSubsetOf(AppDomain.CurrentDomain.PermissionSet))
//{
FileStream fs = new FileStream(logFile, FileMode.Open, FileAccess.Write);
StreamWriter streamwr = new StreamWriter(fs);
</pre>
Pradeepkumar patil sonu 24-Jul-13 5:35am View
   
ya i have set permission with full control for that file..
Pradeepkumar patil sonu 24-Jul-13 5:31am View
   
Thanks a lot Bro...
Pradeepkumar patil sonu 1-Feb-13 23:14pm View
   
Priority column i using Text as a data type..
but its working fine in visual studio..
but in IIS6 its not working..
Pradeepkumar patil sonu 1-Feb-13 22:59pm View
   
i checked my query.. in visual studio its working fine whenever i upload to IIS6 its not working
Pradeepkumar patil sonu 2-Jan-13 23:50pm View
   
power point files inside iframe <iframe id="myframe" src="myppt.ppt"></iframe> this iframe loads in my web page alone with ppt.. now to move to next slide i need to press spacebar key and for previous slide backspace key.. i wants to change keys to up and down arrow keys how can i achieve this?
Pradeepkumar patil sonu 2-Jan-13 23:50pm View
   
power point files inside iframe <iframe id="myframe" src="myppt.ppt"></iframe>
this iframe loads in my web page alone with ppt.. now to move to next slide i need to press spacebar key and for previous slide backspace key..
i wants to change keys to up and down arrow keys how can i achieve this?
Pradeepkumar patil sonu 2-Jan-13 23:46pm View
   
is dr any java script to change the key code?
Pradeepkumar patil sonu 2-Jan-13 23:45pm View
   
ya..
Pradeepkumar patil sonu 2-Jan-13 23:44pm View
   
defult m getting spacebar and backspce keys to move next slide and previous slide now i want to change it to arrow keys
Pradeepkumar patil sonu 2-Jan-13 23:41pm View
   
power point files inside iframe
<iframe id="myframe" src="myppt.ppt"></iframe>
Pradeepkumar patil sonu 2-Jan-13 23:39pm View
   
no default it is there for sapcebar and backspace..but now i want it to change to up and down arrow marks keys.....
Pradeepkumar patil sonu 23-Dec-12 22:58pm View
   
Thank This is working for me...
Pradeepkumar patil sonu 22-Dec-12 4:07am View
   
tried same error getting
Pradeepkumar patil sonu 22-Dec-12 0:40am View
   
server path folder we can store multiple files right?
but now whats happening its storing only one file even if i tried to store multiple files.. i want rectify this problem..
Pradeepkumar patil sonu 22-Dec-12 0:36am View
   
while uploading its storing only one html file.. actually i want to store multiple html files(PPt to html converted);
Pradeepkumar patil sonu 22-Dec-12 0:22am View
   
If you remember, there is an option in the File Menu of Microsoft PowerPoint:
File->Save As Web Page i am saving my ppt files like this and uploading it to server path folder but only one file is storing in that folder..actually i wants to store multiple files..so how can i solve this problem
Pradeepkumar patil sonu 20-Dec-12 4:44am View
   
ya video file in on server
Pradeepkumar patil sonu 20-Dec-12 2:35am View
   
1)I AM CREATING PPT FILE OFFLINE(USING MS AS USUAL)SOME SLIDES IN THAT PPT HAVING HYPERLINKS TO SOME VIDEOS.
2) WHILE SAVING I AM SAVING IT AS WEB PAGE.
3)UPLOADING TO MY WEBSITE WITH LOCATION SERVER.MAP PATH()AND VIEWING ITS NAME IN DATALIST
4)IF I CLICK ON THAT PPT FILE NAME IT LL OPEN AND I CAN READ PPT FILE.
5) NOW PROBLEM IS THAT WHILE READING I AM CLICKING ON HYPERLINKS WHICH ARE IN SLIDES SO IT WILL NOT OPENING VIDEO FILES
SO I WANT TO PLAY THAT VIDEO
Pradeepkumar patil sonu 20-Dec-12 0:52am View
   
Mr.Christian Graus HElP ME PLEASE To SOLVE THIS PROBLEM
Pradeepkumar patil sonu 20-Dec-12 0:14am View
   
sorry
ususally we give hyperlink to ppt slide while we creating offline ppt slide
now what i did i am saving that ppt file as web page and uploading it to my web site and storing it to my server path..
once i open that ppt file and click on hypel link that video file which i have hyperlinked its not opening.. so what shall i do
Pradeepkumar patil sonu 19-Dec-12 7:08am View
   
Thanks for Replying sir
But Sujjest me To display ppt files what can i use instead of iframe
Pradeepkumar patil sonu 17-Dec-12 23:27pm View
   
i ve solved my problem by using iframe.. but i want to add src dynamically to iframe but its not working..
i tried
frame1.Attributes["src"] = "http://www.live.com" ;
pls sujjest me if any other way is dr