public int UpdatePOSUserCredential(string Password) { try { SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@Password", Password); return(conn.executeUpdateQuery("sp_InsertOrUpdate_POS_Login", sqlParameters)); } catch (Exception e) { throw e; } }
public int InsertOrUpdateHub(Hub hub) { try { SqlParameter[] sqlParameters = new SqlParameter[9]; sqlParameters[0] = new SqlParameter("@id", hub.Id); sqlParameters[1] = new SqlParameter("@name", string.IsNullOrEmpty(hub.Name) ? "" : hub.Name); sqlParameters[2] = new SqlParameter("@note", string.IsNullOrEmpty(hub.Note) ? "" : hub.Note); sqlParameters[3] = new SqlParameter("@address", string.IsNullOrEmpty(hub.Address) ? "" : hub.Address); sqlParameters[4] = new SqlParameter("@active", hub.Active); sqlParameters[5] = new SqlParameter("@frequency", hub.Frequency); sqlParameters[6] = new SqlParameter("@macaddress", string.IsNullOrEmpty(hub.MacAddress) ? "" : hub.MacAddress); sqlParameters[7] = new SqlParameter("@ipaddress", string.IsNullOrEmpty(hub.IPAddress) ? "" : hub.IPAddress); sqlParameters[8] = new SqlParameter("@tcpport", hub.TCPPort); return(conn.executeUpdateQuery("sp_InsertOrUpdateHub", sqlParameters)); } catch (Exception e) { throw e; } }
public int UpdateSettings(int id, string name, string caption, string description, string defaultvalue, string type, string screenGroup, string updatedby, bool active, bool userLevel, bool posLevel) { try { SqlParameter[] sqlParameters = new SqlParameter[11]; sqlParameters[0] = new SqlParameter("@id", id); sqlParameters[1] = new SqlParameter("@name", name); sqlParameters[2] = new SqlParameter("@description", description); sqlParameters[3] = new SqlParameter("@defaultvalue", defaultvalue); sqlParameters[4] = new SqlParameter("@type", type); sqlParameters[5] = new SqlParameter("@screengroup", screenGroup); sqlParameters[6] = new SqlParameter("@active", active); sqlParameters[7] = new SqlParameter("@userlevel", userLevel); sqlParameters[8] = new SqlParameter("@poslevel", posLevel); sqlParameters[9] = new SqlParameter("@updatedby", updatedby); sqlParameters[10] = new SqlParameter("@caption", caption); return(conn.executeUpdateQuery("sp_UpdateSettings", sqlParameters)); } catch (Exception e) { throw e; } }