// 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();
}
}
/// <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;
}
/// <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
}
/// <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;
}
/// <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
}
/// <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
}
/// <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
}
/// <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
}
/// <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;
}
/// <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
}
/// <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
}
/// <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;
}
/// <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
}
/// <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
}
/// <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
}
/// <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
}
/// <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;
}
/// <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
}