/// <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); }