protected void BindSchoolStandard() { try { string schooltype = null; //if (ddlSchoolType.SelectedItem.Text == "Select Type") //{ // schooltype = null; //} //else //{ // schooltype = ddlSchoolType.SelectedItem.Text; //} DataTable dtStandard = TMSSchoolCategory.GetSearch(null, null, null, null, 1).Tables[0]; if (dtStandard.Rows.Count > 0) { ddlStandard.DataSource = dtStandard; ddlStandard.DataValueField = "SC_CategoryId"; ddlStandard.DataTextField = "SC_CategoryName"; ddlStandard.DataBind(); ddlStandard.Items.Insert(0, new ListItem("Select Standard", "-1")); ddlDivision.Items.Insert(0, new ListItem("Select Division", "-1")); } } catch (Exception ex) { } }
public static TMSSchoolCategory Get(System.Int64 scCategoryId) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; TMSSchoolCategory instance; instance = new TMSSchoolCategory(); db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSchoolCategory_SELECT"; dbCommand = db.GetStoredProcCommand(sqlCommand, scCategoryId); // Get results. ds = db.ExecuteDataSet(dbCommand); // Verification. if (ds == null || ds.Tables[0].Rows.Count == 0) { throw new ApplicationException("Could not get TMSSchoolCategory ID:" + scCategoryId.ToString() + " from Database."); } // Return results. ds.Tables[0].TableName = TABLE_NAME; instance.MapFrom(ds.Tables[0].Rows[0]); return(instance); }
protected DataSet GetSchoolCategory() { var dsSchoolCategory = TMSSchoolCategory.GetAllSchoolCategory(); DataRow rw = dsSchoolCategory.Tables[0].NewRow(); rw["SC_CategoryId"] = "0"; rw["SC_CategoryName"] = "Select"; dsSchoolCategory.Tables[0].Rows.InsertAt(rw, 0); return(dsSchoolCategory); }
public static TMSSchoolCategory[] Search(System.Int64?scCategoryId, System.String scCategoryName, System.String scSchoolType, System.DateTime?scDate, System.Int32?scStatus) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSchoolCategory_SEARCH"; dbCommand = db.GetStoredProcCommand(sqlCommand, scCategoryId, scCategoryName, scSchoolType, scDate, scStatus); ds = db.ExecuteDataSet(dbCommand); ds.Tables[0].TableName = TABLE_NAME; return(TMSSchoolCategory.MapFrom(ds)); }
public CascadingDropDownNameValue[] BindStandard(string knownCategoryValues, string category) { string[] str = knownCategoryValues.Split(':'); string SchoolType = str[1].Substring(0, str[1].IndexOf(';')).ToString(); DataTable dtClass = new DataTable(); dtClass = TMSSchoolCategory.GetSearch(null, null, SchoolType.ToString(), null, 1).Tables[0]; List <CascadingDropDownNameValue> cascadingValues = new List <CascadingDropDownNameValue>(); for (int i = 0; i < dtClass.Rows.Count; i++) { string ClassId = dtClass.Rows[i]["SC_CategoryId"].ToString(); string ClassName = dtClass.Rows[i]["SC_CategoryName"].ToString(); cascadingValues.Add(new CascadingDropDownNameValue(ClassName, ClassId)); } return(cascadingValues.ToArray()); }
public static TMSSchoolCategory[] MapFrom(DataSet ds) { List <TMSSchoolCategory> objects; // Initialise Collection. objects = new List <TMSSchoolCategory>(); // Validation. if (ds == null) { throw new ApplicationException("Cannot map to dataset null."); } else if (ds.Tables[TABLE_NAME].Rows.Count == 0) { return(objects.ToArray()); } if (ds.Tables[TABLE_NAME] == null) { throw new ApplicationException("Cannot find table [dbo].[TMS_SchoolCategory] in DataSet."); } if (ds.Tables[TABLE_NAME].Rows.Count < 1) { throw new ApplicationException("Table [dbo].[TMS_SchoolCategory] is empty."); } // Map DataSet to Instance. foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows) { TMSSchoolCategory instance = new TMSSchoolCategory(); instance.MapFrom(dr); objects.Add(instance); } // Return collection. return(objects.ToArray()); }
public static DataSet GetSearch(TMSSchoolCategory searchObject) { return(GetSearch(searchObject.SCCategoryId, searchObject.SCCategoryName, searchObject.SCSchoolType, searchObject.SCDate, searchObject.SCStatus)); }
public static void Update(TMSSchoolCategory tMSSchoolCategory, DbTransaction transaction) { tMSSchoolCategory.Update(transaction); }
public static void Update(TMSSchoolCategory tMSSchoolCategory) { tMSSchoolCategory.Update(); }
public static DataSet GetSearch(TMSSchoolCategory searchObject) { return GetSearch(searchObject.SCCategoryId, searchObject.SCCategoryName, searchObject.SCSchoolType, searchObject.SCDate, searchObject.SCStatus); }
public static void Update(TMSSchoolCategory tMSSchoolCategory, DbTransaction transaction) { tMSSchoolCategory.Update(transaction); }
public static void Update(TMSSchoolCategory tMSSchoolCategory) { tMSSchoolCategory.Update(); }
public static TMSSchoolCategory[] MapFrom(DataSet ds) { List<TMSSchoolCategory> objects; // Initialise Collection. objects = new List<TMSSchoolCategory>(); // Validation. if (ds == null) throw new ApplicationException("Cannot map to dataset null."); else if (ds.Tables[TABLE_NAME].Rows.Count == 0) return objects.ToArray(); if (ds.Tables[TABLE_NAME] == null) throw new ApplicationException("Cannot find table [dbo].[TMS_SchoolCategory] in DataSet."); if (ds.Tables[TABLE_NAME].Rows.Count < 1) throw new ApplicationException("Table [dbo].[TMS_SchoolCategory] is empty."); // Map DataSet to Instance. foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows) { TMSSchoolCategory instance = new TMSSchoolCategory(); instance.MapFrom(dr); objects.Add(instance); } // Return collection. return objects.ToArray(); }
public static TMSSchoolCategory Get(System.Int64 scCategoryId) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; TMSSchoolCategory instance; instance = new TMSSchoolCategory(); db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSchoolCategory_SELECT"; dbCommand = db.GetStoredProcCommand(sqlCommand, scCategoryId); // Get results. ds = db.ExecuteDataSet(dbCommand); // Verification. if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSSchoolCategory ID:" + scCategoryId.ToString()+ " from Database."); // Return results. ds.Tables[0].TableName = TABLE_NAME; instance.MapFrom( ds.Tables[0].Rows[0] ); return instance; }