TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
selvi subramanian
NA
799
574.6k
How to use use .split method in javascript for split hours seconds and minutes in asp.net
Nov 1 2012 2:13 AM
How to use use .split method in javascript for split hours seconds and minutes in asp.net.
design
<%@ Page Language="C#" MasterPageFile="~/MasterPage/Team Lead.master" AutoEventWireup="true" CodeFile="TimePerformance.aspx.cs" Inherits="TeamLeaderModule_Default" Title="Untitled Page" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MLM_Logo" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" runat="server"
contentplaceholderid="FullContentArea">
</asp:Content>
<asp:Content ID="Content4" runat="server" contentplaceholderid="ContentReport">
<script type ="text/javascript">
function CheckOne(obj)
{
var grid = obj.parentNode.parentNode.parentNode;
var inputs = grid.getElementsByTagName("input");
var hck=document.getElementById('ctl00_ContentReport_Gridview1_ctl02_CheckBox1').value;
if(hck=="")
{
alert('se');
return false;
}
for(var i=0;i<inputs.length;i++)
{
if (inputs[i].type =="checkbox")
{
if (obj.checked && inputs[i] != obj && inputs[i].checked) {
inputs[i].checked = false;
}
}
}
}
</script>
<script type="text/javascript" language="javascript">
alert("start");
function err()
{
var timeper=document.getElementById('txteffh').value;
timeper="00:00:00";
var s=timeper.split(":");
return false;
}
}
</script>
<%--<script type="text/javascript">
function ddd()
{
if(document.getElementById("ddlattendanceslot").value=="0")
{
txttimein.en
}
}
</script>--%>
<asp:MultiView ID="MultiView1" runat="server">
<asp:View ID="View1" runat="server">
<form id="Form1" runat="server" >
<table align="center" style="border-color: #1d599e; height: 50px; border-style: inherit;
border-width: thin; " width="100%">
<tr style="background: #1d599e;">
<td align="center">
<span class="style9">
<strong>EMPLOYEE TIME PERFORMANCE</strong></span></td>
</tr>
<%-- <tr>
<td style="height: 5px;" align="left">
<asp:Label ID="Label19" runat="server" Text="To View Attendance:"></asp:Label>
<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">Click
Here</asp:LinkButton>
</td>
</tr>--%>
</table>
</form>
</asp:View>
<asp:View ID="View2" runat="server">
<form id="Form2" runat="server" onsubmit="return CheckOne(obj)">
<asp:GridView ID="Gridview1" runat="server"
AllowSorting="True" AutoGenerateColumns="false" CellPadding="4" DataKeyNames="Pk"
ForeColor="#333333" GridLines="None"
AllowPaging="true" PageSize="3"
style="height: 189px"
Width="292px"
onrowcommand="Gridview1_RowCommand" onrowdatabound="Gridview1_RowDataBound">
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:TemplateField HeaderText="Checkbox">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="sels" runat="server" Text=""></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="SlNo">
<ItemTemplate>
<asp:Label ID="lbpppk" runat="server" Text="<%#bind('Pk') %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date">
<ItemTemplate>
<asp:Label ID="lbdatee" runat="server" Text="<%#bind('Date') %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpId">
<ItemTemplate>
<asp:Label ID="lbeid" runat="server" Text="<%#bind('EmployeeId') %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpName">
<ItemTemplate>
<asp:Label ID="lename" runat="server" Text="<%#bind('EmployeeName') %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Attened Hours">
<ItemTemplate>
<asp:TextBox ID="txtah" runat="server" Enabled="False" Width="100px"/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Worked Hours">
<ItemTemplate>
<asp:TextBox ID="txtwh" runat="server" Enabled="False" Width="100px" ReadOnly="true"
AutoPostBack="True" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Effective Hours">
<ItemTemplate>
<asp:TextBox ID="txteffh" runat="server" Enabled="False" Width="100px"
AutoPostBack="True" ontextchanged="txteffh_TextChanged"/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Difference">
<ItemTemplate>
<asp:TextBox ID="txtdfrec" runat="server" Enabled="False" Width="100px"
AutoPostBack="True"/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="SUBMIT">
<ItemTemplate>
<asp:button id="button1" runat="server" text="Submit" onclick="button1_Click" OnClientClick="return validateCheckBoxes() " />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</form>
</asp:View>
<%-- <asp:View ID="view3" runat="server">
<table align="center" style="border-color: #1d599e; height: 50px; border-style: inherit;
border-width: thin; " width="100%">
<tr align="center">
<td>
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</td>
</tr>
<tr align="center">
<td>
<asp:Button ID="Button2" runat="server" Text="Button" onclick="Button2_Click" />
</td>
</tr>
</table>
</asp:View>--%>
</asp:MultiView>
</asp:Content>
source code is
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Globalization;
public partial class TeamLeaderModule_Default : System.Web.UI.Page
{
REMO obj = new REMO();
string s=ConfigurationManager.AppSettings["RM"].ToString();
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View2);
Grid();
}
}
private void Grid()
{
string q = "select convert([varchar],getdate(),(103)) as Date,Pk,EmployeeId,EmployeeName from EmpPersonal";
DataSet ds = new DataSet();
ds = obj.GETDS(q);
Gridview1.Visible = true;
Gridview1.DataSource = ds;
Gridview1.DataBind();
foreach (GridViewRow gvr in Gridview1.Rows)
{
TextBox AttenedHourst = (TextBox)(Gridview1.Rows[gvr.RowIndex].Cells[4].FindControl("txtah"));
TextBox WorkedHourst = (TextBox)(Gridview1.Rows[gvr.RowIndex].Cells[5].FindControl("txtwh"));
TextBox EffectiveHourst = (TextBox)(Gridview1.Rows[gvr.RowIndex].Cells[6].FindControl("txteffh"));
TextBox Differencet = (TextBox)(Gridview1.Rows[gvr.RowIndex].Cells[7].FindControl("txtdfrec"));
AttenedHourst.Enabled = true;
WorkedHourst.Enabled = true;
EffectiveHourst.Enabled = true;
Differencet.Enabled = true;
}
}
protected void Gridview1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
LinkButton ll = (LinkButton)e.CommandSource;
if (ll != null)
ll.Text = "Submitted";
}
}
protected void Gridview1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
con = new SqlConnection(s);
con.Open();
string emid = ((Label)e.Row.FindControl("lbeid")).Text;
string EffectiveHours = ((TextBox)e.Row.FindControl("txtwh")).Text;
string AttenedHours = ((TextBox)e.Row.FindControl("txtah")).Text;
string WorkedHours = ((TextBox)e.Row.FindControl("txtwh")).Text;
string Difference = ((TextBox)e.Row.FindControl("txtdfrec")).Text;
DataSet ds = new DataSet();
string qry = "select HoursWorked from logout where EmployeeId='" + emid + "'";
ds= obj.GETDS(qry);
con.Close();
for(int i=0; i<ds.Tables[0].Rows.Count; i++)
{
EffectiveHours = ds.Tables[0].Rows[i]["HoursWorked"].ToString();
}
((TextBox)e.Row.FindControl("txtwh")).Text = EffectiveHours;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in Gridview1.Rows)
{
string date = ((Label)gvr.FindControl("lbdatee")).Text;
string emid = ((Label)gvr.FindControl("lbeid")).Text;
string eename = ((Label)gvr.FindControl("lename")).Text;
string AttenedHours = ((TextBox)gvr.FindControl("txtah")).Text;
string WorkedHours = ((TextBox)gvr.FindControl("txtwh")).Text;
string EffectiveHours = ((TextBox)gvr.FindControl("txteffh")).Text;
string lal5 = ((TextBox)gvr.FindControl("txtdfrec")).Text;
((TextBox)gvr.FindControl("txtdfrec")).Text = lal5;
string ars = "insert into Timeperformamce(Date,EmpID,EmpName,TotalHours) values ('" + date;
ars += "','" + emid;
ars += "','" + eename;
ars += "','" + lal5;
ars += "')";
obj.Insert(ars);
}
}
protected void txteffh_TextChanged(object sender, EventArgs e)
{
foreach (GridViewRow gvr in Gridview1.Rows)
{
if (((CheckBox)gvr.FindControl("CheckBox1")).Checked == true)
{
string lal3 = "01-01-0001 " + ((TextBox)gvr.FindControl("txtwh")).Text;
string lal4 = "01-01-0001 " + ((TextBox)gvr.FindControl("txteffh")).Text;
string lal5 = ((TextBox)gvr.FindControl("txtdfrec")).Text;
DateTime d1 = DateTime.ParseExact(lal3, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
DateTime d2 = DateTime.ParseExact(lal4, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
TimeSpan tSpan = d2 - d1;
lal5 = tSpan.ToString();
((TextBox)gvr.FindControl("txtdfrec")).Text = lal5;
}
}
}
protected void button1_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in Gridview1.Rows)
{
if (((CheckBox)gvr.FindControl("CheckBox1")).Checked == true)
{
string date = ((Label)gvr.FindControl("lbdatee")).Text;
string emid = ((Label)gvr.FindControl("lbeid")).Text;
string eename = ((Label)gvr.FindControl("lename")).Text;
string AttenedHours = ((TextBox)gvr.FindControl("txtah")).Text;
string WorkedHours = ((TextBox)gvr.FindControl("txtwh")).Text;
string EffectiveHours = ((TextBox)gvr.FindControl("txteffh")).Text;
string lal5 = ((TextBox)gvr.FindControl("txtdfrec")).Text;
((TextBox)gvr.FindControl("txtdfrec")).Text = lal5;
string ars = "insert into Timeperformamce(Date,EmpID,EmpName,TotalHours) values ('" + date;
ars += "','" + emid;
ars += "','" + eename;
ars += "','" + lal5;
ars += "')";
obj.Insert(ars);
}
}
}
}
what wrong in this query
it throws the error in this line
DateTime d2 = DateTime.ParseExact(lal4, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
... i need if i give in effective hours as constant (1) need to throw the error
Reply
Answers (
7
)
How to select a row without using using select button in entity framework
How to copy one Datatable to another datatable using asp.net C#