Пример #1
0
 public static DataSet GetSearch(TMSAdminUser searchObject)
 {
     return(GetSearch(searchObject.AdminId, searchObject.AdminFirstName, searchObject.AdminMiddleName, searchObject.AdminLastName, searchObject.AdminEmailId, searchObject.AdminUserName, searchObject.AdminPassword, searchObject.AdminType, searchObject.AdminFDLoginId, searchObject.AdminFDFacultyId, searchObject.AdminTitle, searchObject.AdminCaste, searchObject.AdminSubCaste, searchObject.AdminBirthPlace, searchObject.AdminBloodGroup, searchObject.AdminMotherTongue, searchObject.AdminNationality, searchObject.AdminTransportStatus, searchObject.AdminMedicalProblem, searchObject.AdminSchoolCategoryId, searchObject.AdminSchoolSubCategoryId, searchObject.AdminSubjectId, searchObject.AdminInterestPosition, searchObject.AdminCertifiedSubject, searchObject.AdminCertifiedAgeGroup, searchObject.AdminFullTimeTeaching, searchObject.AdminIndustryExpertise, searchObject.AdminSpecificExpertise, searchObject.AdminHighestDegreeCompletd, searchObject.AdminFieldOfStudy, searchObject.AdminUniversity, searchObject.AdminCompletionDate, searchObject.AdminAddressId, searchObject.AdminQualificationDetails, searchObject.AdminExperienceFrom, searchObject.AdminExperienceTo, searchObject.AdminExperienceInYrs, searchObject.AdminImage, searchObject.AdminJoiningDate, searchObject.AdminBirthDate, searchObject.AdminGender, searchObject.AdminMarrialStatus, searchObject.AdminAgeProof, searchObject.AdminResume, searchObject.AdminReleavingLetter, searchObject.AdminRetiredOn, searchObject.AdminExtraOne, searchObject.AdminCreatedBy, searchObject.AdminLastSchoolwas, searchObject.AdminLastSchoolFromDate, searchObject.AdminLastSchoolToDate, searchObject.AdminRegisteredDate, searchObject.AdminStatus, searchObject.AdminDeletedStatus));
 }
Пример #2
0
 public static DataSet GetSearch(TMSAdminUser searchObject)
 {
     return GetSearch(searchObject.AdminId, searchObject.AdminFirstName, searchObject.AdminMiddleName, searchObject.AdminLastName, searchObject.AdminEmailId, searchObject.AdminUserName, searchObject.AdminPassword, searchObject.AdminType, searchObject.AdminFDLoginId, searchObject.AdminFDFacultyId, searchObject.AdminTitle, searchObject.AdminCaste, searchObject.AdminSubCaste, searchObject.AdminBirthPlace, searchObject.AdminBloodGroup, searchObject.AdminMotherTongue, searchObject.AdminNationality, searchObject.AdminTransportStatus, searchObject.AdminMedicalProblem, searchObject.AdminSchoolCategoryId, searchObject.AdminSchoolSubCategoryId, searchObject.AdminSubjectId, searchObject.AdminInterestPosition, searchObject.AdminCertifiedSubject, searchObject.AdminCertifiedAgeGroup, searchObject.AdminFullTimeTeaching, searchObject.AdminIndustryExpertise, searchObject.AdminSpecificExpertise, searchObject.AdminHighestDegreeCompletd, searchObject.AdminFieldOfStudy, searchObject.AdminUniversity, searchObject.AdminCompletionDate, searchObject.AdminAddressId, searchObject.AdminQualificationDetails, searchObject.AdminExperienceFrom, searchObject.AdminExperienceTo, searchObject.AdminExperienceInYrs, searchObject.AdminImage, searchObject.AdminJoiningDate, searchObject.AdminBirthDate, searchObject.AdminGender, searchObject.AdminMarrialStatus, searchObject.AdminAgeProof, searchObject.AdminResume, searchObject.AdminReleavingLetter, searchObject.AdminRetiredOn, searchObject.AdminExtraOne, searchObject.AdminCreatedBy, searchObject.AdminLastSchoolwas, searchObject.AdminLastSchoolFromDate, searchObject.AdminLastSchoolToDate, searchObject.AdminRegisteredDate, searchObject.AdminStatus, searchObject.AdminDeletedStatus);
 }
 public static void Update(TMSAdminUser tMSAdminUser, DbTransaction transaction)
 {
     tMSAdminUser.Update(transaction);
 }
 public static void Update(TMSAdminUser tMSAdminUser)
 {
     tMSAdminUser.Update();
 }
    public static TMSAdminUser[] MapFrom(DataSet ds)
    {
        List<TMSAdminUser> objects;

        // Initialise Collection.
        objects = new List<TMSAdminUser>();

        // 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_AdminUser] in DataSet.");

        if (ds.Tables[TABLE_NAME].Rows.Count < 1)
            throw new ApplicationException("Table [dbo].[TMS_AdminUser] is empty.");

        // Map DataSet to Instance.
        foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
        {
            TMSAdminUser instance = new TMSAdminUser();
            instance.MapFrom(dr);
            objects.Add(instance);
        }

        // Return collection.
        return objects.ToArray();
    }
    public static TMSAdminUser Get(System.Int32 adminId)
    {
        DataSet ds;
        Database db;
        string sqlCommand;
        DbCommand dbCommand;
        TMSAdminUser instance;

        instance = new TMSAdminUser();

        db = DatabaseFactory.CreateDatabase();
        sqlCommand = "[dbo].gspTMSAdminUser_SELECT";
        dbCommand = db.GetStoredProcCommand(sqlCommand, adminId);

        // Get results.
        ds = db.ExecuteDataSet(dbCommand);
        // Verification.
        if (ds == null || ds.Tables[0].Rows.Count == 0) //throw new ApplicationException("Could not get TMSAdminUser ID:" + adminId.ToString()+ " from Database.");
            // Return results.
            return null;
        ds.Tables[0].TableName = TABLE_NAME;

        instance.MapFrom(ds.Tables[0].Rows[0]);
        return instance;
    }