string sql = "",code = "",Inout = "",EmployeeCode = "",TerminalNo = "";
int year = 0,month = 0,day = 0,hour = 0,minute = 0;
string text = string.Empty;
UploadId = Convert.ToInt32(munshi.getcolnum("select MAX(isnull(uploadid,0)) + 1 from attendance"));
if (UploadId == -1)
{
UploadId = UploadId + 1;
}
do
{
text = reader.ReadLine();
if (text == null)
break;
else if (text == string.Empty)
{
text = "1";
continue;
}
#region S p l i t t i n g D a t e
year = Convert.ToInt32(text.Substring(2, 4));
month = Convert.ToInt32(text.Substring(6, 2));
day = Convert.ToInt32(text.Substring(8, 2));
hour = Convert.ToInt32(text.Substring(10, 2));
minute = Convert.ToInt32(text.Substring(12, 2));
#endregion
code = text.Substring(0, 2);
Inout = text.Substring(14, 4);
EmployeeCode = text.Substring(18, 10);
TerminalNo = text.Substring(28, 4);
DateTime date = new DateTime(year,month,day,hour, minute, 0);
}
while (!string.IsNullOrEmpty(text));