/// <summary>
/// Funzione per il reperimento del full qualified name associato ad un documento
/// </summary>
/// <param name="mTextDocInfo">Informazioni sul documento di cui reperire l'FQN</param>
public MTextDocumentInfo GetMTextFullQualifiedName(MTextDocumentInfo mTextDocInfo)
{
ParameterSP fullQualifiedName = new ParameterSP("fqn", String.Empty, 500, DirectionParameter.ParamOutput, DbType.String);
// Creazione lista dei parametri
ArrayList parameters = new ArrayList();
parameters.Add(new ParameterSP("versionId", mTextDocInfo.DocumentVersionId, DirectionParameter.ParamInput));
parameters.Add(new ParameterSP("docNumber", mTextDocInfo.DocumentDocNumber, DirectionParameter.ParamInput));
parameters.Add(fullQualifiedName);
// Esecuzione store
try
{
DataSet ds = new DataSet();
this.ExecuteStoredProcedure(GET_FQN, parameters, ds);
}
catch (Exception e)
{
throw new ApplicationException("Si è verificato un problema durante il reperimento dell'FQN associato al documento.");
}
// Impostazione e restituzione FQN
mTextDocInfo.FullQualifiedName = fullQualifiedName.Valore.ToString();
return(mTextDocInfo);
}
public static void SetLists(System.Web.UI.WebControls.ListControl myListControl, string operate, string userID, string userRole, string schoolYear)
{
string sp = "dbo.tcdsb_PLF_ListDDL2New @Operate,@UserID,@UserRole,@SchoolYear";
ParameterSP parameter = new ParameterSP {
Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear
};
List <List2Item> myList = GeneralDataAccess.GetLists(sp, parameter);
// List<List2Item> myList = UListItem.GetLists(operate, userID, userRole, schoolYear); /// new List<List2Item>();
AssemblingMyList(myListControl, myList);
}
/// <summary>
/// Funzione per la creazione di un parametro da passare ad una store
/// </summary>
/// <param name="parameterName">Nome del parametro</param>
/// <param name="initializationValue">Valore da utilizzare per inizializzare il parametro</param>
/// <param name="parameterDirection">Direzione del parametro</param>
/// <param name="parameterLength">Lunghezza del campo</param>
/// <param name="parameterType">Tipo di parametro</param>
/// <returns>Parametro da inviare alla store</returns>
private ParameterSP CreateParameter(String parameterName, Object initializationValue, DirectionParameter parameterDirection, int parameterLength, DbType parameterType)
{
// Creazione e restituzione del parametro
ParameterSP parameter;
parameter = new ParameterSP(parameterName, initializationValue, parameterDirection);
parameter.Size = parameterLength;
parameter.Tipo = parameterType;
return(parameter);
}
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, string operate, string userID, string userRole, string schoolYear, string schoolCode)
{
string sp = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
ParameterSP parameter = new ParameterSP {
Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode
};
List <List2Item> myList = GeneralDataAccess.GetLists(sp, parameter);
//List<List2Item> myList = new List<List2Item>();
// myList = DAListItem.GetLists(operate, userID);
// myList = UListItem.GetLists(operate, userID, userRole, schoolYear, schoolCode);
AssemblingSchoolList(myListControl, myListControl2, myList);
}
private static string getProfile(string pType)
{
try
{
ParameterSP parameter = new ParameterSP {
Operate = pType, UserID = HttpContext.Current.User.Identity.Name
};
return(GeneralDataAccess.TextValue(SP, parameter));
// return SignatureProcess.SignoffResult(operate, userID, userRole, schoolYear, schoolCode, actionType, actionDate);
}
catch (Exception ex)
{
var exm = ex.Message;
return("Failed");
}
}
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode)
{
try
{
ParameterSP parameter = new ParameterSP {
Operate = method, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode
};
List <SiteTeams> teams = GeneralDataAccess.GetTeamList(sp, parameter);
myGridView.DataSource = teams;
myGridView.DataBind();
}
catch (System.Exception ex)
{
string em = ex.Message;
}
}
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, string operate, string userID, string userRole, string schoolYear, string schoolCode)
{
ParameterSP parameter = new ParameterSP {
Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode
};
SetLists2(myListControl, myListControl2, parameter);
// string sp = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
//// List<List2Item> myList = GeneralDataAccess.GetLists(sp, parameter);
//List<List2Item> myList = GeneralDataAccess.GetObjectList<List2Item>(sp, parameter);
////List<List2Item> myList = new List<List2Item>();
//// myList = DAListItem.GetLists(operate, userID);
//// myList = UListItem.GetLists(operate, userID, userRole, schoolYear, schoolCode);
//AssemblingMyList(myListControl, myList, "myValue", "myValue"); // school Code DDL
//AssemblingMyList(myListControl2, myList, "myValue", "myText"); // School Name DDL
}
private void AssemblePage()
{
ParameterSP parameter = new ParameterSP {
Operate = "SchoolYearbySchool", UserID = User.Identity.Name, UserRole = WorkingProfile.UserRole, SchoolCode = WorkingProfile.SchoolCode
};
AssembleListItem.SetLists(ddlSchoolYear, parameter);
// AssembleListItem.SetLists(ddlSchoolYear, "SchoolYearbySchool", User.Identity.Name, WorkingProfile.UserRole, WorkingProfile.SchoolCode);
AssembleListItem.SetValue(ddlSchoolYear, UserProfile.CurrentSchoolYear);
parameter.Operate = "SchoolList";
parameter.SchoolYear = WorkingProfile.SchoolYear;
// ParameterSP parameter1 = new ParameterSP { Operate = "SchoolList", UserID = User.Identity.Name, UserRole = WorkingProfile.UserRole, SchoolYear = WorkingProfile.SchoolYear, SchoolCode = WorkingProfile.SchoolCode };
AssembleListItem.SetLists2(ddlSchoolCode, ddlSchool, parameter);
// AssembleListItem.SetLists2(ddlSchoolCode, ddlSchool, "SchoolList", User.Identity.Name, WorkingProfile.UserRole, ddlSchoolYear.SelectedValue, WorkingProfile.SchoolCode);
InitialPage();
}
public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode)
{
try
{
if (listPage == "SchoolHistory")
{
string sp = "dbo.tcdsb_PLF_SchoolHistoryNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
ParameterSP parameter = new ParameterSP {
Operate = method, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode
};
List <School> schools = GeneralDataAccess.GetSchoolList(sp, parameter);
//schools = PublishListDA.GetSchoolHistroy("Get", "", userID, schoolyear, schoolcode);
myGridView.DataSource = schools;
myGridView.DataBind();
}
}
catch (System.Exception ex)
{
string em = ex.Message;
}
}
private void BindDDLList()
{
string schoolyear = PLF.WorkingProfile.SchoolYear;
string schoolcode = PLF.WorkingProfile.SchoolCode;
string role = PLF.WorkingProfile.UserRole;
string superArea = PLF.WorkingProfile.UserArea;
ParameterSP parameter = new ParameterSP {
Operate = "SchoolYearbySchool", UserID = User.Identity.Name, UserRole = role, SchoolYear = schoolyear
};
ddlSuperarea.Visible = true;
AssembleListItem.SetLists(ddlSchoolYear, parameter, schoolyear);
// AssembleListItem.SetValue(ddlSchoolYear, schoolyear);
if (role == "Principal" || role == "vPrincipal")
{
ddlSuperarea.Visible = false;
superArea = "";
}
if (role == "Superintendent")
{
ddlSuperarea.Enabled = false;
// PLF.WorkingProfile.UserArea = AppraisalProfile.ProfileUser.Area(User.Identity.Name, schoolyear, schoolcode);
}
parameter.Operate = "TPASuperArea";
AssembleListItem.SetLists(ddlSuperarea, parameter, superArea); // "TPASuperArea", User.Identity.Name, role, schoolyear);
// AssembleListItem.SetValue(ddlSuperarea, superArea);
// AssembleListItem.SetLists2( ddlSchoolCode, ddlSchools, "SchoolListP", User.Identity.Name, role,schoolyear, superArea);
parameter.Operate = "SchoolListP";
parameter.SchoolCode = superArea;
AssembleListItem.SetLists2(ddlSchoolCode, ddlSchools, parameter);
AssembleListItem.SetValue(ddlSchools, schoolcode);
AssembleListItem.SetValue(ddlSchoolCode, schoolcode);
}
public static void SetLists(System.Web.UI.WebControls.ListControl myListControl, ParameterSP parameter, object initialValue)
{
SetLists(myListControl, parameter);
SetValue(myListControl, initialValue);
}
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, ParameterSP parameter, object initialValue)
{
SetLists2(myListControl, myListControl2, parameter);
SetValue(myListControl, initialValue);
SetValue(myListControl2, initialValue);
}
public static void SetLists2(System.Web.UI.WebControls.DropDownList myListControl, System.Web.UI.WebControls.DropDownList myListControl2, ParameterSP parameter)
{
string sp = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
List <List2Item> myList = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter);
AssemblingMyList(myListControl, myList, "myValue", "myValue"); // school Code DDL
AssemblingMyList(myListControl2, myList, "myValue", "myText"); // School Name DDL
}
public static void SetLists(System.Web.UI.WebControls.ListControl myListControl, ParameterSP parameter)
{
string sp = "dbo.tcdsb_PLF_ListDDL2New @Operate,@UserID,@UserRole,@SchoolYear";
List <List2Item> myList = GeneralDataAccess.GetListofTypeT <List2Item>(sp, parameter);
AssemblingMyList(myListControl, myList);
}
