public static bool DeleteLoginGroup(SecureWindow oSecWin, LoginGroup oGroup, AccessType oAccessTyp)
{
bool isSuccess = false;
DBHelper Data = new DBHelper();
Data.Command.CommandType = CommandType.StoredProcedure;
Data.Command.CommandText = "bvLoginGroupAccessDelete";
Data.Command.Parameters.Add(new SqlParameter("@a_vcLoginGroupID", oGroup.ID));
Data.Command.Parameters.Add(new SqlParameter("@a_vcSecureWindowID", oSecWin.ID));
Data.Command.Parameters.Add(new SqlParameter("@a_vcAccessTypeId", oAccessTyp.ID));
try
{
int rowsEffected = Data.ExecuteNonQuery();
isSuccess = rowsEffected > 0;
}
catch (Exception ex)
{
isSuccess = false;
throw ex;
}
return(isSuccess);
}
public static LoginGroup Get(string ID)
{
LoginGroup oEntity = null;
DBHelper Data = new DBHelper();
SqlDataReader dr = null;
Data.Command.CommandType = CommandType.StoredProcedure;
Data.Command.CommandText = "bvLoginGroupGetDetail";
Data.Command.Parameters.Add(new SqlParameter("@a_vcUniqueID", ID));
try
{
dr = Data.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
oEntity = initialize(dr, ObjectInitializationTypes.KeyFields);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dr.Close();
}
return(oEntity);
}
public void LoadView(ViewType typeView)
{
switch (typeView)
{
case ViewType.MainMenu:
MainMenu view = new MainMenu();
MainMenuViewModel viewModel = new MainMenuViewModel(this);
//связываем их с собой
view.DataContext = viewModel;
//отображаем
this.Page.Content = view;
break;
case ViewType.CreateGroup:
CreateGroup CreateGroupView = new CreateGroup();
CreateGroupViewModel CreateGroupViewModel = new CreateGroupViewModel(this, weeksDataBase);
CreateGroupView.DataContext = CreateGroupViewModel;
this.Page.Content = CreateGroupView;
break;
case ViewType.LoginGroup:
LoginGroup LoginGroupView = new LoginGroup();
LoginGroupViewModel LoginGroupViewModel = new LoginGroupViewModel(this, weeksDataBase);
LoginGroupView.DataContext = LoginGroupViewModel;
this.Page.Content = LoginGroupView;
break;
case ViewType.WeekList:
WeekList WeekListView = new WeekList();
WeekListViewModel WeekListViewModel = new WeekListViewModel(this, weeksDataBase);
WeekListView.DataContext = WeekListViewModel;
this.Page.Content = WeekListView;
break;
case ViewType.TimeTable:
TimeTable TimeTableView = new TimeTable();
TimeTableViewModel TimeTableViewModel = new TimeTableViewModel(this, weeksDataBase, disciplinesDataBase, TimeTableView);
TimeTableView.DataContext = TimeTableViewModel;
this.Page.Content = TimeTableView;
break;
}
}
private static LoginGroup initialize(SqlDataReader dr, ObjectInitializationTypes initializationType)
{
LoginGroup oEntity = new LoginGroup();
oEntity.ID = Convert.ToString(dr["LoginGroupID"]);
oEntity.Name = Convert.ToString(dr["LoginGroupName"]);
oEntity.Description = Convert.ToString(dr["LoginGroupDescr"]);
switch (initializationType)
{
case ObjectInitializationTypes.CompleteAndNoChild:
break;
case ObjectInitializationTypes.CompleteAndKeyFieldsOfChild:
break;
case ObjectInitializationTypes.Full:
break;
}
return(oEntity);
}
public static bool Delete(LoginGroup oEntity)
{
bool isSuccess = false;
DBHelper Data = new DBHelper();
Data.Command.CommandType = CommandType.StoredProcedure;
Data.Command.CommandText = "bvLoginGroupDelete";
Data.Command.Parameters.Add(new SqlParameter("@a_vcLoginGroupID", oEntity.ID));
try
{
int rowsEffected = Data.ExecuteNonQuery();
isSuccess = rowsEffected > 0;
}
catch (Exception ex)
{
isSuccess = false;
throw ex;
}
return(isSuccess);
}
public static List <AccessType> GetAccessTypesByLoginGroupAndWindow(LoginGroup oLoginGroup, SecureWindow oSecWindow)
{
List <AccessType> accessTypes = new List <AccessType>();
DBHelper Data = new DBHelper();
SqlDataReader dr = null;
Data.Command.CommandType = CommandType.StoredProcedure;
Data.Command.CommandText = "bvLoginGroupAccessGetDoubleKeyedList";
Data.Command.Parameters.Add(new SqlParameter("@a_vcKeyOne", oLoginGroup.ID));
Data.Command.Parameters.Add(new SqlParameter("@a_vcKeyTwo", oSecWindow.ID));
try
{
dr = Data.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
AccessType oEntity = new AccessType();
oEntity.ID = Convert.ToString(dr["AccessTypeID"]); // Probably we need to add Null Check and if it is Null we should return empty string
oEntity.Name = Convert.ToString(dr["AccessTypeName"]);
oEntity.IsGranted = Convert.ToString(dr["Granted"]);
accessTypes.Add(oEntity);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dr.Close();
}
return(accessTypes);
}
public List <AccessType> GetAccessTypesByLoginGroupAndWindow(LoginGroup oLoginGroup, SecureWindow oSecWindow)
{
return(AccessTypeDAL.GetAccessTypesByLoginGroupAndWindow(oLoginGroup, oSecWindow));
}
public bool UpdateLoginGroupAccess(LoginGroup oGroup, SecureWindow oWindow, AccessType oAccessType)
{
return(SecureWindowDAL.UpdateLoginGroup(oWindow, oGroup, oAccessType));
}
public bool Delete(LoginGroup oEntity)
{
return(LoginGroupDAL.Delete(oEntity));
}
public bool Update(LoginGroup oEntity)
{
return(LoginGroupDAL.Update(oEntity));
}
public bool Add(LoginGroup oEntity)
{
oEntity.ID = DALUtility.GetUniqueId(DALConstants.UniqueIdLoginGroupType);
return(LoginGroupDAL.Add(oEntity));
}
