mfalac.feed

perinaz.com

mfalac@mfalac.com (mfalac) — Tue, 05 Jan 2010 03:58:32 GMT

finaly got perinaz.com for my sister :)
have to do lots of things; for now i am going to use css templates for covering all this pages, including my pages also. when im done with applications i can update orginal css or keep them, they are free and looks good anyway.
this year going to be best, i feel like i got energy for everyting (and no time for anything) lol

search and 2010

mfalac@mfalac.com (mfalac) — Fri, 01 Jan 2010 05:38:41 GMT

finaly added search! bouu it is not my search engine it is google :( today is the first day of the 2010 and feel diffrent, unusual relax, feel like something going to happen (in a good way), yesterday i talk to neptun again, whtever i do im not able to control my anger to her. I said lots of mean words again for no reason, im not just hurting her also i am hurting my self... This year im going to learn to control my self and my anger ... i hope this year will be better than 2009.. damn i hated 2009

Type Conversion Functions

mfalac@mfalac.com (mfalac) — Mon, 28 Dec 2009 02:46:58 GMT

CBool(expression)
CByte(expression)
CChar(expression)
CDate(expression)
CDbl(expression)
CDec(expression)
CInt(expression)
CLng(expression)
CObj(expression)
CSByte(expression)
CShort(expression)
CSng(expression)
CStr(expression)
CUInt(expression)
CULng(expression)
CUShort(expression)

http://msdn.microsoft.com/en-us/library/s2dy91zy.aspx

Tab Task Bar

mfalac@mfalac.com (mfalac) — Mon, 28 Dec 2009 02:28:43 GMT

First, I thought i fixed task bar :( anyway LinQ is not working in live server so i changed source to sql ere is the long boring code stil need to update >>>

<cc1:TabContainer ID="TabContainerTasks" runat="server" ActiveTabIndex="0">

<cc1:TabPanel runat="server" HeaderText="Today" ID="TabPanelToday">

Today

</HeaderTemplate>

<asp:UpdatePanel ID="UpdatePanelTaskListView" runat="server" >

<asp:SqlDataSource ID="SqlDataSourceToday" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:me %>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [Id], [Char], [Position], [TaskName], [TaskDate], [isComplete] FROM [ReorderTaskList] WHERE ([TaskDate] = @TaskDate) ORDER BY [Position]"

UpdateCommand="UPDATE ReorderTaskList SET Position = @Position, TaskName = @TaskName, isComplete = @isComplete, TaskDate = @TaskDate WHERE (Id = @original_Id)">

<asp:ControlParameter ControlID="LabelDateTime" DbType="Date" Name="TaskDate" PropertyName="Text" />

</SelectParameters>

<asp:Parameter Name="position" Type="Int32" />

<asp:Parameter Name="TaskName" />

<asp:Parameter Name="isComplete" />

<asp:Parameter Name="TaskDate" />

<asp:Parameter Name="original_id" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<cc1:ReorderList ID="reorder" runat="server" AllowReorder="True" DataSourceID="SqlDataSourceToday" DataKeyField="Id" SortOrderField="Position" PostBackOnReorder="True" CallbackCssStyle="DragHandleClass">

</div></DragHandleTemplate>

<cc1:HoverMenuExtender ID="HoverMenuExtenderToday" runat="server" TargetControlID="TaskNameLabel" PopupControlID="PanelToday" OffsetX="-90" OffsetY="20" >

</cc1:HoverMenuExtender>

--panel here --------------%><asp:Panel ID="PanelToday" runat="server" CssClass="popupControl1" >

<asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional"><ContentTemplate>

<asp:Label ID="LabelId" Visible="false" runat="server" Text='<%# Eval("Id") %>' />

<asp:DetailsView ID="DetailsViewpop" runat="server" AutoGenerateRows="False" DataKeyNames="Id" DataSourceID="SqlDataSourcePopUp" DefaultMode="Edit" onitemupdated="DetailsViewpop_ItemUpdated" >

<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" Visible="False" />

<asp:BoundField DataField="TaskName" HeaderText="TaskName" SortExpression="TaskName" />

<asp:CheckBoxField DataField="isComplete" HeaderText="isComplete" SortExpression="isComplete" />

<asp:TemplateField HeaderText="TaskDate" SortExpression="TaskDate">

<asp:Calendar ID="Calendar1" Width="100%" Height="100%" SelectedDate='<%# Bind("TaskDate") %>' runat="server" ShowGridLines="True" ShowDayHeader="False" TitleFormat="Month"></asp:Calendar>

</EditItemTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TaskDate") %>'></asp:TextBox>

</InsertItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("TaskDate") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" />

</Fields>

</asp:DetailsView> </ContentTemplate>

</asp:UpdatePanel> <asp:SqlDataSource ID="SqlDataSourcePopUp" runat="server" ConnectionString="<%$ ConnectionStrings:me %>" SelectCommand="SELECT Id, TaskName, isComplete, TaskDate FROM ReorderTaskList WHERE (Id = @id)" UpdateCommand="UPDATE ReorderTaskList SET TaskName = @TaskName, isComplete = @isComplete, TaskDate = @TaskDate WHERE (Id = @Id)">

<asp:ControlParameter ControlID="LabelId" Name="id" PropertyName="Text" />

</SelectParameters>

<asp:Parameter Name="TaskName" />

<asp:Parameter Name="isComplete" />

<asp:Parameter Name="TaskDate" />

<asp:Parameter Name="Id" />

</UpdateParameters>

</asp:SqlDataSource> <br />

</asp:Panel>

<asp:Label ID="TaskNameLabel" runat="server" Text='<%# Eval("TaskName") %>' />

</ItemTemplate>

</cc1:ReorderList>

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

cc1:TabPanel>cc1:TabPanel ID="TabPanelTomorrow" runat="server" HeaderText="Tomorrow">

<asp:UpdatePanel ID="UpdatePanelEditAndInsert" runat="server" UpdateMode="Conditional">

TODP: tomorrow here

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

cc1:TabPanel>

<cc1:TabPanel ID="TabPanelPast" runat="server" HeaderText="Past">

<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">

TODO: past here

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

cc1:TabPanel>

<cc1:TabPanel ID="TabPanel1" runat="server" HeaderText="Add">

<ContentTemplate>TODO: Add a delete Task! should delete old month or second quater>????</ContentTemplate>

cc1:TabPanel>

</cc1:TabContainer>

Neptun

mfalac@mfalac.com (mfalac) — Sun, 20 Dec 2009 06:42:30 GMT

yesterday was the last day ..she called like she care what is happing to me.. she is really pitying me..fuck it.... i cant take this anymore I am loosing my mind?terrible 2 weeks again! same story; she calls than I start to dreaming about her again .. couldn't think and do anything 2 weeks., and no aikido more than 2 weeks. this is just stupid. doesn't matter, what i do; begging or bleeding. noting did change and not going to change. and her ignorance and her acting's make me sick? i wish i can go back in time and erase her from my life. What kind of idiot i am ????

Calendar Control And Events

mfalac@mfalac.com (mfalac) — Sun, 20 Dec 2009 05:52:02 GMT

' Clear the current text.
Message.Text = ""

       ' Iterate through the SelectedDates collection and display the
       ' dates selected in the Calendar control.
       Dim day As DateTime

For Each day In Calendar1.SelectedDates

Message.Text &= day.Date.ToShortDateString() & "<br>"

For Each ArticleRow As DataSetCalendarEvents.BlogArticlesRow In ArticleDayNumber
    If e.Day.Date.Date = ArticleRow.ArticleDate.Date Then
        Dim T As String = ArticleRow.ArticleTitle.ToString()
        Dim Id As String = ArticleRow.ArticleId.ToString()

e.Cell.Controls.Add(New LiteralControl("<br/>-<a href='../Blog/BlogView.aspx?ArticleId=" + Id + "'>" + T + "</a>"))

Sub MonthChange(sender As Object, e As MonthChangedEventArgs)

         If e.NewDate.Month > e.PreviousDate.Month Then

            Message.Text = "You moved forward one month."

         Else

            Message.Text = "You moved backwards one month."

         End If

      End Sub

End If
Next

Dream Antimatter

mfalac@mfalac.com (mfalac) — Thu, 17 Dec 2009 12:19:19 GMT

Immersed in light, broken in flight,
Here comes that scene again,
Not another sleepless night.
Scripted yet stuck on every line,
Upon my face a look of pure surprise,
I thought I'd be fighting fire.

How it's changed from my dream,
Did I stray from the path laid out for me?
How it's changed,
Did I fail in some way?

Easy to plot a course divine,
A simple graph cant cover ever line,
and I dont see what I dont know.
Some truths are harder to perceive,
The color has been drained now from my eyes,
Staring into endless time...

PopUpExtender and Comma

mfalac@mfalac.com (mfalac) — Tue, 15 Dec 2009 02:34:59 GMT

                Tags:
        <asp:TextBox ID="MyTextBox" runat="server" Width="538px"></asp:TextBox>
        <br />
        <br />
        <asp:Panel ID="Panel1" runat="server" CssClass="popupControl">
          <asp:UpdatePanel ID="UpdatePanel1" runat="server" >
            <ContentTemplate>
                 <asp:RadioButtonList ID="RadioButtonList1" runat="server" OnSelectedIndexChanged="RadioButtonList1_SelectedIndexChanged" AutoPostBack="true" Width="146px">
                    <asp:ListItem Text="ozkan"></asp:ListItem>
                    <asp:ListItem Text="deniz"></asp:ListItem>
                    <asp:ListItem Text="cherline"></asp:ListItem>
                    <asp:ListItem Text="fatih"></asp:ListItem>
                    <asp:ListItem Text="veronica"></asp:ListItem>
                </asp:RadioButtonList>
            </ContentTemplate>
          </asp:UpdatePanel>
        </asp:Panel>
     
    <br />
                <cc1:popupcontrolextender
                ID="PopupControlExtender1" runat="server"
    TargetControlID="MyTextBox" PopupControlID="Panel1"
    CommitProperty="value" CommitScript="e.value ;"
    Position="Bottom">
   </cc1:popupcontrolextender>

code:

Protected Sub RadioButtonList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadioButtonList1.SelectedIndexChanged

If MyTextBox.Text = "" Then

If Not (String.IsNullOrEmpty(RadioButtonList1.SelectedValue)) Then

               Dim r As String = RadioButtonList1.SelectedValue
               Dim s As String = MyTextBox.Text
               PopupControlExtender.GetProxyForCurrentPopup(Me.Page).Commit(r + s)
           End If
       Else
           If Not (String.IsNullOrEmpty(RadioButtonList1.SelectedValue)) Then

               Dim r As String = RadioButtonList1.SelectedValue
               Dim s As String = MyTextBox.Text
               PopupControlExtender.GetProxyForCurrentPopup(Me.Page).Commit(r + "," + s)
           End If
       End If
       'RadioButtonList1.ClearSelection()

End Sub

SQL count and avg

mfalac@mfalac.com (mfalac) — Wed, 09 Dec 2009 04:10:23 GMT

return uniqe row

SELECT DISTINCT [ArticleId], [ArticleTitle] FROM [BlogArticles]

sql data getting avg and count data

SELECT        ArticleId, AVG(CONVERT(decimal(4, 2), RateNumber)) AS AvgRating, SUM(RateNumber) AS ExprSumRateNumber, COUNT(ArticleId) AS CountArticleId
FROM            BlogRating
WHERE        (ArticleId = @ArticleId)
GROUP BY ArticleId

displaying in item temp?

counting rows

Dim dv As DataView
       Dim value As Integer
       dv = CType(SqlDataSourceRatingCount.Select(DataSourceSelectArguments.Empty), DataView)
       value = dv.Count
       LabelTest.Text = value

ELUVEITIE - Omnos

mfalac@mfalac.com (mfalac) — Tue, 08 Dec 2009 10:13:42 GMT