|
|
<html><head><link rel=stylesheet href=style.css></head><body><div class=SourcePanel style='font-size:12'><pre style='background-color:white'>
<font color= "blue">using</font> System;
<font color= "blue">using</font> System.Data;
<font color= "blue">using</font> ASPNET.StarterKit.TimeTracker.DataAccessLayer;
<font color= "blue">using</font> System.Configuration;
<font color= "blue"></font>
<font color= "blue">namespace</font> ASPNET.StarterKit.TimeTracker.BusinessLogicLayer
<font color= "blue"></font>{
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // ResourceReportUser Class</font>
<font color= "green"> //</font>
<font color= "green"> // This class represents User summary in Resource Report page</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"></font>
<font color= "blue"> public class</font> ResourceReportUser
<font color= "blue"> </font>{
<font color= "blue"> private </font>string _fullName;
<font color= "blue"> private </font>int _userID;
<font color= "blue"> private </font>string _userName;
<font color= "blue"> private </font>decimal _totalHours;
<font color= "blue"></font>
<font color= "blue"> public </font>ResourceReportUser()
<font color= "blue"> </font>{
<font color= "blue"> </font>_userID = 0;
<font color= "blue"> </font>_userName = string.Empty;
<font color= "blue"> </font>_totalHours = 0M;
<font color= "blue"> </font>_fullName = string.Empty;
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> public </font>string FullName
<font color= "blue"> </font>{
<font color= "blue"> get</font> { return _fullName; }
<font color= "blue"> set</font> { _fullName = value; }
<font color= "blue"> </font>}
<font color= "blue"> </font>
<font color= "blue"> public </font>int UserID
<font color= "blue"> </font>{
<font color= "blue"> get</font> {return _userID;}
<font color= "blue"> set</font> { _userID = value; }
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> public </font>string UserName
<font color= "blue"> </font>{
<font color= "blue"> get</font> { return _userName; }
<font color= "blue"> set</font> { _userName = value; }
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> public </font>decimal TotalHours
<font color= "blue"> </font>{
<font color= "blue"> get</font> { return _totalHours; }
<font color= "blue"> set</font> { _totalHours = value; }
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // GetUserSummary retrieves multiple user summaries and returns them in a collection.</font>
<font color= "green"> // userIdList is a comma delimited UserIDs string (i.e. "1,2,3").</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"></font>
<font color= "blue"> public </font>static ResourceReportUserCollection GetUserSummary(int mgrUserID, string userIdList, DateTime startDate, DateTime endDate)
<font color= "blue"> </font>{
<font color= "blue"> </font>DataSet dsUsers = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Web.Global.CfgKeyConnString],
<font color= "blue"> </font>"TT_ListUserTimeSummary", mgrUserID, userIdList, startDate, endDate);
<font color= "blue"> </font>ResourceReportUserCollection userList = new ResourceReportUserCollection();
<font color= "blue"> </font>
<font color= "green"> // Create a reference to display full name.</font>
<font color= "blue"> </font>string firstName = string.Empty;
<font color= "blue"> </font>string lastName = string.Empty;
<font color= "blue"></font>
<font color= "green"> // Separate Data into a collection of ResourceReportUser</font>
<font color= "blue"> </font>foreach(DataRow row in dsUsers.Tables[0].Rows)
<font color= "blue"> </font>{
<font color= "blue"> </font>ResourceReportUser usr = new ResourceReportUser();
<font color= "blue"> </font>usr.UserID = Convert.ToInt32(row["UserID"]);
<font color= "blue"> </font>usr.UserName = row["UserName"].ToString();
<font color= "blue"> </font>usr.TotalHours = Convert.ToDecimal(row["TotalHours"]);
<font color= "blue"> </font>usr.FullName = TTUser.GetDisplayName(usr.UserName, ref firstName, ref lastName);
<font color= "blue"> </font>
<font color= "blue"> </font>userList.Add(usr);
<font color= "blue"> </font>}
<font color= "blue"> return</font> userList;
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"></font>}
</pre>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Submit an article or tip