public static TMSSpeciallizationSubject Get(System.Int64 sbSubjectId) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; TMSSpeciallizationSubject instance; instance = new TMSSpeciallizationSubject(); db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSpeciallizationSubject_SELECT"; dbCommand = db.GetStoredProcCommand(sqlCommand, sbSubjectId); // Get results. ds = db.ExecuteDataSet(dbCommand); // Verification. if (ds == null || ds.Tables[0].Rows.Count == 0) { throw new ApplicationException("Could not get TMSSpeciallizationSubject ID:" + sbSubjectId.ToString() + " from Database."); } // Return results. ds.Tables[0].TableName = TABLE_NAME; instance.MapFrom(ds.Tables[0].Rows[0]); return(instance); }
public static TMSSpeciallizationSubject[] Search(System.Int64?sbSubjectId, System.String sbSubjectName, System.DateTime?sbDate, System.Int32?sbStatus) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSpeciallizationSubject_SEARCH"; dbCommand = db.GetStoredProcCommand(sqlCommand, sbSubjectId, sbSubjectName, sbDate, sbStatus); ds = db.ExecuteDataSet(dbCommand); ds.Tables[0].TableName = TABLE_NAME; return(TMSSpeciallizationSubject.MapFrom(ds)); }
public static TMSSpeciallizationSubject[] MapFrom(DataSet ds) { List <TMSSpeciallizationSubject> objects; // Initialise Collection. objects = new List <TMSSpeciallizationSubject>(); // 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_SpeciallizationSubject] in DataSet."); } if (ds.Tables[TABLE_NAME].Rows.Count < 1) { throw new ApplicationException("Table [dbo].[TMS_SpeciallizationSubject] is empty."); } // Map DataSet to Instance. foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows) { TMSSpeciallizationSubject instance = new TMSSpeciallizationSubject(); instance.MapFrom(dr); objects.Add(instance); } // Return collection. return(objects.ToArray()); }
protected void fillCountry() { try { DataTable Dtaable = TMSCountry.GetSearch(null, null, null).Tables[0]; DataView Dv = new DataView(Dtaable); Dv.Sort = ("CNTR_Country ASC"); ddlCountry.DataSource = Dtaable; ddlCountry.DataTextField = "CNTR_Country"; ddlCountry.DataValueField = "CNTR_Id"; ddlCountry.DataBind(); ddlCountry.Items.Insert(0, new ListItem("Select", "-1")); DataTable dtSubject = TMSSpeciallizationSubject.GetSearch(null, null, null, 1).Tables[0]; DataView Dv1 = new DataView(dtSubject); Dv1.Sort = ("SB_SubjectName ASC"); ddlSpeciallization.DataSource = dtSubject; ddlSpeciallization.DataTextField = "SB_SubjectName"; ddlSpeciallization.DataValueField = "SB_SubjectId"; ddlSpeciallization.DataBind(); ddlSpeciallization.Items.Insert(0, new ListItem("Select", "Select")); //ddlSpeciallization.Items.Add(new ListItem("Select", "-1")); } catch (Exception ex) { } }
public static DataSet GetSearch(TMSSpeciallizationSubject searchObject) { return(GetSearch(searchObject.SBSubjectId, searchObject.SBSubjectName, searchObject.SBDate, searchObject.SBStatus)); }
public static DataSet GetSearch(TMSSpeciallizationSubject searchObject) { return GetSearch(searchObject.SBSubjectId, searchObject.SBSubjectName, searchObject.SBDate, searchObject.SBStatus); }
public static void Update(TMSSpeciallizationSubject tMSSpeciallizationSubject, DbTransaction transaction) { tMSSpeciallizationSubject.Update(transaction); }
public static void Update(TMSSpeciallizationSubject tMSSpeciallizationSubject) { tMSSpeciallizationSubject.Update(); }
public static TMSSpeciallizationSubject[] Search(TMSSpeciallizationSubject searchObject) { return Search ( searchObject.SBSubjectId, searchObject.SBSubjectName, searchObject.SBDate, searchObject.SBStatus); }
public static TMSSpeciallizationSubject[] MapFrom(DataSet ds) { List<TMSSpeciallizationSubject> objects; // Initialise Collection. objects = new List<TMSSpeciallizationSubject>(); // 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_SpeciallizationSubject] in DataSet."); if (ds.Tables[TABLE_NAME].Rows.Count < 1) throw new ApplicationException("Table [dbo].[TMS_SpeciallizationSubject] is empty."); // Map DataSet to Instance. foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows) { TMSSpeciallizationSubject instance = new TMSSpeciallizationSubject(); instance.MapFrom(dr); objects.Add(instance); } // Return collection. return objects.ToArray(); }
public static TMSSpeciallizationSubject Get(System.Int64 sbSubjectId) { DataSet ds; Database db; string sqlCommand; DbCommand dbCommand; TMSSpeciallizationSubject instance; instance = new TMSSpeciallizationSubject(); db = DatabaseFactory.CreateDatabase(); sqlCommand = "[dbo].gspTMSSpeciallizationSubject_SELECT"; dbCommand = db.GetStoredProcCommand(sqlCommand, sbSubjectId); // Get results. ds = db.ExecuteDataSet(dbCommand); // Verification. if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSSpeciallizationSubject ID:" + sbSubjectId.ToString()+ " from Database."); // Return results. ds.Tables[0].TableName = TABLE_NAME; instance.MapFrom( ds.Tables[0].Rows[0] ); return instance; }