public static TMSTransportStaff Get(System.Int64 tpId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSTransportStaff instance;
instance = new TMSTransportStaff();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSTransportStaff_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, tpId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSTransportStaff ID:" + tpId.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
public static TMSTransportStaff[] Search(System.Int64?tpId, System.Int64?tpLoginID, System.Int64?tpUsertype, System.String tpFirstName, System.String tpMiddleName, System.String tpLastName, System.String tpPhoto, System.DateTime?tpDob, System.String tpCaste, System.String tpSubCaste, System.String tpBirthPlace, System.String tpGender, System.String tpBloodGroup, System.String tpMotherTongue, System.DateTime?tpDoj, System.String tpHighestDegree, System.String tpCompletedYear, System.String tpUniversity, System.Int64?tpAddressId, System.String tpAgeproof, System.String tpReleavingLetter, System.String tpResume, System.Int32?tpStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSTransportStaff_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, tpId, tpLoginID, tpUsertype, tpFirstName, tpMiddleName, tpLastName, tpPhoto, tpDob, tpCaste, tpSubCaste, tpBirthPlace, tpGender, tpBloodGroup, tpMotherTongue, tpDoj, tpHighestDegree, tpCompletedYear, tpUniversity, tpAddressId, tpAgeproof, tpReleavingLetter, tpResume, tpStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSTransportStaff.MapFrom(ds));
}
public static TMSTransportStaff[] MapFrom(DataSet ds)
{
List <TMSTransportStaff> objects;
// Initialise Collection.
objects = new List <TMSTransportStaff>();
// 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_TransportStaff] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_TransportStaff] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSTransportStaff instance = new TMSTransportStaff();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static void Update(TMSTransportStaff tMSTransportStaff, DbTransaction transaction)
{
tMSTransportStaff.Update(transaction);
}
public static void Update(TMSTransportStaff tMSTransportStaff)
{
tMSTransportStaff.Update();
}
public static TMSTransportStaff[] Search(TMSTransportStaff searchObject)
{
return Search ( searchObject.TpId, searchObject.TPLoginID, searchObject.TPUsertype, searchObject.TPFirstName, searchObject.TPMiddleName, searchObject.TPLastName, searchObject.TPPhoto, searchObject.TpDob, searchObject.TPCaste, searchObject.TPSubCaste, searchObject.TPBirthPlace, searchObject.TPGender, searchObject.TPBloodGroup, searchObject.TPMotherTongue, searchObject.TpDoj, searchObject.TPHighestDegree, searchObject.TPCompletedYear, searchObject.TPUniversity, searchObject.TPAddressId, searchObject.TPAgeproof, searchObject.TPReleavingLetter, searchObject.TPResume, searchObject.TPStatus);
}
public static TMSTransportStaff[] MapFrom(DataSet ds)
{
List<TMSTransportStaff> objects;
// Initialise Collection.
objects = new List<TMSTransportStaff>();
// 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_TransportStaff] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_TransportStaff] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSTransportStaff instance = new TMSTransportStaff();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSTransportStaff Get(System.Int64 tpId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSTransportStaff instance;
instance = new TMSTransportStaff();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSTransportStaff_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, tpId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSTransportStaff ID:" + tpId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
public static TMSTransportStaff[] Search(TMSTransportStaff searchObject)
{
return(Search(searchObject.TpId, searchObject.TPLoginID, searchObject.TPUsertype, searchObject.TPFirstName, searchObject.TPMiddleName, searchObject.TPLastName, searchObject.TPPhoto, searchObject.TpDob, searchObject.TPCaste, searchObject.TPSubCaste, searchObject.TPBirthPlace, searchObject.TPGender, searchObject.TPBloodGroup, searchObject.TPMotherTongue, searchObject.TpDoj, searchObject.TPHighestDegree, searchObject.TPCompletedYear, searchObject.TPUniversity, searchObject.TPAddressId, searchObject.TPAgeproof, searchObject.TPReleavingLetter, searchObject.TPResume, searchObject.TPStatus));
}
public static void Update(TMSTransportStaff tMSTransportStaff, DbTransaction transaction)
{
tMSTransportStaff.Update(transaction);
}
public static void Update(TMSTransportStaff tMSTransportStaff)
{
tMSTransportStaff.Update();
}
