/// <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); }
/// <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); }
/// <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); }
/// <summary> /// /// </summary> public VisitorCheckInForm() { InitializeComponent(); dal = new VisitorDAL(); ShowAccommodation(); }
/// <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)); }
/// <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)); }
public static int GetVRegNo() { return(VisitorDAL.GetVRegNo()); }