public void Load(List <string> userEmailAddList)
{
string connectionString = ConfigurationManager.ConnectionStrings["SecurityDb"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
foreach (string userEmailAdd in userEmailAddList)
{
try
{
myConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
string queryString = "select ResourceConsumerId as resourceconsumerid,ResourceConsumerName as resourceconsumername,ResourceConsumerEmailAdd as resourceconsumeremailadd from ResourceConsumer where resourceconsumeremailadd = '" + userEmailAdd + "';";
cmd.CommandText = queryString;
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
foreach (DataRow row in dt.Rows)
{
ResourceConsumer resourceConsumer = new ResourceConsumer();
resourceConsumer.resourceConsumerId = Convert.ToInt16(row["resourceconsumerid"].ToString());
resourceConsumer.resourceConsumerName = row["resourceconsumername"].ToString();
resourceConsumer.resourceConsumerEmail = row["resourceconsumeremailadd"].ToString();
this.resourceConsumerLocal.Add(resourceConsumer);
}
myConnection.Close();
}
catch (Exception e)
{
Console.WriteLine("this is not successful :" + e.Message.ToString());
}
}
}
public void Load(List <Guid> resourceGuids)
{
string connectionString = ConfigurationManager.ConnectionStrings["SecurityDb"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
List <Guid> returnResourceList = new List <Guid>();
foreach (Guid g in resourceGuids)
{
try
{
myConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
string queryString = "select ResourceId as resourceid,RequesterId as requesterid,DateRequested as daterequested,Priviledge as priviledgetype,IsGranted as status from DataRequest where resourceid='" + g + "' and isgranted =0;";
cmd.CommandText = queryString;
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
foreach (DataRow row in dt.Rows)
{
RequestManagement rm = new RequestManagement();
Guid gd = new Guid(row["resourceid"].ToString());
TimeSeriesResource timeRes = new TimeSeriesResource();
rm.timeResource = timeRes.GetTimeSeriesObjectbyDataGuid(gd);
int resConId = Convert.ToInt16(row["requesterid"].ToString());
ResourceConsumer resCon = new ResourceConsumer();
rm.resConsumer = resCon.Load(resConId);
rm.dateRequested = Convert.ToDateTime(row["daterequested"].ToString());
rm.status = row["status"].ToString();
Priviledge pv = new Priviledge();
pv.Load(Convert.ToInt16(row["priviledgetype"].ToString()));
rm.privilegeType = pv.priviledgeType;
this.resourceManagementLocal.Add(rm);
}
myConnection.Close();
}
catch (Exception e)
{
Console.WriteLine("this is not successful :" + e.Message.ToString());
}
}
}
public void Load(List <Guid> resourceGuids)
{
string connectionString = ConfigurationManager.ConnectionStrings["SecurityDb"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
List <Guid> returnResourceList = new List <Guid>();
foreach (Guid g in resourceGuids)
{
try
{
myConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
string queryString = "select PersonResourcesId as personresourceid,ResourcesId as resourceid,PersonId as personid,PrivilegesGivenBy as authorizerid,PrivilegeId as privilegeid, DateCreated as datecreated, DateValidTill as datevalidtill from PersonResources where resourcesid='" + g + "';";
cmd.CommandText = queryString;
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
foreach (DataRow row in dt.Rows)
{
Authorization auth = new Authorization();
Guid gd = new Guid(row["resourceid"].ToString());
auth.personResourceId = Convert.ToInt16(row["personresourceid"].ToString());
TimeSeriesResource tm = new TimeSeriesResource();
auth.timeResources = tm.GetTimeSeriesObjectbyDataGuid(gd);
ResourceConsumer resCon = new ResourceConsumer();
auth.person = resCon.Load(Convert.ToInt16(row["personid"].ToString()));
auth.authorizer = resCon.Load(Convert.ToInt16(row["authorizerid"].ToString()));
auth.priviledgeId = Convert.ToInt16(row["privilegeid"].ToString());
auth.dateCreated = Convert.ToDateTime(row["datecreated"].ToString());
auth.dateValidTill = Convert.ToDateTime(row["datevalidtill"].ToString());
this.authList.Add(auth);
}
myConnection.Close();
}
catch (Exception e)
{
Console.WriteLine("this is not successful :" + e.Message.ToString());
}
}
}