private void groupOfUsersToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
Logic.Interfaces.Projects.IUser user = new Logic.Projects.User(BTSS.Common.Core.ProjectConnectionString, Common.Core.ProjectDataProvider);
DataTable dt = new DataTable();
dt = user.GetUserGroupList();
dt.DefaultView.Sort = "full_name ASC";
using (var reportViewer = new Common.ReportViewer())
{
reportViewer.ReportTitle = "Group of Users";
reportViewer.XMLName = "GroupOfUsers";
reportViewer.ReportSource = (new Reports.ReportGroupOfUsers());
reportViewer.SetDatasource(dt.DefaultView.ToTable());
reportViewer.ShowReport();
}
}
catch (Exception)
{
throw;
}
}
private void displayProjectsMenuStrip_ItemClicked(object sender, EventArgs e)
{
try
{
//Initialize datatable for reporting
DataTable dtUserProjects = new DataTable();
dtUserProjects.Columns.Add("ProjectName");
dtUserProjects.Columns.Add("Description");
dtUserProjects.Columns.Add("BusinessOwner");
dtUserProjects.Columns.Add("IsActive", typeof(bool));
dtUserProjects.Columns.Add("Provider");
dtUserProjects.Columns.Add("File");
dtUserProjects.Columns.Add("Datasource");
dtUserProjects.Columns.Add("DatabaseName");
//Connection Variables
Logic.Project project = new BTSS.Logic.Project(Common.Core.ConnectionString);
Logic.Connection connection = null;
Common.Core.DataProvider provider = BTSS.Common.Core.DataProvider.OLEDB;
string connectionString = "";
string selectedUserName;
selectedUserName = userControlListing.dataGridViewList.SelectedRows[0].Cells["user_name"].Value.ToString();
//User's project object
Logic.Interfaces.Projects.IUser user;
//Iterate ALL projects
foreach (Logic.Project p in project.GetAllProjects())
{
if (p.Provider == "OLEDB")
{
connectionString = Common.Core.GetConnectionString(p.File, p.UserID, p.Password, p.HasOtherDetails, p.MDW);
connection = new BTSS.Logic.Connection(connectionString, BTSS.Common.Core.DataProvider.OLEDB);
provider= BTSS.Common.Core.DataProvider.OLEDB;
}
else if (p.Provider == "SQL")
{
connectionString = Common.Core.GetConnectionString(p.Datasource, p.DatabaseName, p.UserID, p.Password);
connection = new BTSS.Logic.Connection(connectionString, BTSS.Common.Core.DataProvider.SQL);
provider= BTSS.Common.Core.DataProvider.SQL;
}
//check if database has connection
if (connection.HasConnection())
{
user = new Logic.Projects.User(connectionString, provider);
if (user.IsExist(selectedUserName))
dtUserProjects.Rows.Add(p.Name, p.Desc, p.BusinessOwner, p.IsActive, p.Provider, p.File, p.Datasource, p.DatabaseName);
}
}
using (var reportViewer = new Common.ReportViewer())
{
reportViewer.ReportTitle = selectedUserName + " Projects";
reportViewer.XMLName = "UsersProjectList";
reportViewer.ReportSource = (new Reports.ReportUsersProjectList());
reportViewer.SetDatasource(dtUserProjects);
reportViewer.ShowReport();
}
}
catch (Exception)
{
throw;
}
}
private void projectListToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
Logic.Project classProject = new Project(BTSS.Common.Core.ConnectionString);
DataTable dt = new DataTable();
dt = classProject.GetProjectListForReport();
using (var reportViewer = new Common.ReportViewer())
{
reportViewer.ReportTitle = "Project List";
reportViewer.XMLName = "ProjectList";
reportViewer.ReportSource = (new Reports.ReportProjectList());
reportViewer.SetDatasource(dt);
reportViewer.ShowReport();
}
}
catch (Exception)
{
throw;
}
}
private void userControlListingData_OnPrint(object sender, EventArgs e)
{
try
{
switch (_TransactionType)
{
case TransactionTypes.MemberOfGroup:
using (var reportViewer = new Common.ReportViewer())
{
reportViewer.ReportTitle = "Member of Group: " + _Domain;
reportViewer.XMLName = "MemberOfGroup";
reportViewer.ReportSource = (new Reports.ReportMemberOfGroup());
////Uncomment this code for purpose to write XML schema
//reportViewer.SetDatasource(dtUser);
reportViewer.SetDatasource(users.ToList());
reportViewer.ShowReport();
//List<Reports.GroupOfUsers> header = new List<BTSS.Presentation.Reports.GroupOfUsers>();
//List<Reports.GroupOfUsersDetails> details = new List<BTSS.Presentation.Reports.GroupOfUsersDetails>();
//header.Add(new BTSS.Presentation.Reports.GroupOfUsers() { DisplayName = "mike", Domain= "watat", UserName = "******" });
//details.Add(new BTSS.Presentation.Reports.GroupOfUsersDetails() { ComputerName="wagrh", Email = "[email protected]", UserName="******" });
//List<Object> listGroupOfUsers = new List<object>();
//listGroupOfUsers.Add(header);
//listGroupOfUsers.Add(details);
//reportViewer.ReportTitle = "Member of Group: " + _Domain;
//reportViewer.XMLName = "MemberOfGroup";
//reportViewer.ReportSource = (new Reports.ReportMemberOfGroup());
//reportViewer.SetDatasource(listGroupOfUsers);
//reportViewer.ShowReport();
}
break;
}
}
catch (Exception)
{
throw;
}
}
