Beispiel #1
0
        //         SqlConnectionStringBuilder csb;
        //string stDatabaseUser, stDatabasePass;


        //public string DatabasePassword
        //{
        //    get { return stDatabasePass; }
        //    //set { stDatabasePass = value; }
        //}

        //public string DatabaseUserName
        //{
        //    get { return stDatabaseUser; }
        //    //set { stDatabaseUser = value; }
        //}


        #endregion


        #region "User Details"
        public static tblUsersRow GetUserDetails(int UserID)
        {
            FMSDB db = new FMSDB();

            try
            {
                tblUsersRow objUserRow = new tblUsersRow();
                string      strCondition;
                strCondition = "";
                strCondition = "tblUsers.User_Id =" + UserID;
                DataTable dtUsers = db.tblUsersCollection.GetAsDataTable(strCondition, "User_Id");

                //System.Data.DataTable dt1 = db.tblUserCollection.GetAsDataTable(strCondition, "User_ID");
                if (dtUsers.Rows.Count > 0)
                {
                    //System.Data.DataRow dr = dt1.Rows[0];
                    objUserRow.User_Id   = Convert.ToInt16(dtUsers.Rows[0]["User_Id"]);
                    objUserRow.UserName  = Convert.ToString(dtUsers.Rows[0]["UserName"]);
                    objUserRow.FullName  = Convert.ToString(dtUsers.Rows[0]["FullName"]);
                    objUserRow.Password  = Convert.ToString(dtUsers.Rows[0]["Password"]);
                    objUserRow.Email     = Convert.ToString(dtUsers.Rows[0]["Email"]);
                    objUserRow.Role_Id   = Convert.ToInt32(dtUsers.Rows[0]["Role_Id"]);
                    objUserRow.IsDeleted = Convert.ToBoolean(dtUsers.Rows[0]["IsDeleted"]);
                    //objUserRow.CreationDt = Convert.ToDateTime(dt1.Rows[0]["CreationDt"]);
                    //objUserRow.LastModifiedDt = Convert.ToDateTime(dt1.Rows[0]["LastModifiedDt"]);
                    return(objUserRow);
                }
                else
                {
                    return(null);
                }
            }
            finally
            {
                db.Dispose();
            }
        }
Beispiel #2
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblcompanyCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblcompanyCollection_Base(FMSDB db)
 {
     _db = db;
 }
Beispiel #3
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblPaymentCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblPaymentCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblFundCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblFundCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #5
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblCurrencyCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblCurrencyCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblDonor_ContactCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblDonor_ContactCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblVendorCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblVendorCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblGL_AccountCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblGL_AccountCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblUsersCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblUsersCollection_Base(FMSDB db)
 {
     _db = db;
 }
Beispiel #10
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblGL_AccountCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblGL_AccountCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #11
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblUsersCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblUsersCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblBudgetCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblBudgetCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblPaymentCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblPaymentCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #14
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblGL_Act_TypeCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblGL_Act_TypeCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #15
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblItem_TypeCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblItem_TypeCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblCurrencyCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblCurrencyCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #17
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblDonor_TypeCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblDonor_TypeCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblInvoice_DetailCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblInvoice_DetailCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblRecentLogCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblRecentLogCollection_Base(FMSDB db)
 {
     _db = db;
 }
Beispiel #20
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblInvoice_DetailCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblInvoice_DetailCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #21
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblVendor_TypeCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblVendor_TypeCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #22
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblGeneral_JournalCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblGeneral_JournalCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblFundCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblFundCollection_Base(FMSDB db)
 {
     _db = db;
 }
Beispiel #24
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblItem_TypeCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblItem_TypeCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #25
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblRoleCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblRoleCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #26
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblRoleCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblRoleCollection_Base(FMSDB db)
 {
     _db = db;
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="tblRecentLogCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblRecentLogCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #28
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblcompanyCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblcompanyCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }
Beispiel #29
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblExchange_RateCollection_Base"/>
 /// class with the specified <see cref="FMSDB"/>.
 /// </summary>
 /// <param name="db">The <see cref="FMSDB"/> object.</param>
 public tblExchange_RateCollection_Base(FMSDB db)
 {
     _db = db;
 }
Beispiel #30
0
 /// <summary>
 /// Initializes a new instance of the <see cref="tblDonorCollection"/> class.
 /// </summary>
 /// <param name="db">The database object.</param>
 internal tblDonorCollection(FMSDB db)
     : base(db)
 {
     // EMPTY
 }