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
566.7k
how to find the difference in time
Oct 25 2012 1:47 AM
Design
<%@ Page Language="C#" MasterPageFile="~/MasterPage/Team Lead.master" AutoEventWireup="true" CodeFile="TimePerformance.aspx.cs" Inherits="TeamLeaderModule_Default" Title="Untitled Page" %>
<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">
function validateCheckBoxes()
{
var isValid = false;
var gridView = document.getElementById('<%= Gridview1.ClientID %>');
for (var i = 1; i < gridView.rows.length; i++)
{
var inputs = gridView.rows[i].getElementsByTagName('input');
if (inputs != null)
{
if (inputs[0].type == "checkbox")
{
if (inputs[0].checked)
{
isValid = true;
return true;
}
}
}
}
alert("Please Select atleast one checkbox to Allocate Task");
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>
</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" />
</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>
Code
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;
//((TextBox)e.Row.FindControl("txtah")).Text = AttenedHours;
//((TextBox)e.Row.FindControl("txtwh")).Text = WorkedHours;
//((TextBox)e.Row.FindControl("txtdfrec")).Text = Difference;
}
}
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 Difference = ((TextBox)gvr.FindControl("txtdfrec")).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 += "','" + atence;
// ars += "','" + AttenedHours;
// ars += "','" + WorkedHours;
// ars += "','" + EffectiveHours;
ars += "','" + lal5;
ars += "')";
obj.Insert(ars);
}
}
// protected void txtdfrec_TextChanged(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 Difference = ((TextBox)gvr.FindControl("txtdfrec")).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 += "','" + atence;
// // ars += "','" + AttenedHours;
// // ars += "','" + WorkedHours;
// // ars += "','" + EffectiveHours;
// 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 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 Difference = ((TextBox)gvr.FindControl("txtdfrec")).Text;
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;
// string L = System.DateTime.Now.ToString();
// string Difference = ((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();
//lal5 = tSpan.Tostring();
((TextBox)gvr.FindControl("txtdfrec")).Text = lal5;
// int a, b, c;
// a = int.Parse(lal3);
// b = int.Parse(lal4);
// c = (a - b);
// Difference = c.ToString();
//((TextBox)gvr.FindControl("txteffh")).Text = EffectiveHours;
//((TextBox)gvr.FindControl("txtwh")).Text = WorkedHours;
//((TextBox)gvr.FindControl("txtdfrec")).Text = Difference;
}
}
}
//protected void txteffh_TextChanged(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 Difference = ((TextBox)gvr.FindControl("txtdfrec")).Text;
// 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;
// // string L = System.DateTime.Now.ToString();
// // string Difference = ((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();
// //lal5 = tSpan.Tostring();
// ((TextBox)gvr.FindControl("txtdfrec")).Text = lal5;
// // int a, b, c;
// // a = int.Parse(lal3);
// // b = int.Parse(lal4);
// // c = (a - b);
// // Difference = c.ToString();
// //((TextBox)gvr.FindControl("txteffh")).Text = EffectiveHours;
// //((TextBox)gvr.FindControl("txtwh")).Text = WorkedHours;
// //((TextBox)gvr.FindControl("txtdfrec")).Text = Difference;
// }
// }
// }
}
i need the differece in time is like (01:00:00-00:00:20) if i give 01:00:00 like this the worked hours is retrieve from another table and i give the worked hours it should be subtracted from effective hours . and the time difference should be show in the difference textbox .the value should not be inserted
Reply
Answers (
0
)
Validation With Drop Down List
How to get value the data in datagridview?