/// <summary>
/// Edit name
/// </summary>
/// <param name="obj"></param>
public void Edit(Roles obj)
{
string queryStr = "UPDATE role SET";
queryStr += string.Format(" " + RoleColumn.RoleName + " = '{0}'", obj.RoleName);
queryStr += string.Format(" WHERE " + RoleColumn.RoleId + " = '{0}'", obj.RoleId);
PosService.DataExecute(Username, Password, queryStr, ref errorString);
}
public void Edit(Users obj)
{
string queryStr = "UPDATE user SET";
queryStr += string.Format(" Pwd = '{0}'", obj.Pwd);
queryStr += string.Format(" ,LastLogin = '******'", obj.LastLogin);
queryStr += string.Format(" ,Status = '{0}'", obj.Status);
queryStr += string.Format(" ,ModifiedBy = '{0}'", obj.ModifiedBy);
queryStr += " ,ModifiedBy = NOW()";
queryStr += string.Format(" ,ModifiedBy = '{0}'", obj.ModifiedBy);
queryStr += string.Format(", '{0})'", obj.RoleId);
queryStr += string.Format(" WHERE UserId = '{0}'", obj.UserId);
PosService.DataExecute(Username, Password, queryStr, ref errorString);
}
public void Delete(string id, string stt)
{
string queryStr = string.Format("UPDATE user SET Status = '{0}' WHERE UserId = '{1}'", stt, id);
PosService.DataExecute(Username, Password, queryStr, ref errorString);
}
