Beispiel #1
0
        /// <summary>
        /// Deletes Record from Database.
        /// </summary>
        /// <param name="objVisitor">Object containing all data values.</param>
        /// <returns>boolean value True if Record is deleted successfully
        /// otherwise returns False.</returns>
        public static bool Delete(Visitor objVisitor)
        {
            bool recDel;

            recDel = VisitorDAL.Delete(objVisitor.DBID);
            return(recDel);
        }
Beispiel #2
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        //public static List<string> GetCompanys()
        //{
        //    return VisitorDAL.GetCompanys();
        //}

        public static string[] GetCompanys()
        {
            string[] objCompanyList = null;
            dTable = VisitorDAL.GetCompanys();

            if (dTable.Rows.Count > 0)
            {
                objCompanyList = dTable.AsEnumerable().Select(row => row.Field <string>("COMPANY")).ToArray();
            }
            return(objCompanyList);
        }
Beispiel #3
0
        /// <summary>
        /// Save Object Data into Database.
        /// </summary>
        /// <param name="objVisitor">Visitor Object containing property values.</param>
        /// <returns>Visitor Object to be Saved.</returns>
        public static bool Save(Visitor objVisitor, User objUser)
        {
            bool flgSave;

            try
            {
                using (TransactionScope objTScope = new TransactionScope(TransactionScopeOption.RequiresNew))
                {
                    if (objVisitor.IsEdited || objVisitor.IsNew)
                    {
                        VisitorDAL.Save(objVisitor, objUser);
                    }
                    flgSave = true;
                    objTScope.Complete();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return(flgSave);
        }
Beispiel #4
0
 /// <summary>
 ///
 /// </summary>
 public VisitorCheckInForm()
 {
     InitializeComponent();
     dal = new VisitorDAL();
     ShowAccommodation();
 }
Beispiel #5
0
 /// <summary>
 /// Retrieves Visitor Data from Database.
 /// </summary>
 /// <param name="dbid">unique id to identify record into database.</param>
 /// <returns>Visitor Object containing Data Values.</returns>
 public static Visitor GetItem(int dbid)
 {
     return(VisitorDAL.GetItem(dbid));
 }
Beispiel #6
0
 /// <summary>
 /// Retrieves Visitor List from Database.
 /// </summary>
 /// <param name="strWhere">Condition based on which List is retrieved.</param>
 /// <returns>Visitor List</returns>
 public static VisitorList GetList(string strCompany, string strContactNo)
 {
     return(VisitorDAL.GetList(strCompany, strContactNo));
 }
Beispiel #7
0
 public static int GetVRegNo()
 {
     return(VisitorDAL.GetVRegNo());
 }