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;
}
}
